Freelancer profile translated to English.

Description

PostgreSQL and ORACLE databases consultant with extensive experience in implementing information systems. Interventions in contexts collaborating with numerous stakeholders for the implementation of client SI solutions. Offers analytical skills, creativity, rigor, and above all, experience to successfully carry out projects involving a three-tier architecture.

Industry field of expertise

Languages

English
Fluent

Workplace preferences

Remote only

Primarily works remotely

GRDF
DBMS CONSULTANT
ENERGY AND UTILITIES
December 2024 - Today (1 year and 8 months)
Saint-Denis, France
Level 3 Support for PostgreSQL DBMS, Level 1 Support for MongoDB PostgreSQL, SQL Server DBA, MySQL. Ensuring level 2 and level 3 support for incidents and alerts for PostgreSQL databases (physical and logical).
Implementing a backup strategy for all PostgreSQL databases. Designing PostgreSQL backup strategies.
Administration of PostgreSQL Standby databases via MFP. Creating PostgreSQL images via Dockerfile.
Automating updates for Postgres pre-production environments.
Administration of SQL Server databases (MOC).
Administration of MongoDB databases.
Implementing MySQL replication:
• • Validating prerequisites
• • Configuring master (source) / slave (target)
• • Data synchronization (snapshot)
• • Configuring the slave for replication
• • Starting replication
Performing and automating MySQL backups.
Restoring MySQL databases and instances. Point-in-time recovery (PITR) following an incident.
PostgreSQL MySQL Oracle Ansible Grafana
INPI
GRDF Support
CONSULTING AND AUDITS
December 2024 - Today (1 year and 8 months)
Courbevoie, France
Implementing PostgreSQL replications (physical and logical).
Implementing backup/restore strategies.
Deploying PostgreSQL instances.
Administration of PostgreSQL Standby and PATRONI databases. Managing updates and configurations via Ansible playbooks.
Managing and Administering Ansible & Using AWX:
• Multi-pass SSH configuration (Creating an Ansible test environment)
• Installing Ansible and testing basic Ansible commands (ad hoc)
• Implementing a first playbook
• Using a Docker module
• Examples of tasks with the most frequently used modules
• Refactoring/Improving a playbook
Oracle support and administration levels 2 and 3.
Automating Oracle pre-production environment updates. Study, prototyping, and testing of Rman clones from production Oracle databases to pre-production environments.
Migrating Oracle databases to Amazon RDS for Oracle via AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS).
Administration of SQL Server databases (MOC).
Patroni RMAN Oracle Dataguard SQL Server PostgreSQL
AVANISTA
DBMS CONSULTANT PostgreSQL & ORACLE
BANKING AND INSURANCE
December 2020 - November 2023 (2 years and 11 months)
Saint-Quentin-en-Yvelines, France
Implementing the PostgreSQL 11 technical foundation, evolving the foundation to PostgreSQL 14. Harmonizing PostgreSQL versions (installation and upgrade). Implementing PostgreSQL replications (physical and logical). Implementing backup/restore strategies. Deploying PostgreSQL instances.
Implementing PostgreSQL Standby and PATRONI architectures for DR and High Availability.
Implementing internal PostgreSQL training and studying Oracle to Postgres migration (OratoPg).
Oracle support levels 2 and 3. Assisting operations teams with the study, qualification, and integration phases of Oracle architecture solutions (DATAGUARD) on production platforms.
Installing and configuring Oracle databases in production and pre-production environments for the deployment of business applications.
Automating updates (refresh) of ORACLE pre-production environments. Study, prototyping, and testing of Rman clones from production Oracle databases to pre-production environments. Deploying the solution within a defined scope.
RMAN