DBA Oracle / SQL Server
HIGHLIGHTS OF QUALIFICATIONS:
Administration and development of Data Base Oracle v9i/10g/11g/12c and SQL Server 2000/ to 2017
Other databases : Mysql, Postgres, DB2, Mongodb
Experienced working with : Grid Control, Data Guard, TOAD, RMAN, OEM, ERwin
Administration Oracle (RAC, DATAGUARD) and SQL Server ( MIRRORING, LOGSHIPPING, ALWAYS ON) management save, update patch and service pack, security
Excellent working knowledge of UNIX AIX, HP-UX, SUN Solaris, Linux
Software : safeguards (TSM, TINA, NetBackup); Supervision (Nagios, Patrol, HP-OV); scheduling (DollarU, Control-M, OPcon), SSIS, Reporting Services
Development : Visual Basic, Pascal, C, C++, Perl, Java, Java Script, CSS, PHP, HTML, SHELL, SQL and PL/SQL
Ability to work effectively in a team by exercising strong written and verbal communications skills in three languages (French/English/Arab)
Strong analytical, planning, problem solving and decision making skills
2018 Training DBA SQL Server 2017
2014 Training DBA Oracle 12c
2012 Training DBA SQL Server 2012
2008 OCP (Oracle Certified Professional) version 10g
2006 Training DBA SQL Server 2005
2005 Graduate Diploma in Computer Science, INSIA, France
2002 Bachelor in Computer Science, SIXUN Informatique, France
2001 Certification Microsoft Professional System Engineer (MCSE), France
2000 DUT Informatique spécialité GTR (Advanced diploma), France
1998 Baccalauréat Scientifique speciality SVT, France
DBA Oracle/SQL Server/Mysql
Administration databases Oracle 9i to 12c
Administration databases SQL Server 2000 to 2017
Tools for administration: SQL Developper, GRID Cloud Control 12c, 13c, OEM, TOAD, SSMS
Set up procedure level 2 and 3
Automating task : rebuild index, statistics gathering, checkdb, save
Optimization/ Tuning SQL traitement ( analyse AWR )
Migration/ Update Version
Monitoring Cluster : DATAGUARD (oracle) + replication ALWAYS ON (SQL Server)
Configuration and automate traitement GOLDEN GATE
Other databases: Mysql, DB2, Mongodb
Availability 24h/24 week-end included
2017 POLE EMPLOI
Administration databases Oracle 9i to 12c in production and development environment. RAC and standalone
Tools for administration : SQL Developper, GRID Cloud Control 12c, 13c and TOAD
Optimisation/ tuning SQL traitement
Check whether the scheduled tasks on the production servers are running normally
Scheduler : TWS and TWSD
Critical patch updates for Oracle products
Set up Standby database using Dataguard ( test switchover)
Migration databases 10g to 11g and 8i to 12c
Automate jobs and maintenance plans on the server (RMAN), integrity checks, automatic shrinking, transaction log backups
Monitoring tools : SuperG, BSM, NAGIOS
Spread backups across multiple backup devices residing on different hard disk drives. To improves the backup and restore performance
Ensure the evolution of technical infrastructures
Installation with ORACLE VM
Connect to server using CyberArch
2016 CREDIT AGRICOLE
DBA SQL Server
Administation SQL Server 2005/2008/2012/2014
Installation, configuration new environment windows 2012 – SQL Server 2014
Supervision – ZABBIX
Solve incident ( REMEDY )
Migration ( 2005 -> 2008R2, 2008 -> 2014, Sharepoint 2010 -> 2013 )
Implement save of databases MSSQL
Develop procedures, put into production
Performing controls and operating report
New project tracking, migration and obsolescence
Installation, configuration cluster SQL Server 2008 / 2012 / 2014
Recurring tasks : checking jobs (quick3270), backup ( litespeed ), reboot, reindexation, statistcs, checkdb
Establishment job using TWS (ZOS)
Update and create execution script (SMTTraitement)
Availability 24h/24 week-end included
DBA Oracle\SQL Server\Postgres (Paris)
Administration of SQL Server databases 2012 to 2014, Oracle databases 10g to 12c and Postgres
Installation, Configuration, maintain databases environnement development, integration, pre production and production
Setting up procedure for level 1 and 2
Monitoring and management of SQL Server databases ( SQL Monitor )
Save databases and environment ( Netbackup )
Management environment SSIS SSRS SSAS
Set up, test cluster, shared server
Administration databases SQL Server mirroring
Participation meeting setting infrastructure
Check scheduled maintenance task (job)
Responsible for problems related to software for web and portals (sharepoints)
Assistance in setting up a complete platforme enabling organizations to dreate and deploy solutions Business Intelligence
DBA Oracle\SQL Server\DB2 (Monaco)
Administration Databases Oracle 9i to 10g, SQL Server 2000 to 2008, DB2
Application compatibility study / update database version
Installation / set up / administration GRID Control (OEM 12c)
Database High Availability (DATAGUARD – LOGSHIPPING)
Report, solve daily incident (morning check)
Performance optimization / Tuning
Set up script (LINUX ans WINDOWS) for centralization information on all database environments Oracle and SQL Server ( Production, Pre-Preoduction, Developpment, UAT )
Configuration monitoring (Nagios – Cacti - Netcool – Script alert mail)
Installation configuration maintenance DBAUtils Oracle / SQL Server
Development, integration, production launch of new applications
Architecture Documention databases / Set up procedure
Work in close collaboration with international team ( swiss, England, Singapore )
Operation carried out under control and validation of the managers and in the rules and standard cards published by Barclays
Support Level 2 and 3
Help set up databases Mysql and DB2
Availability 24h/24 week-end included
2013 MONACO TELECOM
DBA Oracle\SQL Server (Monaco)
Management integration/ development/ pre production / production
Maintain perimeter infrastucture
Monitoring using cactis, Nagios
Implementation of platform and model for test, ST, STA, SIT, UAT
Administration Databases Oracle 9i to 10g and SQL Server 2000 to 2012 (toad, oem)
Administration Virtual Machines (VMWare, VSphere)
Coordination Technical and functional support of projects and team
Setting up and provision of documentation and procedure
Setting up meeting organization with project manager / application / developer / architect
Script planning ( unix and windows ) and job SQL Server and Oracle databases for optimization of use
Decision support ( Business Intelligence )
Report, organization and study of the daily existence
DBA Oracle\SQL (Chambery, France)
Installing and updating the Oracle Database server and application tools. Allocating system storage and planning future storage requirements for the database system.
Creating primary database storage structures (tablespaces) after application developers have designed an application.
Creating primary objects (tables, views, indexes) once application developers have designed an application.
Creating and managing Standby Database or other High availibility procedure if needed.
Creating and managing Oracle RAC cluster.
Understanding and analyzing PL/SQL code.
Modifying the database structure, as necessary, from information given by application developers.
Ensuring compliance with Oracle license agreements.
Controlling and monitoring user access to the database.
Monitoring and optimizing the performance.
Planning for backup and recovery of database information.
Maintaining archived data on tape.
Backing up and restoring the database.
Management of Microsoft SQL server and My SQL.
DBA Oracle\SQL (Nice, France)
Installing, configuring, patching, troubleshooting and supporting Oracle 9i/ 10g /11g R2 (database for Oracle eBusiness Suite R12), SQL Server 2000/2005/2008.
Implementing above server software in High Availability or cluster configuration on Unix (AIX, SUN), Windows (2003, 2008) and SAN.
Using other HA approach (eg. RAC, DataGuard)
Configuration oracle databases using Oracle Enterprise Manager, Oracle Management Packs (Diagnostics Pack, Tuning Pack and Change Management Pack) and Oracle utilities.
Oracle database performance tuning in High Available Unix and Windows environments
Unix shell scripting and utilities, tuning PL/SQL and T/SQL
Migration databases Oracle 10g -> 11g and SQL Server 2005 -> 2008
Supervision Monitoring using NAGIOS (configuration centreon)
Backup/Restore using RMAN, TSM (plug tdp for sql server) and VEEAM.
Knowledge of multiple Software Development Life Cycles
Experience with ITIL/ITSM, change management, release management
Experience with needs assessment/requirements analysis
Provide on-call support in 24/7 environment.
DBA Oracle\SQL Server (Kremlin Bicetre, FRANCE)
Install, configure, troubleshoot, monitor, patch, and administrate MSSQL instances.
Consult development project leaders, architects, and Oracle administrators on database development issues.
Design and/or implement new and existing database structures.
Improve existing databases by determining users' information requirements and system performance and functional requirements.
Control and coordinate changes to the testing and production servers.
Develop and implement procedures that will ensure the accuracy, integrity, and completeness of data stored in the databases.
Develop and implement security procedures, including access control and user management.
Verify database consistency and replication of databases.
Develop and implement backups and disaster recovery procedures.
Provides solutions to complex database problems or to specific design constraints.
Provide on-call support in 24/7 environment.
Conduct performance and tuning reviews.
Assist (if required) in building databases within all environmental states (unit test, system integration, user acceptance, operational testing and production).
Monitor performance, space management, and database optimization techniques.
Develop, document and promote standards and procedures.
Evaluate new database products or versions / migration
DBA Oracle (6 month, LaDefense, FRANCE)
ensure performance, recoverability, integrity, security, and availability
Create and clone databases, trouble-shoot and resolve database problems.
Implement vendor packages and in-house developed databases, design and elevate database modifications, monitor and tune database availability and performance, trouble-shoot application problems.
Design, test, implement, document, and maintain database strategies and processes.
Create and maintain procedural, operational, and disaster recovery documentation.
Plan and perform database software installs, major upgrades and maintenance patches.
Work closely with application and technical analysts.
Regular on-call shifts, some evening/weekend work.
2008/2009 EXTELIA (2 years)
DBA Oracle/SQL Server (Arcueil, Aix-En-Provence, FRANCE)
Provide database administration support and tune performance of databases oracle 9i/10g and SQL Server to give optimum throughput
Analyzed the database objects using OEM and assigning and altering the profiles of the Database schemas for security purpose
Installation monitoring databases oracle and sql server using Zabbix, locally managed tables using with PL/SQL
Ensuring backups are complete using RMAN for Oracle and maintenance plans for SQL Server 2000/2005 and 2008
Migration, update of databases oracle 9i to 10g, backup optimization using with RMAN
Plan and develop efficient databases designs based on analysis of user requirements.
Writing, Modify packages containing procedures and function using with TOAD 8.5.
Analyzing and optimizing the SQL queries unto 16th level through SQL Analyzer and observing top sessions.
Reorganization of database using export/import used this feature in OEM and as well Shell scripts.
Administration Oracle RAC and SQL Server Cluster
Scheduled jobs using the cron like taking full database backup, password aging check on SQL Server 2000/2005/2008, SSIS 2005/2008, DTS 2000, Reporting Services.
Identifying and fixing performance issues related to client applications and following up with respective vendors to provide patches for identified problems.
Coordinated with developers in reviewing code for optimizing database performance during development and before going into production.
Developed complex PL/SQL functions procedures, packages and triggers to handle complicated business logic
Launch AWR stat to resolve problem, Troubleshooting and crisis management methods
Provide 7x24 support when required
DBA Oracle (Massy, FRANCE)
Resolve technical incidents / Analysis of traces / Monitoring
Enforce processes, procedures and standards
Administration and maintenance of facilities and foundations of database Oracle 9i
Realization programs PLSQL and SQL *Plus/ creation script
Management of batch night by DOLLARU / Setting up report of activity
Installation of Oracle 10g on server NT&UNIX
Installation, configure and upgrade Oracle software products
Implement and enforce security for all Oracle databases
Control system capacity for existing requirements and plans for future needs
2006-2007 UNISYS (2 years)
DBA Oracle/SQL (7 months mission to BOUYGUES TELECOM in Colombes, FRANCE)
Manage and administrate databases Oracle and SQL
Formulate and implement database architecture, database standards and policies
Assist with writing procedure for support document / Phone Assistance
Develop and maintain key project deliverables such as the Applications setup documents, user roles and responsibilities
Support level 2 and 3 on Oracle 9i/ 10g and SQL server 2000 /2005
Perform database backups using both online & offline methods
Tracking and resolving bugs in the Application via the Oracle TAR process using Metalink
System Engineer (10 months mission to ORANGE in Paris, FRANCE)
Lead, coach and mentor other team member
Coordinated with developers in reviewing code for optimizing database performance during development and before going into production
Implementing databases according to production standards mostly in high availability environments
Providing support to solve production database problems and engineer production database changes
Supervise stains (job performed under Oracle) with tools Patrol
Launching batch using with DollarUniverse for backup with TINA, Net Backup
Intervention in modelling of data and optimization of requests PLSQL
Assist in performance tuning SQL / ORACLE in UAT and production environments
Provide support for database critical incident, hotline
Provide 7x24 support when required
2003-2004 TRIGONE (1 an )
DBA Oracle/SQL (4 months mission at the main office in Paris, FRANCE)
Transfer technical competences towards other members of the team
Teleprocessing of databases Oracle 9i different customers Plans
Set up script; ensure it is “user friendly”
Establish and maintain backup and recovery policies and procedures
Pulled out the DDL script to create the tables in database using ERwin.
DBA Oracle/SQL (1 year mission to CREDIT AGRICOLE in Guyancourt, FRANCE)
Install tools for reporting and monitoring of performance
working using OEM to do most of the tasks like monitoring sessions, checking sql's, database links, table space storage usage and also used oracle expert for SQL history, session tuning and Query optimizing techniques on databases.
Check on the good sequence of job under Oracle / SQL, management of databases
Communicating regularly with technical applications, and operational staff, to ensure the database integrity and security
Implements enhancements to production database
Identify improvements to perform Level 3 support
Assist users in understand Oracle Support procedures and operation
Provide database technical expertise to application developers, operations, etc. for systems development and production support
2002 ST MICRO ELECTRONIQUE
DBA Junior (Crolles, FRANCE)
Strong involvement in the project of evolution of Facilities System
Build architecture of database and optimization of requests SQL
Monitor and troubleshoot performance problems and other issues reported by clients through the Product Support organization
Installation of Oracle 9i, 8i, and 8.x databases on SUN, HP and Linux to the latest patch set in 9i (188.8.131.52)
Performed database upgrades to bring databases to the latest Oracle release levels
Implemented shell scripts to run the job schedules on crontab and experience in to setup job-scedular using with pl/sql job scheduler
Incorporate Security of facilities
Installation of database Oracle, creation of count, operational help
2000-2001 ALIS INFORMATIQUE (1 year in Paris, FRANCE)
Service Engineer (contract of qualification: stage)
Provide input to the Project Manager in the development of the Project plan and identify process mapping, gaps and customization requirements
Resolution technical / coherent incident
Write procedures about architecture SQL server 2000
Provide Telephone Assistance