Freelancer profile translated to English.

Description

DBA, consultant and trainer on SQL Server technology for 10 years now, SQL is not a tool for me to work, but it has become a passion.

My days are punctuated by production interventions on various problems, and also by the training I provide to developers.

I hope to be able to share my passion with you as best as possible :)

Workplace preferences

Can work on-site

Chaville (up to 50km), Suresnes (up to 15km), Versailles (up to 10km)

TF1 SA
SQL Server DBA
PRESS AND MEDIA
January 2010 - December 2014 (5 years)
Boulogne-Billancourt, France
My mission is to implement Development, Testing, Pre-production architectures, and provide Production support for various departments of the TF1 group (Broadcast, News, TF1 Video, and Advertising).
I am particularly working on improving the performance and security of these environments.

I also handle the creation and deployment of reports for different needs, as well as the creation of SSIS packages, and finally, environments for cube analysis via Analysis Services.

This position requires great curiosity in various fields (SQL Server, IIS, Citrix, Active Directory, MDT, SharePoint).

DBA at TF1:
Administration on SQL SERVER 2000, 2005, 2008, 2012 - 500 GB volume
• Implementation of MIRRORING architectures
• Implementation of SQL database replication
• Implementation of various SQL backup strategies
• Implementation of maintenance plans: indexing, statistics, integrity
• Monitoring and Troubleshooting of databases
• Production incident management
• Implementation of Always On on SQL Server 2012
• Creation of reports and Implementation and management of REPORTING SERVICES (2005, 2008, 2012)
• Implementation and management of INTEGRATION SERVICES (2005, 2008, 2012)
• Creation of SSIS packages and implementation (2005, 2008, 2012)
• Use of Database Tuning Advisor and SPOTLIGHT tools for SQL performance monitoring, and SQL profiler.
• Creation of Masters, via MDT (Windows 2008 server, 2012 server)
• Creation of Powershell scripts
• Implementation of sites under IIS6 and 7.5
Club Identicar
SQL Server DBA
AUTOMOBILE
January 2015 - March 2020 (5 years and 3 months)
Chaville, France
- Management of PRODUCTION, PREPROD, TEST, and DEV environments and incidents.
- Optimization and rewriting of T-SQL procedures.
- Complete overhaul of night maintenance plans.
- Migration of SSAS, SSIS, SSRS, SQL servers to SQL Server 2019.
- Migration of databases to Cosmos DB.
- Implementation of Always On on all critical servers.
- Implementation of Query Store.
- Improvement of SQL performance related to CRM.
- Complete overhaul of the night plan.

Implementation of 14 internal SQL courses, which are:

- Beware of Parameter Sniffing in your Stored Procedures
- Improvements on SQL code (SARGABLE etc...)
- Clustered and non-clustered indexes: what is the difference?
- Isolation modes on SQL
- DBCC commands (CHECKIDENT etc...)
Etc..

- Creator of the YouTube channel "ELOA SQL":
This channel currently features 203 videos on TSQL, administration, and performance on SQL Server.

Link to the YouTube channel here:
https://www.youtube.com/channel/UCq_l0fiYTZBdKQbWD187peA/videos

And finally, I am the author of 8 courses on the UDEMY platform, including:

- SQL Server: The complete course from A to Z (21-hour course)
- SQL Server: The complete course on BACKUPS and RESTORES
- SQL Server: Detect and repair corruption on a database.
- SQL Server: Improve your performance with indexes.
- PostgreSQL: Postgres for absolute beginners (4-hour course)
- SQL Server: SQL Server for absolute beginners (7-hour course)
- SQL Server: Configuration and modification of a database on SQL
- SQL Server: Transact SQL for developers
SQL SQL Server Training PostgreSQL