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
Skills
Databases DBA Cassandra DSE 5.x,6.x, Oracle 8/8i/9i/10g/11g/12c/19c
Langages Script Shell, perl, PL/SQL, SQL, t-sql,psql
OS Linux (Redhat ), Unix (Solaris, Linux, AIX), Windows
Versionning CVS, SVN
Storage Networker, TSM
BI Datastage serveur/Business Objects: BO XI3, BI4
ERP: Oracle E-Business Suite 11i, R12
Education
1992 - 1997 Diplom Mathematics Bielefeld-Germany
1998 - 1999 Diplom IT Engineer France
Training
2018- Cassandra Administration DSE 5.x, DSE 6.x
2016- Hadoop Hortenworks Administration
2015- Administration MongoDB 3.x
2014- Administration Sqlserver 2012
2014- New features Oracle 12c
2011- Oracle tuning 11g
2010- Administration Sqlserver 2008 R2
2010- Administration SOLARIS 10
2008- Administration SOLARIS 8
2007- Oracle 10g RAC / OLAP
2007- Administration Sqlserver 2005
2007- Business Objects XI 3.1 (Administration et Reporting)
2006- Datastage Server
CERTIFICATION
2020 -Azure Ongoing
2019- AWS Certified Solutions Architect
2014- OCP Oracle DBA EBS R12
2013- OCP Oracle 11g
2007- OCP Oracle 10g
2006- Sun Certified Administrator Solaris
2005- OCP Oracle 9i
2002- OCP Oracle 8i
2000- OCP Oracle 8
DBA Oracle/Cassandra
I'm interested only for long term projects
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
Skills
Databases DBA Cassandra DSE 5.x,6.x, Oracle 8/8i/9i/10g/11g/12c/19c
Langages Script Shell, perl, PL/SQL, SQL, t-sql,psql
OS Linux (Redhat ), Unix (Solaris, Linux, AIX), Windows
Versionning CVS, SVN
Storage Networker, TSM
BI Datastage serveur/Business Objects: BO XI3, BI4
ERP: Oracle E-Business Suite 11i, R12
Education
1992 - 1997 Diplom Mathematics Bielefeld-Germany
1998 - 1999 Diplom IT Engineer France
Training
2018- Cassandra Administration DSE 5.x, DSE 6.x
2016- Hadoop Hortenworks Administration
2015- Administration MongoDB 3.x
2014- Administration Sqlserver 2012
2014- New features Oracle 12c
2011- Oracle tuning 11g
2010- Administration Sqlserver 2008 R2
2010- Administration SOLARIS 10
2008- Administration SOLARIS 8
2007- Oracle 10g RAC / OLAP
2007- Administration Sqlserver 2005
2007- Business Objects XI 3.1 (Administration et Reporting)
2006- Datastage Server
CERTIFICATION
2020 -Azure Ongoing
2019- AWS Certified Solutions Architect
2014- OCP Oracle DBA EBS R12
2013- OCP Oracle 11g
2007- OCP Oracle 10g
2006- Sun Certified Administrator Solaris
2005- OCP Oracle 9i
2002- OCP Oracle 8i
2000- OCP Oracle 8
DBA Oracle/Cassandra
I'm interested only for long term projects
Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.