Frederick - DBA ORACLE

Expérience professionnelle

1 Sql Server 2005 – Administration TechnofuturTIC 02/2010 : 4 days

2 Sql Server 2005 – Transact SQL TechnofuturTIC 01/2010 : 3 days

3 Oracle Application Server 10g R2 : Administration Oracle University 08/2007 : 5 days

4 Sunopsis – ETL Tool Touring 02/2006 : 5 days

5 PL/SQL – Tuning & best practices Touring 12/2005 : 3 days

6 DBA course : Performance Tuning Oracle University 02/2005 : 5 days

7 Oracle DBA course : Fundamentals 2 Oracle University 11/2004 : 5 days

8 Oracle DBA course : Fundamentals 1 Oracle University 10/2004 : 5 days

9 Oracle « Java(2) : Server-Side Java Technologies » Oracle University 08/2003 : 5 days

10 Oracle Java(1) : Intense Introduction to Java Oracle University 08/2003 : 5 days

11 Oracle : Sauvegarde & Restauration Oratech 11/2001 : 3 days

12 Oracle : Administration Oratech 10/2001 : 5 days

13 Continuus : Developer & Build Manager (configuration management) Continous Software 03/2000 : 4 days

Project name: Apollo
Company (employer): Getronics S.A.
Dates (start-end):
Effective number of months achieved: 11/2011 – 04/2013
Client (customer) : Bpost Banque
Project size:
Project description : New financial system

Employee’s Roles & Responsibilities in the project:
Administration of the databases of the new project Apollo (including SAP databases)
Technologies and methodologies used by the employee in the project:
Oracle databases 10G / 11G – RMAN – Data Guard - SQL*Plus – SQL – PL/SQL – GRID – BRTOOLS (SAP TOOLS) – SQL Developer

PROJECT EXPERIENCE
Project name: ITSS
Company (employer): Aubay through Serco Belgium S.A.
Dates (start-end):
Effective number of months achieved: 08/2007 – 11/2011
Client (customer) : European Commission – DG EMPL
Project size:
Project description :
This contract is based on the provision of external Service Providers to the DGs of the European Commission, as well as some of the associated offices. The contract provides a range of 8 different profiles form Local Logistics Support up to Database Administration with various levels based on technical experience and industry recognised certification. Today Serco is providing in excess of 170 staff to the European Commission across five countries.
Employee’s Roles & Responsibilities in the project:
Administration of the DG EMPL’s databases :
RMAN backups / exports
To provide assistance to the delevopers (schema creation, grant, …) and to solve theirs problems related to the databases…
Software installation and upgrade / Patchs
Business Continuity Plan (BCP) tasks :
Implementation of Data Guard (Physical Standby Databases)
 Oracle Data Guard is the management, monitoring, and automation software infrastructure that creates, maintains, and monitors one or more standby databases to protect enterprise data from failures, disasters, errors, and corruptions.
Sharepoint project : Management of Sql Server databases.
Technologies and methodologies used by the employee in the project:
Oracle databases 9, 10G – RMAN – Data Guard - SQL*Plus – SQL – PL/SQL – OEM – SQL Server 2008

PROJECT EXPERIENCE
Project name: APEX
Company (employer): Sword Technologies
Dates (start-end):
Effective number of months achieved: 04/2007 – 07/2007 : 4 months
Client (customer) : RTBF
Project size:
Project description :
RTBF Databases for APEX
Rewriting of internal management applications using APEX : CAP48 – MUSIQ3 – DGRH - …
Employee’s Roles & Responsibilities in the project:
Administration of the APEX application databases (Application Express – Oracle)
Data import from external sources (flat files) using SQL Loader and PL/SQL scripts
Development and maintenance of APEX modules
Technologies and methodologies used by the employee in the project:
Oracle 10G, SQL Loader, TOAD, SQL*Plus
APEX : Oracle RAD tool

