Marc - Consultant SQL

Database Consultant (Freelance) , FPS Justice

- Design, install, and manage large Oracle based infrastructure (Real Application Cluster, Active
DataGuard) including patching, RMAN/Tivoli TDPO backups, Performance Monitoring and
Tuning/Troubleshooting (instance, SQL)
- Database migration from 10g to Oracle 11gR2 of 40 production instances running in 24x7x365
- Database architecture (infrastructure + data model) of new Criminal Record application, including
development of data conversion and transformation logic (PL/SQL, SQL*Loader and Unix scripts)
from former BS2000/Cobol platform
- Deployment of Enterprise Manager Cloud Control 12c for complete end-to-end business
application monitoring of a large hybrid system (700 targets incl. IBM AIX/PowerHA clusters,
Oracle DB, Weblogic servers,.. ) and Incident Management set-up
- Day-to-Day management of WebLogic, Oracle Portal, and Oracle Application Servers components

Oracle Database Specialist , Bull

- Day-to-Day support of about 20 Oracle RAC Databases (2-nodes RAC extended clusters) including
patching, RMAN/Tivoli TDPO backups, Performance Monitoring (OEM Grid) and
Tuning/Troubleshooting (instance, SQL) …
- Database infrastructure installation, configuration, and administration for the Oracle Collaboration
Suite in a highly available environment involving 2-nodes stretched cluster Oracle RAC 10gR2 and
ASM (3 Terabytes Database ; 20.000 concurrent users)
- PL/SQL development for Mail server-side rules (OCS) and Identity Management solutions
- Single instance (9i, OS filesystem) migration to RAC - ASM 10gR2 and HACMP cluster
- Implementation of Enterprise Manager Grid Control 10gR2 for monitoring complex Oracle
environment (more than 300 targets including dozen of 2-nodes extended RAC, multiple ASM and
single DB instances, complete Oracle Application Server architecture and Oracle Collaboration
Suite)
- Oracle Application Server installation, configuration and administration in a highly available
environment involving Portal, WebCache, SSO and Oracle Internet Directory clusters.

- Project leader for Real Application Cluster 10gR2, Data Guard 9iR2, Backup/Recovery (RMAN,
Legato) , Enterprise Manager Grid Control 10gR2, New features 9i and 10g support, Data
Warehouse design
- Day-to-day administration of Oracle Databases including install / upgrade database, monitor
instances and hosts performance, SQL optimization, host scripting (ksh, dos), schema design, …
and so on.
- Support for development team for PL/SQL stored procedures & packages

Database Administrator, Reprobel

- Technical leader of Database and Development Team (5 persons)
- Database Administration from installation, upgrade to performance tuning of Oracle (8-8i-9i) and
SQL Server (2000)
- Database Development including Web application (Oracle Portal, mod_plsql, ASP and VB .NET),
business logics implementation with PL/SQL packages, Reporting with Crystal Reports and
Excel/VBA
- Configuring gateways between Oracle 8i and MS-SQL Server 2000 (Oracle Heterogeneous Services)


• 01/12/2000 – 05/15/2001 : Analyst-Developer, AXA Royale Belge

• 07/13/2000 – 12/01/2000 : Analyst-Developer , Zurich Insurance

• 08/10/1998 – 07/12/2000 : Analyst-Developer, Les Assurances Fédérales