Profil de T TN
0 missions réalisées
T TN en quelques mots
Creating database non-CDB, multitenant CDB, PDB with Grid Infrastructure, EXADATA, ASM, Oracle Database 11.2, 12.1, 12.2 having high availability configuration Active Dataguard
Tuning, improving database performance, SQL Performance Analyzer, SQLTune, SQLHC
Fixing production issues
Replication with Oracle GoldenGate server, GoldenGate monitor, Veridata
Backup/restore/duplicate with RMAN
Monitoring databases with Cloud Control 13C Release 2
Implementing security with Transparent Encryption Data, Oracle Vault, Oracle Data Masking, Oracle Data Redaction, Fine Grained Auditing
EDUCATION
1990 IT Master degree of the University Paris 7 Jussieu
1989 IT Licence degree of the Université Paris 7 Jussieu
1988 DEUG SSM of the University Paris 7 Jussieu
IT Technical Skills
Operating System IBM AIX 5L,6L, HP-UX 11, Linux Redhat 6.0
Programming Oracle PL/SQL, Shell Unix/Linux
languages
Databases Oracle 10R2, 11R2, 12C with area of expertise
– Creating and configuring Oracle Database Enterprise Edition 11.2, 12.1,
12.2 for database non-CDB, Multitenant CDB, PDB in Exadata environment
multi-instances with Grid Infrastructure, ASM Cellserver storage
– Upgrading database, from version 11.2 to 12.1 or from version 12.1 to 12.2,
copying, duplicating, moving database on different platforms
– Implementing the high availability environment Active Dataguard made of Primary and Standby databases using the broker
– Backup/restore, duplicating database with RMAN
– Installing and configuring Cloud Control 13C to monitor databases
– Administrating very large databases with partitioning, sub-partioning
– Implementing the advanced compression high under Oracle database 12.2
– Tuning SQL statements with analyze of AWR, ADDM, Sql HC (Heath Check) reports and TKPROF trace, optimizing SQL requests with analytic functions
– Implementing Oracle Golden Gate to replicate data from
source database to remote databases
– Fixing production issues
– Implementing Encryption data in tablespaces, Oracle Vault, Oracle Data Masking
Pack, Oracle Data Redact
English level: semi-fluent obtained working in Luxembourg, good level for writing document.
Additional knowledge for banking
Fund Accounting, Transfer Agency, Portfolio Accounting
Electronic banking, credit cards, encryption passcode.
Management of loans, securities, risks, stocks, accounting, taxation
Qualifications and rules for the 10 last years
May 2017 – January 2019: BPIFrance in Maison Alfort (Paris area, France)
– Production DBA Oracle Database
December 2015 – April 2017: Louis Vuitton (Group LVMH in Paris)
– Production DBA Oracle Database
August 2015 – October 2015: HSBC Bank PLC
– Production DBA Oracle Database, Oracle GoldenGate
May 2015 – July 2015: SNCF (French National Railways Company (Clichy-Levallois France)
– Expert DBA Oracle Database, Oracle GoldenGate
April 2013 – April 2015: GRDF (Gaz Réseau Distribution France) Paris France
– Expert DBA Oracle
December 2009 – December 2012: IGEFI
– Senior Oracle DBA, AIX Administrator in the Client Support IT Team: supporting the financial products Fund Accounting, Transfer Agency, Porfolio Accounting to several important international companies like City Group, HSBC, BNP PARIBAS, ING, Credit Suisse, Union Investment, Robeco, Swiss Life, Northern Trust, …
January 2009 – November 2009: APRIONIS (French Insurance Company in Paris)
– Senior Oracle DBA: implementing and improving the performance of the financial application GP3 V3 edited by Sungard.
June 2008 – December 2008 : Orange Switzerland (Prepaid Services Operations in Lausanne and Zurich)
– Senior Oracle DBA: install, configuring, load testing of the application Matrix.
July 2007 – May 2008: CIMAFAP/AGORA (French Ministry of Agriculture) in Paris
– Senior Oracle DBA
January 2007 – June 2007: EDS France in Nanterre (France)
– Oracle DBA for IT production to assist the company CAT (Renault subsidiary)
– Oracle DBA for tuning the performance of several application at SFR (French mobile phone company)
April 2005 – December 2006:
– Orace DBA IT production at NATEXIS ALTAIR in Paris (IT branch of the French group NATEXIS BANQUE POPULAIRE)
December 2000 – March 2005:
– Oracle DBA IT production at BNP PARIBAS SECURITY SERVICES in Paris.
Professional Experiences Details
May 2017 to January 2019: BPIFrance in Maison-Alfort (Paris region France)
– Migration of databases Oracle 11R2 under windows to Oracle 12.1 Exadata ASM Red Hat Enterprise Linux Server release 6.9 (Santiago)
– Creating database non-CDB, Multitenant CDB, PDB under Oracle database 12.2
– Upgrading database non-CDB from version 11.2 to 12.1, from version 12.1 to 12.2
– Plugging different databases non-CDB to databases PDB having the same database CDB
– Monitoring of patching QDPE (Quarterly Database Patch for Exadata) works performed by Oracle people concerning Grid Infrastructure, Infiniband, Storage Cellserver
– Applying datapatch for database
– Implementation of Dataguard System with broker (both databases Primary and Standby) for several production databases in Exadata environment.
– Performance optimization for very big databases batch treatments with the following methods:
• Gathering statistics with histograms,
• Adding extended statistics,
• Detecting and dropping unused index of very big tables,
• Analyzing AWR, ADDM, SQLHC reports to analyze queries, dbms_sqlpa,
dbms_sqltune facing poor Performance
• Implementation of partitions and sub-partitions
• Implementation of index advanced high compression with Oracle 12.2
• Reviewing of queries using analytic functions such as
RANK, DENSE_RANK, FIRST, LAST, …
• Using the tool Dynatrace to follow all action by users in order to detect
blocking event inside of business software.
– Anonymization of sensitive business data with Oracle Data Masking and/or Informatica
– Performing performance tests and stress tests
– Monitoring Oracle databases with OEM (Cloud Control 13C)
– Backup full and incremental RMAN to TSM servers, implementation procedure to duplicate production to pre-production databases
– Using TFA Collector when opening SR (Service Request) tickets with Oracle support
Applications (in French vocabulary) under my responsibilities:
Assurance Export
Datamart Portail Commercial
Reporting Règlement Bancaire
Entrepôt Comptable
InfoCentre
Mouvements des Fonds
Valorisation des Fonds d’Investissement
Banque en Ligne
Contentieux
Atrium
Prêt
Environment: Exadata X5-2, Red Hat Linux server 6.9, ASM, Window 2008, Oracle Database 11.0.2.4, 12.1.2.0, 12.2.0.1, Multitenant architecture, AMCPower 16.5.4.1, Cloud Control 13C release 2, TOAD 12.10.0.30
December 2015 to April 2017: Louis Vuitton (Group LVMH in Paris)
– Implementing and documentation of the Dataguard system with Broker for databases
Single instance on File System or multi-instances RAC ASM with procedure for Switchover and Failover process.
– Implementing and documentation for scheduled procedures to duplicate databases multi-instances RAC ASM pre-production from RMAN backups on tape of production databases
– Implementing and documentation to protect connection password by using Oracle Wallet, to audit any connection, to anonymize business sensitive data by using Oracle Data Masking
– Tuning the very big database NEMO (4To of partitioned data)
– Migrating databases 11.2.0.3 through 12.1.2.0 using architecture non-CDB with In-Memory option
– Upgrading and moving RMAN catalog schema from version 11.2.0.3 through another RMAN catalog schema version 12.1.0.2
Environment: Exadata X3-2 Linux 6 RAC ASM, Solaris 11, Oracle Database 11.0.2.3, 11.2.0.4, 12.1.2.0
August 2015 – October 2015: HSBC bank PLC in Paris France
Production DBA Oracle Database
Tuning SQL queries having multiple joins of very large tables by creating clustered tables in association with software vendor Dovetail for EVPS (Payment) application
Resolving issues of the current production environment for replication with GoldenGate
Implementing the new production environment for replication with Goldengate having integrated capture, multiple extracts, multiple replicats, bounded recovery, encryption TRAIL files, heartbeat system
Environment: Linux Redhad 6, Oracle Database 11.2.0.4, Oracle GoldenGate 12.1.2
May 2015 – July 2015: SNCF (French National Railways Company) in Clichy-Levallois France
Expert DBA Oracle Database
Tuning and improving performance for SQL statements of FSCM EPM application in association with software vendor PeopleSoft
Expert DBA Oracle GoldenGate
Implementing, operating, documenting and training staff to replicate business data (more than 700 tables) from source database FSCM EPM (product of Oracle PeopleSoft) to 2 target databases PIVOT Train and Infrastructure in multiple regions : Dev, Corrective Testing, Performance, Pre-production, Production.
The source database is running under Grid Infrastructure and RAC configuration having 4 nodes.
Data are managed into +ASM instance.
The replication is configured at Integrated Capture having the mode Downstream Real Time. This replication requires the setting of transport service of Standby redolog from source to target databases.
The replication is using MAPPING, FILTER system to control selected objects, TRANSFORMATION data
Environment: Linux Redhad 4.4.7-4, Oracle Database 11.2.0.3 avec RAC et ASM, Oracle GoldenGate 12.1.2, PeopleSoft
April 2013 – April 2015: GRDF (Gaz Réseau Distribution France), subsidiary of GDF-SUEZ (French energy provider company) in Paris France
Expert DBA Oracle Database
– Implementing Oracle GoldenGate to replicate business data from source database OMEGA to remote databases (Version 11.2.1)
– Migrating Oracle database 11.2.0.3 to 12.1 by using the architecture made of Container database and pluggable databases
– Studying and implementing Oracle Data Masking to replace sensitive information used for development, testing with off-shore partners for nonproduction purposes.
– Studying the impact of performance with In-memory option for Oracle database 12.1
– Optimizing SQL statements for OMEGA application developed by Software vendor CAPGemini
Environment : AIX 6L1, Linux Redhat 5.0, Oracle Database 11.2.0.3, 12.1,Oracle GoldenGate, Oracle Data Masking pack
December 2009 – December 2012: IGEFI
Oracle DBA, AIX Administrator in the Client Support IT Team
– Installing and configuring ClusterWare and RAC for Oracle 11R2, DataGuard System
– Installing Oracle Streams for replication multi-direction of data platforms
– Installing ASM instance with Diskgroup to host databases
– Implementing Transparent Data Encryption with AES128 encryption algorithm in tablespaces to make secure sensitive financial data
– Implementing Oracle Data Redact to mask sensitive data depending to access profile.
– Following up periodically the health sanity of the client database performance with the
safety report in order to propose proactive and preventive recommendations,
– Optimizing client SQL statement with analyzing AWR, ADDM reports, execution plan
– Sizing the required infrastructure in association with HP, IBM to make up the Test, UAT,
Emergency and Production environments
– Performing the stress tests to validate the highest possible business activities
Environment : AIX 5L3, 6L1, Linux Redhad 5.0, Solaris 10, Oracle Database 10R2, 11R2 with ClusterWare and RAC, Data Guard System, Oracle Application Server 10.1.2.0.2, 10.1.2.3, Cloud Control 12CR2
January 2009 – November 2009: APRIONIS (French Insurance Company in Paris)
Project Manager for migration, Senior Oracle DBA
– Implementing and improving the performance of the financial application GP3 V3 edited by Sungard.
– Installing and testing all the environments of the application GP3 Version 3: Test, UAT, Pre-production, Production with components Webintake, Apache, Ldap, Runtime, Oracle Entreprise Database release 10.2.0.4
– Implementing the backup RMAN procedure to save all the databases
– Implementing Grid Control with alerting system to monitor all the databases
– Assisting developing team to tune SQL statements
– Encrypting confidential data and anonymizing sensitive data before sending to outside
Environment : AIX 5L3 TL08, Oracle Database 10R1, 10R2
June 2008 – December 2008 : Orange Switzerland (Prepaid Services Operations in Lausanne and Zurich)
Oracle DBA: install, configuring, load testing of the application Matrix.
– Installing and configuring the pre-production (in Zurich) and future-production (in Lausanne) environments of the high availability architecture Cluster RAC and Dataguard.
Environment: HP-UX Itanium, Oracle Database 10.2.0.3, Oracle Clusterware 10.2.0.1
July 2007 – May 2008: CIMAFAP/AGORA (French Ministry of Agriculture) in Paris
Assistant of IT production Head, Senior Oracle DBA
– Installing the binaries of Oracle Entreprise Edition 10R2 and upgrading all the databases
in version 8i, 9i to the current version 10R2
– Implementing the daily backup RMAN procedure
– Implementing the duplicating procedure to duplicate production to test database with RMAN
– Tuning SQL statements, partitioning the very large tables of the Datawarehouse database
(3 TG of data)
– Assisting the developing team to rewrite SQL requests
– Training the internal staff to perform daily maintenance tasks
– Managing rules, privileges, security access of the Finance General Ledger application
Environment: AIX 5L2, Oracle Database 8i, 9i, 10R2, Oracle E-Business Suite 11i
Oracle General Ledger product version 11.5.10.1, Accounting Book application
January 2007 – June 2007: EDS France in Nanterre (France)
Oracle DBA for IT production to assist the company CAT (Renault subsidiary)
– Installing and configuring Oracle Application Server 10R2 with
* Oracle Application Server Infrastructure 10G 10.1.2.0.2 with metadata database
* Oracle Application Server 10G 10.1.2.0.2 having Business Intelligence and Forms
– Installing Oracle Entreprise Edition Database 10R2
– Upgrading all the databases 8i, 9i to 10R2, Implementing the daily backup RMAN procedure
– Implementing Dataguard System for Production database with possibility to switch over
Primary/Standby databases
Oracle DBA for tuning the performance of several applications at SFR (French mobile phone company)
– Analyzing AWR, ADDM reports and tuning SAP SQL requests
– Partitioning and subpartitioning large table/index
Environment: HP-UX 11i, Oracle Database 9i, 10R2, Oracle IAS 10R2
April 2005 – December 2006:
Orace DBA IT production at NATEXIS ALTAIR in Paris (IT branch of the French group NATEXIS BANQUE POPULAIRE)
– Duplicating, copying, moving data with Export transportable tablespace module between
different production platforms,
– Implementing the daily backup with SqlBacktrack for Oracle utility,
– Configuring OEM to monitor databases with alerting system,
– Tuning and improving SQL requests,
– Training the internal staff to use SqlBacktrack for Oracle utility,
– Installing Oracle IAS 9.0.4 having components: Infrastructure Server, Business Intelligence and Forms for the project Flexcube
– Deploying and administrating the FLEXCUBE application edited by I-Flex Solutions
Environment: Aix 5L, Oracle Database 9iR2 10G R2, Oracle Application Server 9.0.4, OEM
December 2000 – March 2005:
Oracle DBA IT production at BNP PARIBAS SECURITY SERVICES in Paris for the production applications as Ubix, ClearVision, DCM, StartTeam, Registrar, MTS, Services Communs, ACE-TP, …
– Installing the binaries of Oracle 8i, 9i in single instance, in cluster RAC
of all the environments : Developing, Test, UAT, Emergency and Production,
– Creating, duplicating, copying, moving databases
– Implementing the OEM to monitor with alerting system to raise critical issues
– Being on call support 24/7,
– Tuning databases by analyzing statspack reports, improving SQL statements,
– Assisting the developing team to review database concept design.
Environment : Aix 4.3.3, HP-UX 11i, Solaris 5.9, Oracle 8i, 9i
