Freelancer profile translated to English.

Description

Training Engineer with over 20 years of experience in the Oracle ecosystem, I evolved from the role of analyst developer to that of expert referent, database administrator, then project manager. Certified Oracle professional PL/SQL in 2013. I now specialize in troubleshooting, tuning, and optimizing the performance of Oracle databases. My sharp expertise and global vision of the Oracle ecosystem allow me to intervene effectively in complex and critical environments.

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

BNP PARIBAS
Expert Oracle DBA Studies PL/SQL Performance Optimization
BANKING AND INSURANCE
April 2024 - Today (2 years and 2 months)
Paris, France
Oracle expert specializing in troubleshooting, tuning, and performance optimization. I intervene in the analysis of slowdowns, optimization and rewriting of SQL queries and stored procedures, functions, PL/SQL packages, and system parameters, resolution of critical incidents, and implementation of best practices to ensure the performance and stability of Oracle databases in an EXADATA environment.
Oracle PL/SQL Oracle Oracle Exadata Apache Spark Cloudera CDH
Groupement les Mousquetaires
Applications Manager - Legacy Expert
RETAIL (LARGE RETAILERS)
April 2018 - June 2024 (6 years and 3 months)
Châtillon, France
I joined Les Mousquetaires (STIME) in April 2018 for an initial six-month mission as an expert Oracle PL/SQL Optimization Project Manager. Ultimately, my journey extended over 6 years and 3 months, during which I held various responsibilities: from expert on Legacy systems to manager of several applications. Throughout this experience, I maintained a strong technical expertise, particularly in Oracle, as well as SAP MM, SD, WM, and GOLD.
Oracle PL/SQL Oracle Goldengate ipaas Python (programming language) Postman
BNP PARIBAS
Tech Lead PL/SQL / DBA – Oracle Studies & Performance Optimization
BANKING AND INSURANCE
January 2016 - April 2018 (2 years and 3 months)
Paris, France
Context: OPTIMA Portfolio – Risk and Rating Calculation Engines
Development of PL/SQL modules (functions, procedures, packages) for regulatory risk calculation according to LEXP, Standard IRBA, and IFRS 9 frameworks.
Design and development of utility packages dedicated to statistics management, partitioning steering, and partitioning migration programs (Hash → List).
Handling of Oracle performance issues (analysis, diagnosis, optimization).

Advanced partitioning optimization (pruning, redesign, execution time improvement).
Definition and optimization of indexing strategies and monitoring of impacts (creation / drop).
Oracle statistics management: planning, calculation windows, performance drift analysis.
Oracle / AIX Server optimization (queries, execution plans, system resources).
Assistance and support to developers for PL/SQL and SQL code optimization.
Implementation and validation of new partitioning models (test bases, benchmarks).
Contribution to Oracle 12c migration: backup/restore methodology, roadmap, exhaustive tests, fixes, Oracle SR.
Intervention on production and non-production incidents related to databases.
Volume optimization: shrink, move, segment reorganization.
Technical audits (Oracle databases, AIX server, Oracle Windows clients).
Daily administration of non-production databases: backup, restore, duplication, optimization.

Diagnostic & Tuning Tools:
SQL Tuning Advisor, AWR, ADDM, ASH, TKPROF, SQL Access Advisor, SQLT
PL/SQL ASH SQL tuning advisor ADDM Credit risk