CV/Mission d'Ingénieur MariaDB freelance

Exemple de missions d'Aurélien,
Ingénieur MariaDB habitant les Hauts-de-Seine (92)

Expérience

OVHcloud
DBA MariaDB
septembre 2020 - Present (4 mois)
Paris
DBA MariaDB

Jarvis Legal
Audit MariaDB / MySQL
octobre 2020 - octobre 2020 (1 mois)
Paris
Audit MariaDB / MySQL

SFR
Expert MariaDB GaleraCluster
septembre 2020 - septembre 2020 (1 mois)
Audit MariaDB / MySQL
Identify and fix their problems on Galera Cluster & MariaDB

Weglot
Expert MySQL
août 2020 - août 2020 (1 mois)
Paris
Audit MariaDB / MySQL

Criteo
Expert DBA Mysql / MariaDB
janvier 2020 - avril 2020 (4 mois)
Paris, Île-de-France, France

COVAGE
Expert MariaDB / MySQL
septembre 2019 - janvier 2020 (5 mois)
Sèvres, Île-de-France, France

Rue Du Commerce
Expert MySQL/MariaDB DBA + GaleraCluster
septembre 2017 - juin 2019 (1 an 10 mois)
Région de Paris, France
Replication Master / Slave, Galera Cluster avec MySQL and MariaDB.

- Migration à chaud de MySQL 5.1 MySQL 5.5, MariaDB 10.0 & MariaDB 10.1 vers MariaDB 10.3, sans interruption de service.
- Dévelopement d'outils archivage très performant
- Passage des serveurs MySQL en Haute Disponibilité avec GaleraCluster + Haproxy
- Dévelopement d'un outils pour sauvegarder les journaux de transaction automatiquement
- Dévelopement d'un outils pour purger les journaux de transaction automatiquement passé une certaine taille.
- Comparaison de configuration automatique par grappe de réplication Master/ Slave ou Galera Cluster
- Suivi de production

Replication Master / Slave, Galera Cluster with MySQL and MariaDB.
- Hot migration from MySQL 5.1 MySQL 5.5, MariaDB 10.0 & MariaDB 10.1 to MariaDB 10.3, without downtime.
- Development of high-performance archiving tools
- Switching MySQL servers to High availability with GaleraCluster + Haproxy
- Development of a tool to save transaction logs automatically
- Development of a tool to purge transaction logs automatically past a certain size.
- Automatic configuration comparison by Master / Slave or Galera Cluster replication cluster
- Production monitoring

Visa Europe
Expert Galera Cluster / MariaDB / ClusterControl
mai 2017 - septembre 2017 (5 mois)
Région de Paris, France
Mise en place de la plateforme MySQL/MariaDB + GaleraCluster

- Mise en place du chiffrement des tables MariaDB + Journaux de transaction sur GaleraCluster
- Rotation des clefs de chiffrements
- Validation Technique
- Configuration des serveurs sur mesure
- Mise en place de segment de clustering
- Implémentation de ClusterControl pour Visa
- Tests PCI DSS
- Création de scripts de purge automatique très rapide et sans contention. (passe les replications Master/Slave & GaleraCluster) sans problème. (même
résiliant à tout changement de structure de la base de données)

Implementation of the MySQL / MariaDB + GaleraCluster platform
- Implementation of the encryption of MariaDB tables + Transaction logs on GaleraCluster
- Rotation of encryption keys
- Technical validation
- Customized server configuration
- Implementation of clustering segment
- Implementation of ClusterControl for Visa
- PCI DSS tests
- Creation of automatic purge scripts very fast and without contention. (skip Master / Slave & GaleraCluster replications) without problem. (even
terminating any change in the structure of the database)

Saint-Gobain
Expert MySQL & MariaDB
février 2017 - mai 2017 (4 mois)
Région de Paris, France
- Audit & Optimisation (Configuration / Query / CPU / Memory)
- Migration of Sybase IQ, and other databases to MySQL (MariaDB + Galera Cluster)
- Design of new model
- Migration of Data
- Mini website to show the design of queries (few queries and really fast)
- Test of loading with RocksDB + Spider for hudge volumetry (100 000 000 000 of rows for one table)

Transatel
Expert Galera Cluster & MariaDB
octobre 2016 - janvier 2017 (4 mois)
La défense
Audit
Concevoir la nouvelle architecture
Mettre en place et installer la nouvelle architecture
Déplacer les données vers la nouvelle architecture
Alimentation en temps réel
Migration à chaud

Audit
Design the new architecture
Set up and install the new architecture
Move data to the new architecture
Real-time feed
Hot migration

Olkypay
Expert MySQL DBA & Galera Cluster
septembre 2015 - décembre 2016 (1 an 4 mois)
Luxembourg identify and fix their problems on Galera Cluster & MariaDB

Crédit Agricole
Expert MySQL
octobre 2015 - novembre 2015 (2 mois)
Guyancourt
- Fix performance issue
- Fine tuning
- Propose solutions

Visa Europe
Expert MySQL DBA & Galera Cluster
août 2015 - septembre 2015 (2 mois)
Built new payment platform

HUMANIS - Groupe de protection sociale
Expert MySQL DBA & Galera Cluster
juillet 2015 - juillet 2015 (1 mois)
* Tuning InnoDB / MyISAM
* Identify their problems on Galera cluster and solve them
* Configure Galera Cluster
* Teaching to the DBA team about Galera cluster and MySQL

