Development DBA DB2 UDB and LDAP on Windows 2003 and SAN
Build from scratch of a WebSphere/J2EE e-Government web site solution to the Saudi Arabia Ministry of Interior.
Infrastructure using WebSphere Application Server, WebSphere Portal Server, WebSphere Business Integrator, Workplace Web Content Management, Workplace Messaging, IBM Edge Server, IBM Http Server, IBM Directory Server, DB2 and MQ Series
I am responsible of IBM (DB2 and Informix) database and Directory Server LDAP application software, their design, implementation and operation in environments like Development, QA and Production. Development and deployment of operational procedures related to the management of all environments, documentation and designs that interface with other teams.
Involvement in the E-Government design solution associated to the design of a Private Key Infrastructure solution. Design of a DRDA middleware to support data communication from Portal to mainframe environment. Exceptional challenging environment with the implementation of a High Availability solution using MSCS and DB2 Partitioning in a mutual takeover function associated with a Disaster Recovery capability based on HP XP1200 environment using Data Protector
Production DBA DB2 UDB and Informatica on AIX
IBM Global Services (Nice, France)
octobre 2001 - janvier 2005
Operation of a data warehouse (14 terabytes) and data mart information system in an IBM Data centre for Danone World Corporation.
This information system was built in order to provide daily refreshed financial and industrial data to more than 16 countries within an outsourcing context.
DB2 Database Administration and Tuning were performed in a production context and the alert monitoring through an Operation department.
Administration and exploitation of Informatica repository, folder and session objects
Delivery of DB2 tablespaces and AIX file systems space growth forecast and server capacity planning.
Annual disk layout revamping survey for performance system improvement
Implementation of Database Disaster Recovery capability (with backup online, restore redirect and log roll forward using TSM (Tivoli Storage Management) through HACMP.
Management of productions applications batches using TWS (Tivoli Workload Scheduler).
Authorship of DB2 (EE, EEE), Informatica, Essbase operation procedures and User Guidelines.
Performance tuning and Production Systems Support for a DB2 environment on AIX 4.3.3 and AIX Regatta.
Design of onsite recovery system. Implementation of programmed procedures to maintain database performance and audit ability.
Daily checks, investigation problem and resolution for developers and project teams.
Usually on-call by period of one week per month and often on week-end
Project Manager LIMS (Lab Manager) Oracle on HP
BECKMAN-COULTER Corporation (Europe and US) -
mai 1999 - juillet 2001
Implementation from scratch and/or operation of existing E.R.P Laboratory Interface Management system (L.I.M.S) for pharmaceutical customers as Novartis (Genève), Astra-Zeneca, FoulSpringer and SITRA in France …
As a Bio-Informatics Project Manager, I wrote requirement functional, functional design, technical design specifications deliverable documents in accordance to the customer business rules.
I performed the entire installation of E.R.P Laboratory Interface Management system (L.I.M.S) on top of Oracle 8i for Windows NT, VMS or HP-UNIX operating system.
I delivered the administration procedures for production operation.
I prepared and participated in several L.I.M.S marketing events and user groups meetings in Berlin, Cannes and New York.
Technical planning for a data and application migration from DB2/OS390 mainframe
to AIX environments for Euler-Sfac entity.
Database consulting to review and advise changes required to re-design database architecture. Review of DB2 Standards & Guidelines and advice on RS/6000 System environment requirements for migration of high volume Back Office Applications from DB2 V4 MVS to DB2 UDB / AIX.
Design and Test System Migration procedures for upgrade of Multi-Gb DB2 databases
Development Support DBA DB2 C/S and MQ Series on OS/390 and OS/2 warp
GROUPAMA/ GAN Insurance group (Paris, France)
mai 1998 - novembre 1998
Implementation from scratch of a IBM distributed database architecture based on the DRDA concept. Presentation and training of the Development teams and
I trained and assisted infrastructure system departments in the use of DB2, SQL, MQ-Series on top of MVS in transactional CICS environment.
Provision of documentation standards
Development and stress test environments
Normalisation procedures and DBA functions
Support of production and development DB2 Subsystems including administration Support and System Monitoring using BMC, Omegamon, Platinum and Boole & Babagge software.
Daily checks, investigation and problem resolution for developers and project teams
mainframe Consultant CA ACF2 on MVS
RENAULT company (Paris, France)
janvier 1998 - avril 1998
I was part of a Single-Sign-On facility implementation program to allow thousand of end-users around the world to get access to their several business applications by using unique credential.
I did actively participate in the realisation of an internal communication campaign to promote the project across the company user population before the live implementation.
DBA DB2 DRDA on MVS and OS/2 platform developer and trainer
G.E.T.I.M.A public insurance (Paris)
décembre 1996 - décembre 1997
Implementation from scratch of a IBM distributed database architecture based on the DRDA concept. Presentation and training of the Development teams and
I provided DB2 product education to production and development team in delivering specific DB2 courses about all new functionalities as stored procedures, UDT, UDF …
I developed a Stress Testing System and delivered to the customer proof of concept using Cobol Microfocus pilot programs.
Études et formations
Business Intelligence Course at Informatica Education
Center (Nice - France)
2002
Oracle DBA formation at the Oracle
University (Paris - France)
2000
Certified IBM developer DB2 C/S
(Paris - France)
1997
French Military Service
(Army Montpellier - France)
1996
Master Degree of Information System
(University Avignon - France)
1995
Langues
Français - C2
Anglais - B2
Arabe - A2
Espagnol - A1
Autres compétences
EDUCATION
1994 Master Degree of Biochemistry and Biology Engineering
(University Marseille France)
1993 Master Degree of Biochemistry (University Grenoble - France)
COMMUNICATION
French language as a mother tongue
English language fluent
Arabic notions