Freelancer profile translated to English.

Description

Oracle DBA with over 15 years of experience, having worked on several versions of Oracle 8i.....19c (NON CDB, CDB)

Intense experience in administering large production databases (Banks and Insurance, Telephone Operators...)

- Implementation of Oracle new technologies solutions for clients: RAC, DATA-GUARD, STREAMS, Database Vault, Audit Vault Oracle Advanced Security, ...

- In-depth methodology for analyzing and diagnosing performance issues (SQL TUNING, AWR, ASH, DATABASE TUNING)

- Expertise in choosing the right backup and restore strategy as well as various database high availability techniques

- Database version migration

- Security audit operations and controlling access to Oracle databases by integrating Oracle techniques such as (Audit Vault, Database Vault, Database Firewall, Encryption, Oracle Data Masking, ...)

- Installation and heavy maintenance (reorganizations, patches, upgrades, ...)

- Monitoring of ORACLE databases (CLOUD CONTROL, TOAD,..)

Languages

French
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

BPCE International
Oracle Database Administrator
BANKING AND INSURANCE
January 2022 - Today (4 years and 5 months)
Paris, France
 Administration of production/bench/dev Oracle databases
 Oracle database migration
 Level 3 analysis of production database issues
 Oracle Performance Tuning (Tuning performance issues (AWR, ASH, TKPROF, EXACHECK..........)
 Oracle SQL TUNING (Tuning SQL queries and helping developers optimize their processing time ....)
 Optimization of slowness issues at the SQL query level
 Oracle Maintaining HA DATABASE (Service creation, Dataguard, Flashback DB...)
 Oracle Dataguard (Troubleshooting issues at the dataguard level, DG broker, snapshot standby, physical standby, MRP, RFS .....)
 Oracle RMAN Recovery and backup (Restore, Recover rman backup, ZDLRA...... )
 Oracle Restore environment (Bench, Dev, Test, RMAN, CONVERT....)
 Patch installation: installation of RU patches as well as security patches and/or due to a bug
Exadata SQL TUNING TUNING DATABASE Migration
Groupe Crédit Agricole
Oracle Database Administrator
BANKING AND INSURANCE
June 2017 - December 2021 (4 years and 6 months)
Île-de-France, France
RAC 12c implementation Clusterware management Filesystem management ASM Migration Oracle databases Active Dataguard single instance from RAC primary Performance Monitoring (AWR report, Statspack, TAF, ORACHEK, RACCHEK, SQLT...) Security audit of databases (TDE Encryption, Role creation, privilege management ...) Duplication of databases for Pre-prod and acceptance environment RMAN backup restoration (Disks, TSM) Creation of snapshot standby for R/W needs on the standby database Oracle Golden Gate implementation Resolving operational issues (Corruption....) Installing patches at RAC and single instance level Data Export/Import Installation of Cloud Control 12c and agents (approx. 300 databases) Creation of operational scripts (Backup, Alert management, ASM disk space management Grid infra and clusterware management ASM storage migration to filesystem storage
ORADIST
Oracle Database Administrator
February 2014 - June 2017 (3 years and 4 months)
Install and configure Oracle Database on various platforms (Unix, Windows, Aix..) Install and configure Oracle Cloud Control 13c Install and configure Oracle Cloud Control 12c Install and configure Oracle Grid Control 10g, 11g Install and configure Oracle Linux, Solaris, Redhat (Kernel parameters, Packages, users...) Install and configure Windows Server Perform Backup/Restore (RMAN) Generate backup scripts for clients (Full Database, Partial Backup, Incremental Backup) Perform restore tasks in case of client incidents Database duplication Preventive visit and generation of a report evaluating the database situation Implement Real Application Cluster (RAC) 10g, 11g, 12c. Implement Dataguard (Physical standby, Logical Standby) System performance management (Storage, Memory, Partitioning) Database performance management (SGA, PGA, Memory_Target, ASMM, AMM..) Generate reports and snapshots for performance studies (, AWR, Statspack) Configure standby site with Oracle Data Guard (Implementation and testing) Data Import/export Manage database storage structures (File System, ASM..) Manage database files (Alert, control, dbfiles..) Manage alerts (Alert files/trace files) Data migration on different platforms Client-side consulting and problem management Diagnose client databases and provide solutions for issues and meet their needs Manage server security (Database Vault, Audit Vault, Oracle Data Masking) OCE Trainer (ORACLE CERTIFIED SQL EXPERT) OCA Trainer (ORACLE CERTIFIED ASSOCIATE (DBA ADMINISTRATION)) (10g, 11g, 12c) OCP Trainer (ORACLE CERTIFIED PROFESSIONAL (DBA ADMINISTRATION)) (10g, 11g, 12c)