Database Developer

Audit MariaDB / MySQL

Identify and fix their problems on Galera Cluster & MariaDB

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

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)

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

- Fix performance issue
- Fine tuning
- Propose solutions

* 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

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

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

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.

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

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

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

Environment: Paintshop pro – ASP – SQL serveur

Increase perf of application
Optimizing SQL queries.

Environment: MySQL - PHP

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

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

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

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

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