Freelancer profile translated to English.

Description

Senior Consultant in Data Architecture and Database Administration, with 15 years of experience in critical and high-volume environments. Certified Oracle Expert OCP, with in-depth mastery of Oracle, PostgreSQL, MongoDB, and Cassandra technologies. Specialized in architecture, high availability, performance, migration, and industrialization of data platforms.

Capable of intervening in both strategic and technical aspects, I support companies in designing robust solutions, continuously improving performance, and securing their data infrastructures. My expertise is complemented by a solid project culture and a results-oriented approach.

Languages

French
Native or bilingual
English
Fluent
Arabic
Native or bilingual

Workplace preferences

Can work on-site

Lyon 6e Arrondissement (up to 50km), Nice (up to 100km), Grenoble (up to 75km), Paris (up to 100km), Strasbourg (up to 100km)

Groupe SNCF
DBA Expert
TRANSPORTATION
January 2023 - Today (3 years and 5 months)
Lyon, France
• Administration, operation, and optimization of Oracle, PostgreSQL, Aurora PostgreSQL, MongoDB, and MySQL data platforms on AWS and Azure cloud infrastructures.
• Performance and technical audits of production environments, risk analysis, bottleneck identification, and continuous improvement plan development.
• Architecture studies and support in choosing database solutions tailored to business needs, performance, availability, and scalability constraints.
• Evaluation and comparison of NoSQL and distributed solutions, particularly Couchbase and HorizonDB, for SI modernization and evolution projects.
• Design and implementation of highly available cloud architectures based on Aurora PostgreSQL (Multi-AZ clusters, replication, DR/BCP).
• Definition of operational standards, administration procedures, and data platform governance best practices.
• PostgreSQL, Aurora PostgreSQL, and Oracle performance audits: execution plan analysis, SQL optimization, index tuning, resource sizing, and cloud cost optimization.
• Management and execution of migrations to Aurora PostgreSQL, including impact studies, schema conversion, performance testing, and cutover plans.
• Implementation of data migration and synchronization solutions using AWS Database Migration Service (DMS).
• Definition and deployment of backup, restore, replication, and business continuity strategies for critical databases.
• Industrialization and automation of administration tasks using Terraform.
• Expert-level support for project and operations teams on complex issues related to database performance, availability, and architecture.
Amazon Aurora Terraform Couchbase
ENEDIS
Senior DBA
ENERGY AND UTILITIES
August 2018 - April 2022 (3 years and 8 months)
Lyon, France
• Cross-functional expertise in Oracle, PostgreSQL, Cassandra, MongoDB, and MariaDB technologies within critical high-availability environments.
• Administration, supervision, and evolution of data infrastructures with high volumes and strict availability requirements.
• Handling major incidents, managing escalations, and actively contributing to crisis cells to ensure service continuity for strategic applications.
• Technical audits, risk analyses, and recommendations to improve the reliability, availability, and performance of data platforms.
• Management of continuous improvement actions and implementation of preventive solutions to anticipate service degradations and recurring incidents.
• Cassandra expertise: diagnosis and resolution of complex incidents, performance optimization, data distribution analysis, JVM tuning, and system configuration optimization.
• Architecture studies and robustness testing of Cassandra clusters to validate their resilience and capacity to support production loads.
• Definition and implementation of backup, restore, and security strategies for Cassandra environments.
• Automation of operational procedures and industrialization of data refreshes between production and pre-production environments.
• Advanced administration and troubleshooting of PostgreSQL platforms (versions 9.6 to 13), including performance analysis, SQL optimization, and version upgrades.
• Support, training, and guidance for technical teams on best practices for database administration, operation, and performance.
• Participation in technical committees and steering committees within the framework of service level agreements and continuous improvement.
PostgreSQL MongoDB MySQL Elasticsearch
Amen bank
Service Manager DBA
BANKING AND INSURANCE
January 2014 - April 2018 (4 years and 3 months)
Tunis, Tunisia
• Installation of Oracle Grid Infrastructure 11gR2 (2-node RAC and Data Guard in ASM) for the Production environment.
• Responsible for the management and evolution of Oracle databases (Production, testing, and Development).
• Implementation of a strategy for archiving unused or rarely accessed data.
• Successfully migrated numerous banking databases from version 9i and autonomous databases from 10g to 11gR2 RAC (two nodes) on the HP-UX platform using Datapump.
• Responsible for L3 support, resolving incidents related to Clusterware ASM, RAC, Data Guard, RMAN, and databases.
• SQL and database tuning via ADDM, AWR, Toad, and Cloud Control.
• Partitioning of large tables.
• Implementation of backup and restore procedures via RMAN (HOT BACKUP), NETWORKER.
• Creation of architecture, installation, and operational documents for various services.
• Management of Scheduled jobs for task automation.
Weblogic 12c Administrator
• Installation, Configuration, and monitoring of Weblogic 12c application servers.
• Responsible for the production deployment of Banking Applications (Branch system, banking forms/reports applications) on Oracle Application server / Oracle Weblogic application servers.
• Deployment and troubleshooting of J2ee applications on Weblogic server 12c.