François LANGE

Senior Oracle Data Base Administrator Certified for different customers including “Centre Informatique de l’Etat” and also for some internal projects.
Tasks:
* The entire DBA task on Unix Sun Solaris, Linux and Windows XP.
* Oracle Spatial (GIS) Administration, Tuning, Data Loading and Data Validation.
* Train junior DBA. Xavier Bréviere, Matthieu Christophe.
* Database Migration up to 9.0.2.6 and 10GR2.
* Procedure standardization, automation and documentation.
* To actively participate in the meetings.
* To follow up on projects and management requests.
* Verifying, testing and set up in production, the deliveries produced by outside companies dealing with Oracle. Service de l'Energie de l'Etat, Inspection générale des finances, Archives Nationales, Magis, Finsys S.A., Clinique Sud Luxembourg, PanEuroLife S.A., …
* Keeping in sync with the testing team the database and the source tree with Tortoise.
* To analyze statistics and checklists in order to control workload with Stat pack, OEM and EM.
* Keep group procedures and function profiles up-to-date.
* Backup and Recovery (Tivoli, ArcServe) plans and testing for the best to the worst situation.
* Ldap and Oracle integration.
* Creation of Rman reporting tools.
* Providing trainings such as: Oracle 9i Database SQL Tuning Workshop R2.

Data Base Administrator for different customers including European Institution like the Opoce and also for some internal projects.
Tasks:
* The entire DBA task on Unix Sun Solaris, Linux and Windows XP.
* Database Migration up to 9.0.2.5 and 10G.
* Procedure standardization, automatization and documentation.
* To actively participate in the meetings.
* To follow up on projects and management requests.
* Verifying, testing and set up in production, the deliveries produced by outside companies dealing with Oracle.
* Keeping in sync with the testing team the database and the source tree.
* To analyze statistics and checklists in order to control workload with Statpack and OEM.
* Keep group procedures and function profiles up-to-date.
* Backup and Recovery (Legato) plans and testing for the best to the worst situation.
* IAS installation and set-up.
* Migration Oracle workflow to 6.2.

On May, the 1st 2003, I had been transferred inside the Tele2 group and Kinnevik & Invik group from Transac to X-Source ( now called Uni-2 Luxembourg).
Data Base Administrator & Team Leader for a large and one of their major customer like 3C, Bank Invik and MACH.
Tasks:
* DBA Team Leader (Staff of 4 person ):
Yearly appraisals of the DBA team members.
Selection and recruiting of new DBA team members.
To sign holidays request and supplementary hours.
Mentoring juniors DBA.
* The entire DBA task on Digital Open VMS and on Unix Sun Solaris.
* Migration from Digital Open VMS Oracle 7.3.3 to Sun Solaris Oracle 9.0.2 with intermediate migration to Digital Open VMS Oracle 8.1.7.4.
* Migration from Digital Open VMS Oracle 7.1.5 to Linux Oracle 9.0.2.
* Report critical issues and exceptions which affect the business and relations with our customers to the management.
* To actively participate in the meetings.
* To follow up on projects and management requests.
* Inform and train own DBA team to the required level of competence.
* Verifying, testing and set up in production, the deliveries produced by outside companies dealing with Oracle.
* Keeping in sync with the testing team the database and the source tree.
* To analyze statistics and checklists in order to control workload.
* Keep group procedures and function profiles up-to-date.
* Backup and Recovery plans and testing for the best to the worst situation.
* Disaster and Recovery Center, set up and policies.

* Mentoring junior DBA.
Gilles Dehaut, who was certified Oracle Database Administrator on December 2001.
* Rebuilding source tree and source code which match with the production system from screw up sources.
* Backup and restore with Rman and Ebu tools with Legato on Sun E10000 (30 Databases, 4Tbytes).
* Backup and Recovery plans and testing for the best to the worst situation.
* Administration of Express Server Databases Sun E10000 (20 Databases, 500M).
* Writing scripts to display easily as possible backup result by querying inside Oracle catalogue.
* Benchmark at the Sun Center at Geneva Sun Test Lab Center on E10000.
* Databases sizing, creation, administration, migration and tuning.
* Context administration and tuning for a 7x7 24x24 applications.
* Management of access by group (thus each group of developers is allowed access to certain parts of the database and denied to the rest).
* Resource management and putting in place procedures allowing detection of any inconsistencies in the database.
* Special application writing, helping to solve some sharp technical issue. Like avoiding Oracle bug or providing some feature not available for some release, writing some sample for developer to describe them some concept.
* Resource management (calculation of space required for physical objects).
* Customizing Oracle for working under Sun Cluster.
* Resource management (calculation of space required for physical objects).
* Writing scripts, which simplify procedure as much as I can.

* Creation of physical models and Databases for different projects based on logical models.
* Normalization (optimization of performances by creating "redundancy" (cumulative sums)), re-partition by disk, and by type of objects.
* Analysis of users requests (tuning via sqldba, tkprof, explain plan)
* Managing different versions of DDL.
* Creation of access rights lists, views, different "stored" objects and synonyms for the security of the database.
* Management of access by group (thus each group of developers is allowed access to certain parts of the database and denied to the rest).
* Resource management and putting in place procedures allowing detection of any inconsistencies in the database.
* Resource management (calculation of space required for physical objects).
* Managing quotas by users (prevent developers from monopolizing all system resources).
* Managing locking problems (concurrent access) and the "mutating tables" references and crossed dependency.
* Creating example templates for developers (Pro*C, Stored Procedures, Error handling and management).
* "Alarm" management furnished by the Patrol utility of BMC.
* Testing with the “Tibco” development team the Oracle parts.

Local System Administrator and Database Administrator during one and a half year, and one and half year a Database Administrator within the DGIXC General Directorate (Networks and Telecommunications) and within the SGB3 General Secretariat (the different Cabinets and Commissions).
Tasks: Administration of two UNIX servers, 17 UNIX clients, about 50 PCs and six Oracle databases (version 6 and 7). Thus management of Databases, reorganization, de-fragmentation of table spaces, resource management, quotas, profiles, access per users, de-normalization, performances, analysis of user requests, tuning via sqldba, tkprof and explain plan, and also migration from Oracle version 6 to version 7.

Local System Administrator on HP9000 (HP-UX7, HP-UX8.0) machines in charge of client and servers of Oracle Database versions 5 & 6 via TCP/IP network.
Tasks: Insure system consistency via backups and exports, divide system resources between users and applications, recompile new systems, partitioning of new disks and installation and set-up of test systems.