ETAI
Expert MySQL DBA
mai 2015 - juin 2015 (2 mois)
Antony
* Tuning InnoDB / MyISAM
* Identify and Solve problem
* Solve performance issue
* Set up Master Slave
* Documentation about backup with Xtrabackup & setup M/S

W&M Network
MySQL Architect
mars 2015 - avril 2015 (2 mois)
- big data challenge
- sharding with engine Spider / XA / TokuDB on 15 servers
- 50 To of data
- Up to insert 4 To by day

PhotoBox
MySQL DBA
janvier 2014 - janvier 2015 (1 an 1 mois)
Sartrouville
* Development of tools BASH and PHP.
* Tuning InnoDB
* Establishment of Galera Cluster MariaDB 10
* Establishment / improvement of production architectures: MySQL replication, HA.
* Implementation / improvement strategies for backup and recovery.
* Training teams to MySQL best practices.
* Technological survey to assess new solutions around MySQL.
* Migration of all servers from MySQL 5.0 / 5.1 / 5.5 / 5.6 / 5.7 to MariaDB 10

Environment: MySQL 5.0 / 5.1 / 5.5 / 5.6 / 5.7 - MariaDB 5.5 / 10.0 - Galera cluster MariaDB 10 - Percona server 5.6 - Clustrix - HA Proxy - MHA - Ubuntu
- Chef - PHP - PHPunit - Git - Jenkins

Alstom Transport
11 mois
Lead Developer / DBA Oracle / System Admin
septembre 2013 - mars 2014 (7 mois) 92
* Install of new servers on Red Hat 6.3 (mail, apache, oracle, php, git etc..)
* Migration of PHP 4.4 to PHP 5.5
* Benchmark
* SetUp a new framework : Glial
* Implement graphic chart
* Develop first pages with Glial
* Implementation the communication between old application and new one on Framework
Environment: Red Hat 6.3 - PHP 4.4 - PHP 5.5 - Oracle 10g / 11g - javascript - jQuery - CSS 3.0 - VMware - Virtual Box

Technical Director
mai 2013 - septembre 2013 (5 mois)
La défense
* Select the new architecture
* Select the framework the most adapted to the new PHP developments corresponding to the situation
* Planning
* Budject
* Evolution of financial application

Environment: Red Hat 6.3 - PHP 4.4 - PHP 5.5 - Oracle 10g / 11g - javascript -
jQuery - CSS 3.0 - VMware
Esysteme
CEO
avril 2008 - mars 2014 (6 ans)
Région de Paris, France
SSLL, creator of custom solution.
Developement de PmaControl : ********
UI & CLI Tools for DBA & Developer (monitoring / administration / backup / install / cleaner ...)

Arkadin
8 mois
SQL Server DBA
janvier 2013 - mars 2013 (3 mois)
Paris
SQL Server DBA

* Tuning query
* Training teams to best practices.
* Reporting tools
* Study a case of vertical and horizontal partitioning to increase performence with BO
Environment: SQL Server (Log Shipping) - PHP

Auditor SQL Server
août 2012 - janvier 2013 (6 mois)
Paris 17
* Follow the migration and check that we didn't lost data between the old and the new system. and if any difference explain why.
* Development of tools BASH and PHP.
- Made a special tools to extract thousands account Webex to map with their account audio.
=> in sequential : 8 days
=> in multithreading & optimisations : 1.5 hours
- a tools to automatically dump each database on bridge and restore them on a reporting server
- a tools to know if the migration go on good direction or not
- an internal keypass shared between users
Environment : SQL Server (Log Shipping) - PHP – MySQL (replication Master / Slave) - PostGreSQL - Bridge Avaya 6200 - Bridge Avaya 7000 - Bridge Viper
- Gateway - SAN - VMware

MySQL DBA
février 2012 - juin 2012 (5 mois)
Paris
Norms PCI DSS
Optimization ******** ********/ and ******** ********/ sites management of customers / products
Creation of new architechture & data model in MySQL
Recovery / transformation and integration of existing data in Oracle,
PostgreSQL and MySQL to the new model.
Advices and implementation of the technical solution.
Automatic creation of PHP scripts for the models used by Zend Framwork.

LNCR
Project Manager / DBA MySQL / System admin / developer
avril 2008 - juin 2012 (4 ans 3 mois)
Development of the full solution :
Install of servers & DNS & VPN
Created data model
Alimentation of data between fox pro and MySQL
Made the reporting client in PHP, generating result in PDF
Administration of mailbox
DBA MySQL
Hosting of the solution
Support of the solution / Upgrade
Environment: MySQL - PHP - Debian - Linux - bash - Postfix - DNS - Apache -
VPN

Societe Generale
Software Engineer SGCIB / Sybase DBA
mai 2011 - décembre 2011 (8 mois)
La défense
Norms PCI DSS

Project : Migration of databases Sybase
* Planning of migration
* Creating transfer solution for the application (Softwares used 24/24).
* Migration of data (Sybase 12.5 to Sybase 15)
=> 40 bases with high volumetrics for the reconciliation of data from Back
Office and Front, and their consolidation. (used by the main softwares of
security : Eliot /safe).
Responsible middle office on application (Safe) making the reconciliation
between the back office (Eliot) and the front office all the cash flows related to
the India-based (Bangalore) operations team and business managers of major
exchanges (New York / ...