ORACLE Database Architect
tuning on production/development application
LANGUAGES
French
Adequate level of written and spoken German and English
EDUCATION
Maîtrise ès Sciences (Master’s degree) in computer science (Metz university - France).
Fields of study: Database design and conception; applicated mathematics (statistics; logical science).
PERSONNEL
French citizen.
BOUYGUES TELECOM - Paris : January 2001 – October 2004
ORACLE Database Architect for DataWareHouse in one telecom operator company
- Technical support level 3 for 4 Very Large Production Data Bases ( 1 to 3 Terabytes )
- Project leader for Migration from Rule Based to Cost Based Optimizer
- Project leader for Migration 7343 to 8172 and 8172 to 9124
- Project leader for partitioning and slide history tables, representing 180 Gigabytes
- Technical support level 2 for development projects (modeling and design strategy)
- database tuning with statpack , bstat/estat , sqltrace
- sql code tuning with hints , analytic functions , parallel degree
- architecture strategy : materialized views with different refresh types , dblinks , exp/imp , sql*loader
AIX and HP Unix systems . OEM , TOAD - ETL Synopsys - Design with AMC
Oracle V7 V8 V9
SFF - Paris : July 2000 – January 2001
Oracle Database Manager for a factoring company (test, pre-production and production DB)
- Project leader for backup / recovery stategy
- Project leader for stopping the Oracle database (migration to Informix database)
- Technical support level 2 for developments projects
HP Unix systems . Netbackup . Omniback , TOAD
Oracle V7 , V8
Orange Communication - Lausanne : September 1999 - April 2000
Oracle Database Administrator for a mobile operator (test and production DB)
- AMDOCS environment (billing Software)
- Training to Oracle specification in the billing software
- Project leader in the modification of the number of bill cycles : we passed from 4 to 8, implicatiog a lot of new technical objects creation
HP Unix and Windows NT systems , TOAD
Oracle V7
Jumbo - Zurich: November 1998 – August 1999
Oracle Database Administrator for a retail company (Carrefour group)
- Database creation and maintenance
- Project leader on backup / recovery strategy
- Project leader on bar-code edition
- Technical support for new PL/SQL procedures , imp/exp , sql*loader
AIX Unix and Windows NT systems. TOAD
Oracle V7
Lyonnaise des Eaux - Paris: November 1997 – October 1998
Senior Analyst on SURF application for a water service company
- end-users interviews
- conceptuel data model creation
- pilote screens realisation
Windows NT systems.
Oracle V7 with developer/designer 2000
Sofrecom (France Telecom ) – Paris: May 1994 – October 1997
Oracle ingeneer for a telephone operator
- involved on Girafe system, billing and management software
- DBA on mirror machine (Vanuatu , Mozambiqua , Qatar)
- creation of screens with sal*forms
- creation of report with sql*report , pro*c , sql*plus
- Missions : 3 in Bangkok (Thailand) , 1 in Port-Vila (Vanuatu) , 1 in Doha (Qatar) ,
- 2 in Saint-Pierre (french island near East of Canada), 1 in Papeete (TAHITI)
HP Unix and VMS systems.
Oracle V6, V7
Cogema - Paris: July 1993 – April 1994
Analyst for a french nuclear company
- Conceptual designer with MERISE methodology ;
- End-users interviews
- Screen programming with Visual-Basic V7
- Realisation of database links
Unix system.
France Telecom – Paris : January 1991 - June 1993
Oracle Programmer for a telephone company
- Programmer using pro*c , shell , sql
- Realisation of a billing software for sattelic communications
Bull Unix system
Oracle V6
Caisse d´Epargne – Paris : September 1989 - December 1990
Oracle Programmer for a bank
- Programmer using sal*forms
- Realisation of software calculating the capital/interest reemboursment
Unix system
Oracle V5 V6