Freelancer profile translated to English.

Description

DBA Consultant, I have been involved in major projects such as New Ma Banque, which is the overhaul of Crédit Agricole's mobile application, as an Elasticsearch expert, as well as in the agile transformation of Coliposte IT.

Senior SQL SERVER Expert with over 20 years of experience in critical environments, particularly in the banking and financial sector. Expert in SQL Server versions 2008 to 2022, I ensure the complete administration of large parks including high availability architectures (AlwaysOn, clustering), operational maintenance, advanced tuning, L3 incident management, and environment security.

I have managed numerous complex migration projects (multi-version, consolidation, post-migration optimization), as well as the implementation of development, pre-production, and production environments.

Performance and reliability oriented, I master troubleshooting, optimization of queries and performance parameters, automation, maintenance plan management, and environment auditing.

Accustomed to the strong demands of the banking world, I am capable of guaranteeing the stability, performance, and availability of SQL Server platforms while providing an expert perspective on their evolution.

I have also written a utility for performance and capacity analysis of SQL engines.

Oracle Consultant, I was involved in the overhaul of Oracle environments on OLVM platforms for Sigma company clients.

Versatile on Windows/Linux environments, I have carried out a lot of scripting in shell, powershell, ansible...

Available and mobile throughout France, I favor the cities of Paris, Montpellier, Nantes, Angers, Rennes, and Tours and their surroundings.

Passionate about nature and especially horses, and sports.

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Laval (up to 50km), Paris (up to 50km), Nantes (up to 50km), Tours (up to 50km), Angers (up to 50km)

Crédit Agricole-GIP
On Malt
Oracle DBA
BANKING AND INSURANCE
January 2025 - Today (1 year and 5 months)
Guyancourt, France
•Database migration project management
•Performance solution analysis and implementation
•Database park administration:
oOperational maintenance
ORACLE ODA
SQLSERVER MULTI VERSION including ALWAYSON
oLevel 3 incident management
oProduction environment audits
oPerformance parameter recommendations
 Consulting Elasticsearch on NMB and OSE projects
cluster architecture (SLA, multi-tenant, ILM, tiering),
index & mappings design, analysis strategy (analyzers), scoring, tuning,
ingestion pipelines (CDC, ETL/ELT, streaming),
“search relevance” (A/B, relevance KPIs, business queries).
Elasticsearch SQLServer Oracle Bash Kibana
CAGIP
ORACLE, SQLSERVER, ElasticSearch EXPERT
BANKING AND INSURANCE
July 2024 - January 2025 (6 months)
Laval, France
Elasticsearch Consulting
SQL SERVER / ORACLE DBA

• Implementation of pre-production and production environments
• Performance solution analysis and implementation
• Administration of the Crédit Agricole database park (dev, test, pre-production, production):
oOperational maintenance of the 1500 production databases
oLevel 3 incident management
oProduction environment audits
oPerformance parameter recommendations
oDatabase creation, duplication, migration.
oProduction installation of packages.
oMaintenance in compliance with the PSI (IT Disaster Recovery Plan)

• Implementation of maintenance plans for each application
• Consideration of high availability for sensitive databases (ALWAYS ON)
• Management of Elasticsearch clusters for the NewMaBanque and OSE9 programs.
Elasticsearch ORACLE DBA SQL Server DBA IT Project Management
Sigma Informatique
ORACLE EXPERT
CONSULTING AND AUDITS
January 2024 - June 2024 (6 months)
Nantes, France
Migration of ORACLE databases to OLVM, removal of RAC mode to switch to dataguard.
Consulting on all new Oracle and Postgres projects.
Level 3 support for major production incidents
Definition of backup and migration methods, redesign of RMAN backups on different hot/cold media.
ORACLE DBA Database administration Project management team coaching IS Architecture