Mohamed - Chef de projet AIX

 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

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

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.

Production DBA DB2 UDB on AIX

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

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

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

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.