DATABASE ARCHITECT/ADMINISTRATOR

WORK EXPERIENCES
Since Apr. 2019	Shift Technology, Paris Database Architect - In an environment with more than 200 SQL servers spread across more than 20 datacenters (using several cloud providers) - Backups management - Version migrations: 2014 & 2016 to 2017 & 2019 - Development of an automated inventory system - Development support and query optimization - Setup of a monitoring system using Prometheus & Grafana - Development of a cloud-cost monitoring tool - Management of the ElasticSearch pool Technologies in use: Windows Server 2012r2/2016/2019, SQL Server 2014/2016/2017/2019, SSAS, PowerShell, C#, Prometheus, Grafana, Windows Admin Center
Aug. 2009 Mar. 2019	Betclic Group, Paris, France Database Administrator - Backups management - Setup and maintenance of AlwaysOn high availability groups - Version migrations: 2005 to 2008, 2008 to 2012, 2012 to 2016 - Datacenter migrations - Setup and maintenance of a monitoring DataWareHouse using SSAS 2005/2012/2016 - Control and validation of DB schema changes - Environments management, dev/test/production - Development support and query optimization - Setup of a SSRS report server Technologies in use: Windows Server 2012/2016, SQL Server 2005/2008/2012/2016 (in an active/passive failover cluster and AlwaysOn high availability groups), SQL Server Integration Services 2005/2012/2016, SQL Server Analysis Services 2005/2012/2016, SQL Server Reporting Services 2016, PowerShell, C#
May 2006 Aug. 2009	Transatel, Paris suburbs, France Database Administrator - Setup and maintenance of a backup plan - Setup of a monitoring tool - Setup of a SQL Server 2005 failover cluster and migration from SQL 2000 - Development of ETL for a DataWareHouse using SSIS 2005 - Setup and maintenance of an OLAP server with SQL Server 2005 - New databases creation - Database schema validation - Development support and query optimization Technologies in use: Windows Server 2003, SQL Server 2000 & 2005 (in an active/passive failover cluster), Linux (Debian), SQL Server Integration Services 2005 & SQL Server Analysis Services 2005, PHP5, MySQL 4.1, C#
March 2005 April 2006	Econocom, Paris suburbs, France Database Administrator - Daily monitoring and maintenance of production (backups and customer reports) - Database-specific developments - Bulk data updates - Internal tooling development - Revamp of customer reports tools (from Access to VB6) Technologies in use: Windows Server 2000, SQL Server 2000, Visual Basic 6, Access 2000
Jan. 2004 Feb. 2005	Société Générale, Paris suburbs, France PHP Developer (including 6 months internship) - Development of a PHP application to manage IT computers and network infrastructure (MAC and IP layers, for reporting only) and hardware configurations (hardware upgrades) - Move to production of a network probe project (Windows Server 2003, Linux RedHat, PHP, MySQL 4) - Writing functional and technical specifications of a time tracking tool Technologies in use: MySQL 4.1, PHP 5, Linux (Red Hat), Windows Server 2003
June 2003 Sept. 2003	EDF, ARD department (Distribution Network Access), Paris, France IT technician - Development and deployment of an Access database for management control, dedicated to piloting and following expenses amongst ARD agencies Technologies in use: Access 95, Visual Basic for Applications
EDUCATION
2001-2004	Graduate school: Ecole Nationale Supérieure de l'Electronique et de ses Applications (ENSEA), Cergy, France Graduate degree, July 2004
1999-2001	Graduate school preparatory class
1996-1999	High school Evariste Galois, Sartrouville, France Baccalaureate (mathematics), June 1999
CORE SKILLS
Databases: SQL Server (2016, 2012, 2008, 2005, 2000), MySQL, Access Operating systems: Windows Server (2016, 2012R2, 2008R2, 2003) Computer languages: Transact-SQL, PowerShell, C#
FOREIGN LANGUAGES
French: native speaker English: fluent