Professional Experiences

BNP Paribas August 2017- Till today
Cassandra DBA

CASSANDRA CLUSTERS TUNING
CASSANDRA CLUSTERS ADMINISTRATION AND MONITORING PRODUCTION ( 1 CLUSTER WITH 2 DC, 8
NODES, 8TB IN SIZE, 1 CLUSTER WITH 132 NODES, 1 DC, 190 TB IN SIZE IN MULTIINSTANCES MODE AND
1 CLUSTER WITH 6 NODES EN MULTIINSTANCES DE 48TB IN MULTIINSTANCE MODE).
BACKUP MANAGEMENT IN ECS (S3/AWS) INFRASTRUCTURE AND NETBACKUP
MINOR AND MAJOR VERSION UPGRADE
CAPACITY PLANNING
ADDS/REMOVES AND REBUILD OF NODES
ANALYSIS OF DATABASE ACCESS PATTERNS TO ISOLATE HOTSPOTS, DATA MODEL PROBLEMS, AND OTHER BOTTLENECKS.
MANAGEMENT OF RECURRENT TASKS AS REPAIRS, ON DEMAND BACKUPS, INSTALLATIONS WITH ANSIBLE.
 DATATIERING
 INCIDENTS/CHANGES MANAGEMENT
 SETUP OF NEW CLUSTERS
GUT UNDERSTANDING OF THE FOLLOWING CONCEPTS (GOSSIP PROTOCOL, HINTED HANDOFFS, READ
REPAIRS, COMPACTION, MERKLE TREES, VARIOUS TIMEOUTS PARAMETERS,...)
CLUSTER UPGRADE FROM 2 DC TO 1 DC WITH MULTIINSTANCES AND MANY RACKS
VERSION UPGRADE OF OPSCENTER AND UPGRADE OF NODE AGENTS
CONFIGURING OPSCENTER FOR AUTOMATIC FAILOVER
Oracle DBA
MANAGING ORACLE DATABASES IN PRODUCTION ENVIRONMENTS
BACKUP AND RECOVERY USING RMAN
CHANGE /INCIDENT MANAGEMENT
ORACLE DATAGUARD IMPLEMENTATION AND SUPPORT
PERFORM PROACTIVE CAPACITY PLANNING AND FORECASTING BASED ON DATABASE USAGE PATTERNS AND NEW BUSINESS INITIATIVES.
DATABASES MIGRATIONS
SUPPORTS TECHNICAL SOLUTIONS WITH DETAILED BUSINESS CASE BASED ON THOROUGH
INTERPRETATION OF BUSINESS REQUIREMENTS
DATABASES TUNING
TECHNICAL ENVIRONMENT/METHODOLOGIES
AIX, LINUX, HP-UX, ORACLE 9I/10G/11G/12C/19C RMAN, DATAGUARD, CLUSTERS, SHELL, RAC, AWR, ADDM,
ASH, DATAPUMP,SRDF, OEM 13C, OPSCENTER 6.X, CASSANDRA 2.X,3.X, ANSIBLE

APHP/DEXIA January 2016 - July 2017
Oracle//Hadoop DBA
MIGRATION AND UPGRADE OF THE ORACLE 11.2.0.4 ON LINUX
HADOOP 2.X CLUSTERS INSTALLATION
UPGRADE OF HADOOP CLUSTERS FROM 2.0 TO 2.4 VERSION
INCIDENTS AND CHANGE MANAGEMENT REGARDING HADOOP CLUSTERS
CREATION OF BACKUP SCRIPTS OF HDP CLUSTERS
Environnement technique:
AIX, HP, LINUX, ORACLE 9I/10G/11G, RMAN, SHELL, DATAGUARD, TOAD, SQL, PL/SQL, SQLLOADER , GRID
CONTROL, HDP 2.X, ANSIBLE, PYTHON, AMBARI

