Freelancer profile translated to English.

Description

Senior / Expert DBA PostgreSQL with over 15 years of experience, I support companies in the administration, optimization, migration, security, and high availability of their critical databases.

I work with SMEs and large groups in demanding environments: banking, telecommunications, industry, transport, administration, and digital services. I have notably worked for Airbus, Transactis, Keyyo, Réseau Ferré de France, Leclerc, Solocal / Pages Jaunes, CNFPT, SNCF, Completel Numéricable, and MCS.

My primary expertise is focused on PostgreSQL, with extensive production experience: complex migrations, replication, backup/restore, tuning, monitoring, security, and high availability. I also have solid experience with Oracle, MySQL/MariaDB, SQL Server, and several NoSQL technologies.

I am involved in:

PostgreSQL, Oracle, MySQL, SQL Server, and NoSQL database administration

Database audit, optimization, and tuning

PostgreSQL/MySQL replication and Galera cluster

High availability with Patroni, ETCD, Pgpool

Oracle to PostgreSQL migration

Migration to Azure and Google Cloud Platform

Migration of large databases, up to over 1 TB

Backup/restore with pgBackRest, Barman, RMAN, Data Pump, pg_dump, mysqldump

Restore tests, PITR, BCP/DRP, and data security

N2/N3 support, incident analysis, and production problem resolution

Automation via bash, sh, and ksh scripts

Key skills: PostgreSQL, Oracle 8 to 19c, MySQL 5 to 8, MariaDB, SQL Server 2016 to 2022, MongoDB, MongoDB Atlas, Cassandra, Elasticsearch, Redis, Linux, Unix, SQL, PL/SQL.

My approach is operational and results-oriented: quickly understand the environment, secure existing systems, identify risks, propose concrete solutions, and deliver clear documentation to technical teams.

Industry field of expertise

Languages

French
Native or bilingual
English
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

Airbus
DBA Projects & Technical Tasks
AVIATION AND AEROSPACE
June 2024 - Today (2 years)
Toulouse, France
Projects and technical tasks:

Installation and configuration of standalone PostgreSQL instances and databases, PostgreSQL in a cluster with Patroni, as well as SQL Server with Always On, in accordance with client needs and Airbus internal standards.

Creation of users and management of access rights on PostgreSQL and SQL Server.

Execution of PostgreSQL restore tests with pgBackRest according to several scenarios, including:

point-in-time recovery, or PITR;
restoration from full backups.

Execution of SQL Server backup and restore operations.

Drafting of SSL/TLS certificate installation procedures for SQL Server and PostgreSQL.

Development of scripts and documentation to standardize user creation and the assignment of specific privileges.

Participation in crisis cells to provide technical support during major incidents.

Creation of problem tickets for detected anomalies and proactive proposal of solutions to prevent their recurrence.

Proposal and update of obsolete PostgreSQL documentation.

Execution of PostgreSQL database audits at client request, with recommendations for improvement.

Database migration management, including:

Oracle 19c to PostgreSQL 15 migration with ora2pg;
PostgreSQL 12 to PostgreSQL 15 migration using a custom script to optimize migration times, especially with large objects.

Training colleagues on certain PostgreSQL features and administration best practices.

Handling of level 3 support tickets for PostgreSQL and SQL Server.

Participation in production on-call duties.

Technical environment:
Approximately 1000 PostgreSQL databases versions 12 to 15, pgAdmin, approximately 1000 Microsoft SQL Server databases, SQL Server 2012 to 2022, Windows Server 2008 to 2022, ITIL.
PostgreSQL Expert High Availability Tuning Backup & restore SQL Server
Keyyo
DBA Audit
TELECOMMUNICATIONS
November 2023 - May 2024 (6 months)
Clichy, France
I was responsible for auditing PostgreSQL instances and improving the existing on-premise environment.

Main missions:

Execution of an audit report covering the entire PostgreSQL infrastructure.
Upgrade of PostgreSQL instances from version 12 to version 15.
Implementation of a physical backup and restore plan with pgBackRest.
Deployment of Patroni to improve environment resilience and high availability.
Security reinforcement, particularly through the implementation of SSL connections and SCRAM-SHA-256 password authentication.
Improvement of supervision and monitoring.
Selection and implementation of Dalibo PostgreSQL support.
Drafting of an operational guide for databases.
Automation of recurring tasks and drafting of associated documentation.
Implementation of a patch management process for database version upgrades.

Technical environment:
SUSE 8 and 12, 10 PostgreSQL instances versions 12 to 16, IBM Cloud, on-premise environment, Windows Server 2022 and 2016, SQL Server 2016 and 2022, Patroni 4.0.2, pgBackRest v2.53, pgAdmin 4.
DB Audit Server/Instance Upgrade Tuning Monitoring Backup/Restore
Transactis
PostgreSQL and MongoDB DBA
BANKING AND INSURANCE
January 2021 - October 2023 (2 years and 9 months)
Fontenay-sous-Bois, France
Project DBA:

Instant Payment:
Instant Payment handles approximately 10 million payments/transfers per year and over 60,000 transactions per day.
The main clients are La Banque Postale, Crédit du Nord, Caisse des Dépôts, Boursorama...

- Migration from DB2 to PostgreSQL 12.2 and PGPOOL 4.1.11 (6 instances of 2.5 TB).
- Instance tuning.
- Implementation of PITR backups with Pitrery (Dalibo) and logical backups with pg_dump.
- Implementation of database security with SSL, AES 256 passwords, and at-rest encryption (encrypting data on disks).
- Implementation of database monitoring.
- Creation of an operational guide for databases.
- Automation of recurring tasks.
- On-call duty for Instant Payment.
- Choice of our EDB PostgreSQL support.
- Implementation of a RACI matrix to define roles and inform the right people.
- Training on alerts and implemented solutions for databases.
- PostgreSQL minor and major version upgrades.

Internal Cloud GTS:

- Definition of installations and configuration for MongoDB/PostgreSQL databases.
- Collaboration with the DevOps team to automate future database installations.
- Implementation of a patch management process for database version upgrades.
- Implementation of monitoring with the Instana (IBM) tool.
- Definition of a part.
- Migration of on-premise databases to the Cloud with multi-AZ deployment.
- Consulting on various projects.
- Implementation of benchmarks with JMETER, PocDrivers to identify certain limitations.

Technical environment:
DB2 ZO/S 2.2, 100 PostgreSQL databases version 10 to 14, 15 MongoDB databases (300 GB to 800 GB) version 5.14, OPS manager version 6.0, PG Admin,
Windows 2008 to 2016 Server, Red Hat 7/8 VMware, Load Balancer (Alteon, Big IP F5), Reverse Proxy, Firewall, Cisco Switch, F5.
Mongo and PostgreSQL Benchmark MySQL Galera Backup Optimization