About Florian
French
Native or bilingual
English
Fluent
Experience
- LSDF ConseilsSenior Infrastructure & SQL Server EngineerDIGITAL AND ITJune 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
- CCS Conseil & ExpertiseMS SQL Server ConsultantCONSULTING AND AUDITSMay 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.
- CCS Conseil & ExpertiseMS SQL Server ConsultantCONSULTING AND AUDITSJune 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.
Reviews
Recommendations
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
- Diplôme d'ingénieur, Informatique réseaux, systèmes et multimedia, InformatiqueConservatoire National des Arts et MétiersDiplôme d'ingénieur, Informatique réseaux, systèmes et multimedia, Informatique
- Licence Industrialisation de Nouveaux Produits, Process, Ingénierie mécaniqueEcole Nationale Supérieur de Cachan2005Licence Industrialisation de Nouveaux Produits, Process, Ingénierie mécanique