Emeric Tabakhoff

I help my anonymous client to scale his MySQL 5.7 instances on partial replication to full replication on MariaDB 10.5 using MyRocks engine and geolocation capabilities. This is a Linux environment.We also completed the dump/restore strategy with a Mariabackup physical strategy. - Geolocation - Load balancing - Replication - MyRocks

I help companies take back control of their database when they meet a performance or an availability issue.

- Automation of both PostgreSQL instances and backup and restoration processes for Barman with SALT. - Backup and restoration with MariaDB. - Monitoring and turning MariaDB for Zabbix, one of the main supervision components. A series of audits and recommendations to improve performance on each specific instance. - Renormalization. - Query rewrite. - GiN indexing + tsvector for Full Text Search (FTS). Gitlab. Debian. Migration SQL server to PostgreSQL.

From a MySQL 5.7 architecture in docker swarm to a Galera cluster on MariaDB 10.5 using docker swarm. - Migration scripting - Configuration optimization - Mariabackup solution with SST for backups - Full documentation for maintenance. Debian. MariaDB 10.3-10.5. Galera.

DBA PostgreSQL Consultant - Formateur DevOps : SALT: creation de cluster, backup, réplication. Ansible & pg_upgrade : Automatisation pour migration majeure et mineure. Projets maintenus : - Pgbench-tools : https://github.com/emerichunter/pgbench-tools - maintenance_schema : https://github.com/emerichunter/maintenance_schema

DBA Production Mysql et Open Source (MongoDB, Postgres, InfiniDB) - Mise en place de Backup à chaud - Vérification des sauvegardes - Tuning (réécriture de requetes lentes, indexage, analyze...) - Virtualisation - Supervision (Mycheckpoint, McAfee audit plugin, Anemometer, Appmanager...) - Vérification de sauvegardes (ZRM, cold backups...) - Restauration à froid et à chaud. - Réplications MySQL et incidents de réplication - Paramétrage d'instance à chaud et à froid

Tuning, administration, production, exploitation, development, architecture. Main Projects : - performance auditing on every DB : suppressing useless indexes, building new ones to avoid full scan of tables, finding indexes that bring too many lines and finding better indexes to fix the latency - grouping companies (homonymes, filiation) - email recognition (finding the right person or the most likely to be) - producing emails from known structures of emails (from companies and groups), chosing the best possibility from the existing choices to create the corresponding email

Etude, R&D, developpement PLSQL, procédures/fonctions stockées (et packages), interface xsl, migration ERP GeneriX (GCE 140) Rédaction de cahier des charges, Tuning de requetes, rédaction de procédures informatiques, formation de l'equipe d'exploitation.