Freelancer profile translated to English.
Back to original languageAbout Christophe
Hello,
I am a SQL Server, Oracle, PostgreSQL, and MySQL database administrator with 17 years of experience in various DBA tasks.
My expertise includes installation, configuration, tuning, backup strategy, replication, monitoring, reporting, integration into environments such as OLTP and DWH, whether on Linux or Windows OS in single instance or multi-node.
I am accustomed to using tools like Tkprofs, StatsPacks, AWR, RMAN, Active duplicate, SQL Hints, maintenance plans, partitioning, SSIS, SSRS, SSAS, DTSX, AlwaysOn, Mirroring, Logshipping, Standby, Profiler, Data Collector, Pgbadger, Barman, PgBackRest, Pitrery, Xtrabackup, Mariabackup, ProxySQL. I am also used to creating Bash, Shell, Powershell, T-SQL, PL/SQL scripts.
I can provide comprehensive services for your existing databases as well as install and configure your future databases.
Polish
Native or bilingual
English
Fluent
Can work on-site
Lille (up to 50km)
Experience
- EuroprocurementDBAJanuary 2017 - January 2017A distanceImplementation of maintenance plans for database checks, statistics updates, and index rebuilds. Implementation of the data collector.
- -Multi-DBMS DBAPRESS AND MEDIAJuly 2010 - Today (15 years and 10 months)Lille, France: SQL Server, Oracle, PostgreSQL DBA:• Scope of 200 multi-DBMS databases spread across 90 servers• Architecture definition, implementation, administration, operation, migration, audit, and optimization of environments• Integrated operational chain (Backup, statistics, export, logical replication between databases)• SQL Server Licensing Audit with action plan for various sites not in compliance with group rules• Audit of all SQL Server databases on configuration, security, optimization, backups, reporting with action plan for standardization• Dematerialization of time tracking & leave requests, absences to a PostgreSQL database• Migration plan from Oracle park to 12c• Integration of Multi-DBMS Monitoring into Centreon & PRTGConsulting with business design and development teams:• Audit (StatsPacks, tkprof, Profiler, Data Collector, PgBadger…) and optimization of PL/SQL, T-SQL batchs/queries (Execution plan analysis & reporting)
- -DBA & Application EngineerE-COMMERCEDecember 2006 - July 2010 (3 years and 7 months)Lille, FranceSQL Server DBA & Application Engineer:• Scope of 50 databases for 25 servers & 150 application servers• Architecture definition, implementation, administration, operation, migration, audit, and optimization of database environments, web (IIS, WS, Postfix), and application (Client Intranet, completion, data flows)• Real-time monitoring and optimization of client mailing campaigns• RPO/RTO optimization, implementation of a backup solution for a 24/7 high availability platform to support the sending of 1.5 billion emails monthly.• Study & implementation of the migration of the SQL Server park between two datacenters without service interruption (hosting change)• Consulting with business design and development teams:• Audit (Profiler, Resource Monitor) and optimization of T-SQL batchs/queries (Execution plan analysis, DTSX/SSIS/SSAS/SSRS debugging)• Implementation of SSRS reports
Reviews
Valentin
YouScribe
Reviewed on 6/12/2020
Christophe worked on configuring Barman to store backups on Google Storage.
He did more than expected, he is very professional in his interactions and in his intervention report.
Thank you.
Gilles
Europrocurement
Reviewed on 4/10/2017
Christophe provided a SQL Server training day for us. We appreciated the quality of his service. Thank you.
Recommendations
Be the first to recommend Christophe
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- GRI LicenseCFA Léonard de Vinci2006
- Management Information Technology BTSIFFA Massy2005