PROJECT EXPERIENCE
Project name: N/A (many projects)
Company (employer): Touring ASBL
Dates (start-end):
Effective number of months achieved: 03/2004 – 03/2007 : 37 months
Client (customer) : N/A (Internal position)
Project size:
Project description :
Back-office project (development for the Back-office users…)
Touring databases
Employee’s Roles & Responsibilities in the project:
Database administration (application software side): user privilege management, session monitoring, request optimisation, data import from external sources (flat files) using SQL Loader and PL/SQL scripts
Database backup & recovery operation (test of the backup sets using RMAN)
Development of PL/SQL scripts upon request from the Back-office
Corrective maintenance of client application written in PowerBuilder
Evolutionary maintenance : analysis of user needs, development of the requested modules upon customer approval
Technologies and methodologies used by the employee in the project:
Oracle 9-10
SQL – PL/SQL – SQLLoader -TOAD
Oracle Administration : Quest Central (with Spotlight), Oracle Enterprise Manager (OEM), RMAN

PROJECT EXPERIENCE
Project name: UME2
Company (employer): ATOS ORIGIN
Dates (start-end):
Effective number of months achieved: 05/2003 – 02/2004 : 10 months
Client (customer) : Belgian Government
Project size:
Project description :
UME2 : Message bus for the exchanges of information between federal departments
Employee’s Roles & Responsibilities in the project:
PL/SQL development
Oracle Task Manager (DBMS_JOBS) configuration
Organisation and execution of test scenarios
Technologies and methodologies used by the employee in the project:
Windows 2000, Linux
BEA WebLogic application server
Oracle 8, TOAD, SQL*Plus, PL/SQL
Java platform (J2EE), XML

PROJECT EXPERIENCE
Project name: CETO - Phoenix
Company (employer): ATOS ORIGIN
Dates (start-end):
Effective number of months achieved: 08/2001 – 04/2003 : 21 months
Client (customer) : European Commission – DG INFSO
Project size:
Project description :
Management of contracts following requests of subsidies (Information Society Technologies program)
CETO : FP4 (Framework program 4) & FP5 management
PHOENIX : FP6 management
Employee’s Roles & Responsibilities in the project:
Development – maintenance – database administration (CETO information system)
Development of the first prototype of the Phoenix information system
Technologies and methodologies used by the employee in the project:
PowerBuilder 6
Oracle
CAST (Reverse engineering of CETO information system)

PROJECT EXPERIENCE
Project name: SIA Commerce
Company (employer): ATOS ORIGIN
Dates (start-end):
Effective number of months achieved: 03/2000 – 07/2001 : 17 months
Client (customer) : AUCHAN group
Project size:
Project description :
Full rewriting of the information system of Auchan (Supplier application, stock application, …)
Employee’s Roles & Responsibilities in the project:
Configuration Management
Development and maintenance
Oracle: loading of PL/SQL packages, test, delivery
Technologies and methodologies used by the employee in the project:
Continuus, Visual Basic, Informix, Oracle, PL/SQL, PowerBuilder

PROJECT EXPERIENCE
Project name: COMEXT
Company (employer): ATOS ORIGIN
Dates (start-end):
Effective number of months achieved: 12/1999 – 02/2000 : 3 months
Client (customer) : Ministère de Bruxelles Capitale
Project size:
Project description :
COMEXT application : “commerce extérieur”  outside business management
Employee’s Roles & Responsibilities in the project:
Development and maintenance of the COMEXT information system
Technologies and methodologies used by the employee in the project:
PowerBuilder, Oracle, Ms-Access, SQL, PL/SQL, SQLLoader

PROJECT EXPERIENCE
Project name: Y2K - update
Company (employer): SOPRA
Dates (start-end):
Effective number of months achieved: 09/1998 – 11/1999 : 15 months
Client (customer) : European Commission, Secrétariat Général
Project size:
Project description :
Rewriting of applications to ensure Y2K compliance (petitions management, trainees management, …)
Employee’s Roles & Responsibilities in the project:
Large update of PowerBuilder applications in order to make them Y2K compatible
Technologies and methodologies used by the employee in the project:
PowerBuilder 5 (PFC), Oracle 7, SQL, Windows NT