Emeric T.

Database Administrator

760 dollar

My experience

More

Ministère de l'Europe et des Affaires étrangèresSeptember 2019 - Present

Automation of backup and restoration processes for Barman with SALT. Backup and restoration with MariaDB. Monitoring with Zabbix.

SPHEREAugust 2019 - Present

More

LoxodataMarch 2017 - May 2019

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
More

Cap Data ConsultingSeptember 2014 - February 2017

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
More

IKO SystemNovember 2012 - April 2014

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
More

AnimalisJanuary 2010 - November 2012

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.
More

AlphaOhm IDFOctober 2008 - December 2009

Builiding the Database
Chosing constraints fitting the need of the client (PK, FK, unique, NOT NULL...)
Development PL/SQL
Administration

My stack

Languages

PL/SQL, XSL, XSLT, Unix Shell Scripting, XSL-FO, Bash

Others

Project Management, Consulting, GitHub

Environment of Development

Oracle SQL Developer, Oracle PL/SQL Developer

Other

DBA

IT Infrastructure

Git, CentOS, VMware, Ansible, Linux, Ubuntu, Linux Red Hat, Zabbix, Docker, Debian

Databases

PostGreSQL 9, MariaDB, MongoDB, Oracle, MySQL, PostGreSQL

My education and trainings

Technicien en Hypnose - Arche Hypnose2009 - 2020

Master Physique des plasmas - Université Paris Sud2005 - 2008