You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Florian CourtainFC

Florian Courtain

Senior Infrastructure & SQL Server Engineer

€1,000/day
3 projects
Taradeau, FR
15+ years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Florian

DBA SQL Server since 2014, my professional journey has allowed me to build solid experience in system and database administration, as well as in other areas such as automation (Ansible, PowerShell, T-SQL of course), clustering, Microsoft Azure, etc...

Passionate about my job, I have deliberately remained a "generalist" to fully understand how an information system works, before specializing in SQL Server. My assignments have exposed me to completely different worlds: from small companies with large data volumes to international companies with high availability rates.

I offer:

- SQL Server Performance Audits: in a few days, I identify bottlenecks and offer concrete solutions.
- Administration: I help you maintain your MS SQL servers in working order while guaranteeing the best performance.
- Development: I assist you in automating admin tasks, whether SQL or not.
- Architecture: I help you determine the best solution based on your environment.
- Incident Resolution: I explain how and why the incident occurred and fix it as quickly as possible.

Of course, I leave all the tools used during the assignments with the client, which may be useful in the future, as well as some explanations to help them improve their skills.
  • French

    Native or bilingual

  • English

    Fluent

Remote only
Primarily works remotely

Experience

  • LSDF Conseils
    Senior Infrastructure & SQL Server Engineer
    DIGITAL AND IT
    June 2022 - Today (4 years)
    • SQL Server Audits and design of robust architectures for mid-to-large environments (performance, high availability, security)
    • Deployment of HA solutions: AlwaysOn Availability Groups, Failover Cluster Instances, standalone instances with security hardening
    • Performance Optimization: query tuning, indexing strategies, execution plan analysis, TempDB optimization
    • Implementation of comprehensive maintenance plans: backups, reindexing, statistics updates, DBCC CHECKDB
    • Automation & DevOps: PowerShell, T-SQL, Ansible, GitLab CI/CD, Git, VS Code — industrialization of deployments and operations
    • Cloud Environments: Azure & Microsoft 365 (SharePoint Online, Entra ID, Automation Account); GCP (upskilling)
    • Security: permissions audits, access reviews, and design of authorization management workflows
    • Design of a large-scale archiving framework (1.5 TB): automated recreation of archive databases (full DDL), historical data by functional domain with referential integrity

    🤖 AI-Augmented Engineering
    • Integration of AI-assisted workflows (Claude API, Claude Code) into engineering and operations activities
    • Advanced automation of scripting, IT operations, and architecture design
    • Exploration and implementation of AI solutions to reduce repetitive tasks, accelerate deliveries, and improve technical decision-making
    Powershell IS Architecture Claude Microsoft SQL Server Ansible
  • CCS Conseil & Expertise
    MS SQL Server Consultant
    CONSULTING AND AUDITS
    May 2023 - June 2023 (1 month)
    - Audits of an On-Premise SQL Server instance and delivery report writing.
    - Creation of an SQL AlwaysOn cluster without Active Directory at OVH.
    - Migration of OLTP databases to the cloud, logins, SQL Agent jobs, and all other SQL Server objects necessary for the instance's proper functioning.
    - Migration of Integration Services packages, adding the SSISDB database to AlwaysOn, and correcting SQL Agent jobs for everything to work on the new instance.
    - Creation of a maintenance plan for DBCC CHECKDB, UPDATE STATS, and reindexing.
    - Application of SQL Server best practices identified in the audit.
    SQL Server Windows Server IS Architecture Transact-SQL
  • CCS Conseil & Expertise
    MS SQL Server Consultant
    CONSULTING AND AUDITS
    June 2022 - December 2022 (7 months)
    - Audits of the configuration of 5 SQL Server instances, retrieval of the least performant queries, and report writing.
    - Optimization of indexes, removal of duplicate or unused indexes, creation of a maintenance plan for DBCC CHECKDB, UPDATE STATS, and reindexing, query optimization, TempDB customization, and testing of indirect checkpoint on certain databases.
    SQL Server Windows Server

Reviews

5.0

Out of 2 ratings

CraigC

Craig

CCS Conseil & Expertise

Reviewed on 5/11/2023

Florian provided a high-quality audit, very well written and documented. Available and professional: it's a pleasure to work with him.
CraigC

Craig

CCS Conseil & Expertise

Reviewed on 6/10/2023

Recommendations

Mickael S.MS
Brice CrunchantBC
Craig EfreinCE
Mickael S. and 2 other people have recommended Florian

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Diplôme d'ingénieur, Informatique réseaux, systèmes et multimedia, Informatique
    Conservatoire National des Arts et Métiers
    Diplôme d'ingénieur, Informatique réseaux, systèmes et multimedia, Informatique
  • Licence Industrialisation de Nouveaux Produits, Process, Ingénierie mécanique
    Ecole Nationale Supérieur de Cachan
    2005
    Licence Industrialisation de Nouveaux Produits, Process, Ingénierie mécanique

Skill set

Categories