Description

Dev /// Web AWS, PHP, Python, Oracle

GIT, Ansible, Docker et

KUBERNETES FRAMEWORKS

RUBY ON RAILS, DJANGO ET

LARAVEL.

/// CLOUD COMPUTING : Amazon

Web Services (AWS),

MICROSOFT AZURE ET GOOGLE

CLOUD PLATFORM (GCP)

BDD expertise /// SQL Server/MySQL/PostgreSQL

Dev and DBA Expert for more than 20 years, I specialize in the administration and optimization of database performance.

Rigorous, responsive and available, I mainly intervene to resolve performance problems and provide lasting solutions to recurring errors.

Our areas of intervention and achievements :

• Audit, Monitoring and Analysis of SQL Instances

- Configuration

- Security

- Performance

- Monitoring: Our BDD clients benefit from the implementation of a monitoring system, CMM Monitoring Tool developed by us.

(screenshots available in the Portfolio area)

• Installation, Migration, Configuration and Maintenance

- Installation and configuration of SQL instances

- Management, optimization and administration of database servers

- Drafting and implementation of a global policy for the administration and security of databases

- Implementation of monitoring probes with real-time

overview of the BDD fleet.

- Identification of performance bottlenecks and application of corrective solutions.

- Industrialization of complex tasks.

• HA and Cloud solutions:

- Disaster recovery (RTO/RPO).

- Load distribution on read-only instances.

- Archiving of backups / old data on the Cloud.

• Cloud & System Architecture:

- Development of Cloud hosting, security advice.

- Design and manage web hosting architectures, develop security and deployment strategies for diverse clients.

- Implement vulnerability and penetration testing services. Develop defensive security policies for our clients to meet regulatory and auditing requirements.

- Supervise system administrator projects, consultant training and monitoring of skills development objectives.

Languages

English
Native or bilingual
French
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

Avizzeo
Failed Application Update on Cloud
DIGITAL AND IT
March 2022 - Today (4 years and 3 months)
Initial and problematic context:
Avizzeo's production environment ran on its cloud service using Kubernetes.
Frequent application version upgrades (deployed via automated updates by their cloud service provider), prevent Avizzeo applications from starting and functioning correctly after deployment. This situation requires a manual redeployment of the application components (for each environment) on the part of Avizzeo then a restart.

Method and expertise:
Following discussions with their developers and an in-depth analysis of the
malfunction and various tests, we were able to identify a DNS resolution error.
The latter prevented Avizzeo's servers from downloading updates, completing their deployment process and correctly restarting application services after the deployment of automated cloud updates.

Resolution and assessment:
We then activated the DNS cache on each of the clusters in order to resolve the
update issues.
From now on, we are continuing the collaboration with Avizzeo by assisting them with their future development and IT support needs.
Kubernetes Google cloud
Solidarites International
Implemented PostgreSQL database reconciliation asynchronous replication process.
CIVIC AND SOCIAL ORGANIZATIONS
October 2020 - November 2020 (1 month)
Bordeaux, France
1. Development and implementation of the database reconciliation asynchronous replication process.
2. Document Bucardo’s conflict management/resolution tasks and steps
3. A Bucardo implementation with synchronization of local office “nodes” (all tables, delta push)
4. Complete documentation detailing the “from scratch” implementation (dependencies, installation, configuration, ssh connection) of Bucardo on a server, with command lines and an explanation
5. Documentation specifying the procedure to follow to add/delete a synchronization table, during an update and a new deployment of the software.
6. Documentation specifying the process to move a Bucardo server + database to a new server, without losing data
Docker PostgreSQL Replication Bucardo