Aurélien L.

Database Developer

765 dollar
Freelancer
16 ans
Paris, FRANCE

Mon expérience

OVHcloudSeptember 2020 - February 2021

Jarvis LegalOctober 2020 - November 2020

Voir plus

SFRSeptember 2020 - October 2020

Audit MariaDB / MySQL

Identify and fix their problems on Galera Cluster & MariaDB

Voir plus

WeglotAugust 2020 - September 2020

Audit MariaDB / MySQL

CriteoJanuary 2020 - April 2020

COVAGESeptember 2019 - January 2020

Voir plus

Rue Du CommerceSeptember 2017 - June 2019

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
Voir plus

EsystemeApril 2008 - March 2018

SSLL, creator of custom solution.
Developement de PmaControl : https://github.com/PmaControl/PmaControl
UI & CLI Tools for DBA & Developer (monitoring / administration / backup / install / cleaner ...)
Voir plus

Visa EuropeMay 2017 - September 2017

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)
Voir plus

Saint-GobainFebruary 2017 - May 2017

- 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)
Voir plus

TransatelOctober 2016 - January 2017

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

OlkypaySeptember 2015 - December 2016

Identify and fix their problems on Galera Cluster & MariaDB
Voir plus

Crédit AgricoleOctober 2015 - November 2015

- Fix performance issue
- Fine tuning
- Propose solutions
Voir plus

Visa EuropeAugust 2015 - September 2015

Built new payment platform.
Voir plus

HumanisJuly 2015 - August 2015

* 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
Voir plus

ETAIMay 2015 - June 2015

* Tuning InnoDB / MyISAM
* Identify and Solve problem
* Solve performance issue
* Set up Master Slave
* Documentation about backup with Xtrabackup & setup M/S

Voir plus

W&M NetworkMarch 2015 - April 2015

- big data challenge
- sharding with engine Spider / XA / TokuDB on 15 servers
- 50 To of data
- Up to insert 4 To by day
Voir plus

PhotoBoxJanuary 2014 - January 2015

* 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
Voir plus

Alstom TransportMay 2013 - March 2014

Lead Developer / DBA Oracle / System Admin
Sep 2013 – Mar 2014

* 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 DirectorMay 2013 – Sep 2013

* 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
Voir plus

ArkadinAugust 2012 - March 2013

SQL Server DBA
Jan 2013 – Mar 2013

* 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
Aug 2012 – Jan 2013

* 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
Voir plus

TSIFebruary 2012 - June 2012

Norms PCI DSS
Optimization http://www.ticket surf.com/ and http://www.ticket premium.com/ 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.
Voir plus

LNCRApril 2008 - June 2012

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
Voir plus

Societe GeneraleMay 2011 - December 2011

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 / Paris / Hong Kong).

Environment: Sybase - csh - ksh - UNIX - Linux - Oracle - P4force
Voir plus

EDFJune 2010 - April 2011

Migration of data from MySQL to Oracle
Management of 10 developers

First project : PGAZ, software which establish the costing of gas.
    * Implementation of engine according to the calculs rules
    * Creation of data model
    * Test with hight volumetry and benchmark
    * Reloading databases.
    * Creation of script SQL

Second project : Implementation of audit software for the European community within the market opened to competition.
    * Install and setup of Oracle server
    * Migration of data from MySQL to Oracle.

Environment: Oracle – MySQL - Linux – RedHat – CSS - Subversion - PHP - CakePHP
Voir plus

Arval - BNP Paribas GroupJuly 2007 - May 2010

Norms PCI DSS

Project 1 : Migration of databases from Sybase 11.10 to Sybase 12.5
   * about 43 databases on 15 servers with huge volumetry