SOCIETE GENERALE January 2013 to Decembre 2015
DBA Oracle senior Level2/Level3
Sql Server/MongoDB
INTERNATIONAL CONTEXT (+3500 ORACLE DATABASES, 300 SQL SERVER INSTANCES, 30 POSTGRESQL
INSTANCES)
LEVEL3 DBA SUPPORT , DAILY COMMUNICATION WITH OFFSHORE LEVEL2 DBA TEAM IN INDIA
CHANGE MANAGEMENT
ASM, DATAGUARD AND RAC DATABASES IMPLEMENTATION
ORACLE TUNING/MIGRATION
APPLYING PATCHING OF DATABASES (PSU, ONE-OFF PATCHES,..)
MIGRATIONS FROM 10G TO 11G &12C ORACLE VERSIONS
MIGRATIONS FROM ORACLE DATABASES TO POSTGRESQL
ON-CALL SERVICES
PROVIDE DBA ADMINISTRATION TASKS SERVICES FOR MULTIPLE PROJECTS
DEFINE, DESIGN AND PROGRAM DATA PROCESSING STREAMS AND IMPLEMENT DATABASE
ARCHITECTURES
INTERACT WITH BUSINESS USERS TO UNDERSTAND ISSUE, PERFORM IMPACT ANALYSIS & PROVIDE
RESOLUTION
WORK WITH SYSTEMS ADMINISTRATORS & STORAGE ADMINISTRATORS TO IMPACT SERVER LEVEL
CHANGES & ADD STORAGE
RESPONSIBLE FOR CREATING AND MAINTAINING ALL RELEVANT DOCUMENTATION
PRIMARY CONTACT FOR THE DEVELOPMENT FOR LOGICAL AND PHYSICAL DATABASE DESIGNS
ASSISTS IN ALL DATABASE FUNCTIONS INCLUDING ACCESS, ALLOCATIONS, VALIDITY CHECKS, SECURITY
CONDUCTS BACKUP, RECOVERY AND QUERY TUNING
PERFORMANCE TUNING USING ASH, ADDM AND AWR REPORTS
SETUP OF MONGODB DATABASE, MIGRATION ORACLE DATABASES TO MONGODB
LEVEL3 ORACLE INCIDENT RESOLUTION
LEVEL 2 SQL SERVER INCIDENT RESOLUTION
LEVEL 2 MONGODB INCIDENT RESOLUTION
TECHNICAL ENVIRONMENT/METHODOLOGIES
AIX, LINUX, ORACLE 9I/10G/11G,/12C RMAN, DATAGUARD, CLUSTERS, TSQL, SHELL, SRDF, AWR, ADDM, ASH, DATAPUMP, MONGODB, SQL SERVER 2008 R2/2012 CLUSTERS INSTANCES,CLOUD CONTROL

BNP PARIBAS January 2011 to Decembre 2012
Oracle DBA/SQL Server (+3000 Oracle databases, +300 Sql servers databases)
MANAGING ORACLE DATABASES IN PRODUCTION ENVIRONMENTS
BACKUP AND RECOVERY USING RMAN
CHANGE MANAGEMENT
ORACLE DATAGUARD IMPLEMENTATION AND SUPPORT
INSTALLATION AND SUPPORT OF RAC DATABASES
SOFTWARE INSTALLATION PROCEDURE + CONFIGURATION OF THE SERVERS
RELEASE MANAGEMENT AND PATCHING
UPGRADE/MIGRATIONS
ADMINISTRATION OF THE INFRASTRUCTURE
BACKUP-RESTORE OF DATABASES

RESPONSIBLE OF THE DISASTER RECOVERY PROCEDURES
DEFINING STANDARDS AND GUIDELINES
REPLICATION OF DATAS
PERFORMANCE TUNING
TECHNICAL SUPPORT OF SYSTEM AND DEVELOPMENT TEAMS
SUPPORT OF THE PRODUCTION ENVIRONMENT (WATCH DUTY ROLE, PROBLEM ANALYSIS AND INCIDENT
MANAGEMENT)
RAC IMPLEMENTATION: ADD, REMOVE NODES, PATCHES
DOCUMENT AND MAINTAIN DATABASE STANDARDS AND OPERATIONS PROCEDURES
PROACTIVELY MONITOR DATABASES FOR OPTIMAL PERFORMANCE
MANAGE DATABASE BACKUPS AND PARTICIPATE IN RECOVERY EXERCISES
DATABASE TUNING, SQL TUNING AND OPTIMIZATION, TROUBLESHOOT PERFORMANCE ISSUES AND RECOMMEND FIXES
PLAN, COORDINATE, TEST AND ROLL-OUT ORACLE PATCHES & UPGRADES
ASSIST IN DISASTER RECOVERY DOCUMENTATION, PLANNING, AND TESTING
PARTICIPATE IN ROTATIONAL ON-CALL COVERAGE AND PRODUCTION RELEASES/CONVERSIONS
EVALUATE NEW FEATURES AND TECHNOLOGIES, PROVIDE RECOMMENDATIONS TO IMPROVE EXISTING
ENVIRONMENTS
DATABASES MIGRATIONS FROM 10G TO 11R2
DATABASES PATCHING
DATABASES CLONING USING RMAN
SQL & PL/SQL PERFORMANCE & TUNING
SQL SERVER ASMINISTRATION, TUNING, MIGRATIONS
TECHNICAL ENVIRONMENT/METHODOLOGIES
AIX, LINUX, ORACLE 9I/10G/11G, RMAN, SHELL, ASM, RAC, AWR, DATAGUARD, TOAD, SQL, PL/SQL,
SQLLOEDER, GRID CONTROL,SQL SERVER 2008R2//3012/ ALWAYSON

