Laila - DBA SQL

Expérience professionnelle

IBM
IT Consultant Oracle (ADEX) La Gaude, France, May 2010 – current
Mission: Member of a 6 senior Oracle DBA team that manage more than 500 databases for international clients and responsible for the database administration of three critical Clients including Oracle installation and Oracle upgrade, database maintenance, and database recovery.
Providing disaster recovery by configuring physical standby database using oracle Data Guard.
24X7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues using ITIL standards and methodology.
Maintenance at level 3 of a large amount of Databases (from 8i to 11g), Duty services;
Implementation of monitoring tools that generate alerts (Tivoli, Nagios) for Oracle databases;
Investigating, tracking & reporting (managenow) and resolving Oracle incidents and problems;
Cloning 10g and 11g Oracle Database home applying CPU patches;
Migrating Oracle from 10g to 11g;
Installing standby 11g databases then writing scripts and testing and documenting failover (DRP)
Scheduling and restoring Oracle online backup with TSM
Environment: Linux, Aix, Windows
Tools: Putty, sqlplus, RMAN,TSM, Winscp, Cyberack, Lotus Notes

2008 IT Consultant Oracle (freelance) Intrasoft Luxembourg
Client: European Commission
Maintenance of a large Oracle database infrastructure in a Unix environment using Solaris Clusters.
Database configuration, operation, backup-restore (online copy) and monitoring.
Migration (10.2.0.4), moving database (between server)
Tuning of SQL statements executed by applications of Oracle IFS
Support of additional software components (RMAN, Oracle Names, Oracle Internet Directory)
Capacity planning ,documentation of procedures.
Tools: OID, Putty, Reflexion, SMT, scripting shell

2007 IT Consultant Oracle Dimension Data Luxembourg
Client: Dexia Technologies Services (DTS)
Administration Oracle10g: management & tuning / AIX & Solaris
Troubleshoot connection problems on the client, middle tier, and server
Configure RMAN backup settings (TDP, BackupExec TNG, script shell), implementing recovery operations proactively monitor (advisors, ADDM) and tune the database (traces, views, stats)
Using schedules to automate tasks (jobs, schedules)
Migration DB Oracle 9i to 10g (DBUA)
Tools: Grid Control, Toad, Sqlplus, Norad,TNG, dbua, dbca

2006 IT Consultant /Oracle /SqlServer/Sybase VDS Computing SSII Luxembourg
Clients: Dexia BIL & Lombard International Assurance S.A
Administration Oracle 8i, 9i & 10g / Sybase 12.5 ASE /True 64
Installing and configuring oracle 10g software on Solaris 10 and AIX 5.3 Server
Database management and services 10g (user, tablespace, role, permissions)
Developed and documented procedures to monitor and reclaim fragmented space in Oracle databases
Planned and co-ordinated monthly schema changes and data updates for all development projects and
Database Migration Oracle from 8i to 9i and application (Sungard GPII)
Improvement problematic issues/operations and support staff to ensure deadlines met and guaranteed
Tools: OEM, Statspack, Oracle Performance, Tuning Pack,Toad, Sqlplus, Sybase Central, SqlAdvantage

2005 Oracle Database Administrator BCEE Luxembourg
Project: Oracle 9i Administration: Database (9i) maintenance and tuning (cpu, response time)
Monitoring, query performance, tuning, analysis and design (StatsPack, OraPerf)
Data processing supervision, specific improvements (Reuters), alert script processing (shell)
Implementation of PL/SQL packages (Toad)
Improvement of the performances by global area system tuning, datafiles, partitioning
Reorganization of all the schema table spaces and indexes
Writing of requirements and specifications (MSProject, Rational Rose)
Tools: OEM, Statspack, Oracle Performance, Tuning Pack, Toad, Sqlplus

2005 Oracle/AIX Database Administrator ELECTRICITE DE STRASBOURG Strasbourg, France
6 months contract
Project: Oracle 8i-9i administration: Oracle Production under AIX (4.5)
Monitoring database system heath, identifying bottlenecks and improving system performance
Database cloning, table level data refreshes
Upgrading (8.1.7-> 9i), patches and cross functions issues resolution
Investigation of Oracle Net Trace files to debug Oracle Net protocol errors
Monitoring and logging, troubleshooting, security and script processing
Backup and recovery (RMAN), sizing and capacity planning
Oracle periodic patch set application
Database standards and procedures improvement
Tools: OEM, Spotlight, Toad, Putty

2004 Oracle Database Administrator FRANCE TELECOM SIRES Belfort, France
Project: Creation, maintenance, configuration of Oracle8i and 9i databases (Oracle reporting)
Script development in shell and PL/SQL for data refreshment (snapshots)
Creation of procedures, stored functions, packages, triggers in PL/SQL
Development of Oracle alert strategy to react to database problems
Script import/export, data load in and out of a database (SQLoader)
Oracle tuning: SQL*DBA and Explain Plan
Database backup, restoration and recovery

Project: Maintenance and evolution of a data warehouse for telephony equipment
Modeling of design concepts with Business Objects
Debugging of JAVA, JSP and Servlet applications
AIX 4.3 management

2003 Oracle Database Administrator (Project Management) QUINTILES Strasbourg, France
Project: Project management CDISC
Study to select tools to generate reports of data warehouse
Analysis of existing architecture to gather business requirements (UML modeling)
Requirements document (UML Methodologies, CSV)
Responsible for the development of ETL procedures with Oracle warehouse Builder
Creation of advanced processes to include execution of pre-defined non-Oracle scripts
Importing of existing PL/SQL, optimization and tuning of the produced packages
Validation tests and writing of guidelines in English
Tools: ETL (OWB), Oracle (9i), Enterprise Manager (OEM), SQL Plus

2002 Developer Oracle/Sybase TRANSGENE Strasbourg, France
2 year contract
Project: Design & administration of a Sybase database to manage user rights enabled by multiple applications
Development of scripts (Transact-SQL), stored procedures for a web interface (PHP4)
Creating indexes and collecting oracle optimizer statistics
Monitoring CPU utilization and sizing the various database buffers
Tools: PHP4, TOMCAT/Linux, ODBC