Responsible of software pole of 5 applications deployed each on 6 country (France, Poland, Hungary, Italy, Slovakia and Portugal. in relation to the business manager of each country.

    * Implementation of several action plans between all the different services; operating  System, Database, Business, Top Management.
    * Managing a team of up to 10 people at the peak of activity
    * Optimisation & Rewrite PL / SQL flow with the resulting reduction of treatment 102 hours to less than four hours for the integration and the different calculations over 8 GB of data daily. Reducing a second treatment 22 hours (in delta) to one hour (in full).
    * Implementation of reporting's tools for the PDG (under MySQL)
    * Implementation of monitoring's tools in real time on each process / alimentation / software, to be proactive to various problems. (Under MySQL)
    * Application maintenance and scalable.

Project 2 : Deploy each software to a new country : slovakia
Voir plus

KeyrusJanuary 2007 - April 2008

Used as a Keyrus's firefighter (was my surname) to identify various problems and solve them for ~50 different customers.

Environment: MySQL (MySQL cluster / Master slave / HA) - PHP - Linux - Apache - Hardware
Voir plus

vente-privee.comMay 2007 - July 2007

Project: creation / implementation of sales in relation to sales manager

Environment: Paintshop pro – ASP – SQL serveur
Voir plus

E. LeclercJune 2007 - July 2007

Solved a problem on performance issues due to the daily integrations of billions of products.

* Query optimization resulting in the reduced time updates over 4 hours to 20 minutes

Environment: PostGreSQL - ETL
Voir plus

CHOPIN TechnologiesApril 2007 - May 2007

Increase perf of application
Optimizing SQL queries.

Environment: MySQL - PHP
Voir plus

Doctissimo.frJanuary 2007 - April 2007

* Optimization of the internal framework and MySQL queries
* Optimizing the generation of thumbnails on the website developed in PHP
* Optimization Module "recipes" based on MySQL Cluster

Environment: MySQL (MySQL cluster / Master slave / HA) - PHP - Smarty - Spip
Voir plus

WGTourNovember 2005 - January 2007

Follow production
Restructuring of the website (3000 new connections / second)
Upgrade website on PHP5
Optimizing SQL queries.
Training teams to MySQL best practices.
Improved caching system
Module Creation 'Cup World Team' in an array of 128 teams fully automated

More than 350 000 members, about 50 000 members connected each week.

Environment: MySQL - PHP - Debian - Apache - java - javascript - CSS
Voir plus

Cafedelavenir.orgJanuary 2007 - January 2007

Complete rewrite of the website with new features.
Voir plus

CETRILApril 2006 - December 2006

CETRIL (European Transfer Center and Research Computer Free)

Project:
    * Making a shared website for all the municipalities of the metropolitan area of Soissons.
    * Website creation and www.tropheesdulibre.org www.cetril.org, originally designed in java.

    * Meet with most of personnality of free software (Richard Stallman, Mark Shuttleworth, Richard Piacentini, Rasmus Lerdorf, Michael Widenius ...)

Environment: MySQL (Master slave) - PHP - Debian - Typo 3
Voir plus

FCS-InformatiqueOctober 2006 - October 2006

Project : Development of software for customer management, subcontractor for a construction company, to generate PDF documents in real time.

Environment: PHP - MySQL - PDF
Voir plus

United TeamOctober 2005 - October 2005

Creating a news module, independent comment and a system for replays.
(Parsing a binary generated by StarCraft)
Voir plus

MKV4ALLJune 2005 - June 2005

Realization of the script to retrieve informations (director, actors, film synopsis) automatically. www.mkv4all.info

Environment: PHP - MySQL - Debian - Linux - Apache
Voir plus

Info-MediaJune 2004 - January 2005

Optimizing query on front-end, over 3 minutes to less then 2 secondes.

Creating a back office and updating the front office, management of inventory (real / virtual), suppliers, customers, vendors, quotes, invoices, products, categories, orders, and online sales.

Environment: Debian - MySQL (Master / slave) - PHP
Voir plus

W & M NetworkDecember 2004 - January 2005

Generate statistics for P2P (mldonkey)

Development of several robots to search for and retrieve files via a key word base predefined, downloaded automatically, and finally to open head of video files to know the concurrents.

Environment: Debian - MySQL (Master / slave) - PHP
Voir plus

StarCraft LegionDecember 2002 - January 2005

Realization of the entire website (personal website of a team of video game on Sracraft Broodwar)

I used this website to increase my skill on PHP & MySQL.

System development of news with translations and commentary, members management module, statistics, gallery, forum, the identification system, management of a ladder, and team match meetings module with replays and details of the party.

Created script to extract data from a binary (replay) generated by Stacraft

Environment: Debian - MySQL (Master / slave) - PHP - Debian - Apache - CSS - Javascript - Postfix - DNS - FTP - Imap - SpamAssassin - bash
Voir plus

UtelMay 2004 - May 2004

Statistics on SMS reception according to keywords

Environment: MySQL (Master / Slave) - PHP - Debian - Linux - bash

Mes compétences

Others

Avaya, MySQL Clustering (Galera; Master-Master, Master-Slave replication), SEO, GitHub

Protocols

SSH, LDAP

Frameworks

Kohana, CakePHP, jQuery, PHPUnit, Zend Framework, CodeIgniter

IT Infrastructure

Linux, Git, System administration, Debian, RedHat, Samba, Linux Red Hat

Databases

MySQL, PHPMyAdmin, Sybase, MariaDB, Microsoft SQL Server, Oracle, PostGreSQL, TokuDB

Web Analysis and Statistic

Google Analytics

Languages

C/C++, HTML5, JavaScript, PHP, CSS, CSS3, Shell, XML, WSDL, SQL

Open Source solutions

Putty

Application servers

Apache

Environment of Development

NetBeans

Computer Tools

WebEx

Mes études et formations

- IUT du havre2001 - 2003