CNAMTS January 2007 -December 2010
Oracle DBA
BACKUP AND RECOVERY OF DATABASES (USING RMAN AND TRANSPORTABLE TABLESPACES)
HIGH AVAILABILITY: ORACLE DATAGUARD AND RAC IMPLEMENTATION
DATABASE LEVEL PERFORMANCE TUNING AND DATABASE REORGANISATION
ORACLE SERVER INSTALLATION AND PATCHING
DATABASE CREATION, PATCHING , MIGRATION AND DATABASE CLONE
REPLICATION USING (SNAPSHOTS/MATERIALIZED VIEWS)
SUPPORT OF DEVELOPERS AND END USERS
MIGRATION OF 300 TERA BYTES DATAWAREHOUSE APPLICATIONS (SCRIPTS AND DATABASES) FROM SOLARIS 8 TO SOLARIS 10/ORACLE 9I TO ORACLE 10G
IMPLEMENTATION OF SOLARIS 10 SERVICES
SETUP OF GRID CONTROLS
DATA REPLICATION FROM SQL SERVER DATABASES TO SQL SERVER USING GOLDEN GATE
RESPONSIBLE FOR THE INSTALLATION, CONFIGURATION, TROUBLESHOOTING, SUPPORT AND
MAINTENANCE OF ALL DATABASE SYSTEMS INCLUDING PRODUCTION.
MONITORING AND OPTIMIZATION OF DATABASE PERFORMANCE, SECURITY, RESOURCE UTILIZATION,
MEMORY CONFIGURATION, SESSIONS, ARCHIVE LOGS, AND DISK SPACE USAGE.
SHARE SUPPORT FOR MISSION-CRITICAL DATABASE INSTANCES, INCLUDING RESPONSIBILITY FOR AFTER HOURS ON-CALL SUPPORT FOR ISSUE RESOLUTION.
TROUBLESHOOTS PROBLEMS REGARDING THE DATABASES, APPLICATIONS AND DEVELOPMENT TOOLS.
MEETS SLA FOR DATABASE SYSTEMS
SHARE ORACLE EXPERTISE AND KNOWLEDGE BY PROVIDING SQL, PL/SQL, AND DATA EXPERTISE TO DEVELOPERS AND USERS.
INSTALLING,UPGRADING AND MANAGING BO SERVERS: BO & BODI, MONITORING DB
SERVICES,MANAGING USERS PRIVILEGES AND SECURITIES, MONITORING BO SERVER RUNNING WITH OPTIMAL PERFORMANCEPARTICIPATE IN DBA TEAM ON-CALL PAGER ROTATION AND ON-CALL SUPPORT DUTIES.
TECHNICAL ENVIRONMENT/METHODOLOGIES
SOLARIS 8/10, ORACLE 8I/9I/10G (MORE Than 600 Tb od database data), ORACLE OLAP, BO XI 3.X, BODI,SAS V8/9,
RMAN, DATAGUARD, POWER DESIGNER, LEGATO NETWORKER, OEM, XDB, SCC-VERSIONING, SQL, PL/SQL,
CLUSTER VERITAS,GOLDEN GATE10G, SQLSERVER 2005/2008/2008 R2

Keyrus FROM 09/2001TO 12/2006
Datawarehouse Architect
SUPPORT FOR APPLICATIONS OF DATAWAREHOUSE AND DATAMARTS (MODELLING AND ARCHITECTURE)
RELEASE OF BUSINESS INTELLIGENT SOLUTIONS
INSTALLATION AND ADMINISTRATION INTELLIGENT TOOLS AND IN THE ORACLE BASIS
DRAFTING OF DELIVRABLE TECHNOLOGY IN THE PROJECTS
TECHNOLOGICAL ASSISTANCE FOR DEVELOPERS AND TUNING OF SQL AND DATA BASIS ADMINISTRATION
SAFEGUARD AND RESTORING SUPERVISIONS OF ORACLE DATABASES
SCRIPTING IN SHELL FOR TASKS AUTOMATION
ADMINISTRATION ORACLE EBS 11I
REPORTING AND DEVELOPMENT OF THE BO ENVIRONMENT (CREATING & MAINTAINING UNIVERSES AND REPORTS)
CREATION OF ETL WITH DATASTAGE, ODI , BODI AND PL/SQL
TECHNICAL ENVIRONMENT/METHODOLOGIES
ORACLE 7,8,8I,9I, RMAN, TOAD, STANDBY DATABASE, SQL, PL/SQL, BUSINESS OBJECTS,POWER AMC, DATASTAGE 6.X/7.X, EBS 11I