Freelancer profile translated to English.
Back to original languageAbout Edouard
Senior database administrator, I design, secure, and optimize critical environments for demanding organizations — public sector, finance, industry.
SQL Server expert, my expertise covers the entire lifecycle of a Microsoft estate: high availability architecture (Always On Availability Groups, Failover Cluster), multi-instance administration via Central Management Server, security and hardening (audit, CVE compliance, Active Directory access management), performance (Query Store, Automatic Tuning, forensic optimization), automation (T-SQL, PowerShell, Ola Hallengren, Smart Rebuild), service continuity (Rubrik, recovery plans).
I also have solid skills in PostgreSQL, MySQL/MariaDB, and Oracle Database, and I master the cloud database foundation (Azure SQL Database, Azure SQL Managed Instance, AWS RDS) — modernization, lift-and-shift, on-premises/cloud hybridization, governance, and security. I have an advanced level in Python programming and Terraform.
I work daily on heterogeneous estates of 25 to 50 production instances, all SQL Server versions from 2012 to 2022, in contexts where reliability and traceability are non-negotiable.
Beyond administration, I bring a methodical and documented approach: structured audits, inventory reports, CAB presentations, skills transfer. My interventions leave environments more stable, more secure, and more maintainable than when I arrived.
Available for remote work for ad-hoc missions or long-term commitments.
Mission profiles:
- Complete audit of a SQL Server or multi-DBMS estate
- High availability strategy (AG, FCI, replication)
- Security and compliance (CVE, hardening, access governance)
- Performance optimization on critical databases
- Intelligent maintenance, Query Store, Automatic Tuning
- Migration / consolidation, on-premises to cloud
- Ad-hoc DBA expertise
French
Native or bilingual
English
Native or bilingual
German
Fluent
Remote only
Primarily works remotely
Experience
- ECA Vaud (DSI)Senior Database AdministratorBANKING AND INSURANCEFebruary 2026 - Today (6 months)Pully, VD, Switzerland- Autonomous database referent for a heterogeneous estate of 25 to 50 SQL Server instances (2012 to 2022) including Always On Availability Groups and Central Management Server, Oracle environment, and Denodo, M-Files, Microsoft Dynamics CRM and Business Central business solutions.- Led a cross-functional production hardening program on 25 instances: standardization of autogrowth, Page Verify, Max Server Memory and MaxDOP, deployment of Ola Hallengren maintenance with Smart Rebuild logic, activation of Query Store with Automatic Tuning, implementation of SQL Server Audit. Presentation at CAB.- Full audit of CVE-2026-21262 exposure on 50 instances, identification of two out-of-support SQL 2012 instances with no available patch, documented remediation plan.- Built a linked servers infrastructure controlled from a dedicated Central Management Server, with resolution of NTLM double-hop via dedicated SQL login.- Industrialized DEV/TEST refreshes via a unified script compatible with SQL 2012 to 2022, with DryRun, SkipBackup, and PreRestoreAction modes — reducing environment provisioning time for application teams.- Production incident response: forensic analysis of tempdb saturation on an M-Files instance, diagnosis of a recurrent deadlock related to Full-Text Search's AUTO change tracking, performance analysis of an undersized RAM Business Central database of 155 GB.- Cross-functional audit of named Active Directory accounts across the entire estate, identification of disabled accounts to revoke, governance recommendation.- Versatility in T-SQL, PL/SQL, PowerShell, and Python — choosing the right tool for the job without vendor lock-in.- Direct liaison with application, network, IT security, and vendor teams: simplification, clear procedural documentation for non-specialists.
- Ville de LausanneSenior Database AdministratorPUBLIC SECTORMarch 2025 - January 2026 (10 months)Lausanne, Switzerland- Administration of SQL Server estate (versions 2008 to 2025) in a public sector environment: Level 3 incidents, tuning, rationalization, and harmonized patching across all instances.- Definition and implementation of a global backup and maintenance policy: RPO/RTO formalized by criticality, regular restore tests, retention strategy, backup encryption.- SQL Server 2025 POC: evaluation of new features, compatibility of internal tools, LLM connectivity for internal RAG scenarios.- Automated monitoring and cross-functional audits; production of consolidated stability reports for technical management.- PostgreSQL: L3 support, Foreign Data Wrappers, Python automation, scoping and execution of a migration project to PostgreSQL 16.- PGVector POC: evaluation of embedding and vector search capabilities for internal use cases.- MySQL: handling Level 3 tickets, configuration hardening, backup reliability.- Oracle: support for common requests and monitoring of Data Guard instances.- ERP Support: resolution of Oracle PeopleSoft incidents and support for Abacus / AbaImmo.
- Fédération des Hôpitaux Vaudois (FHVI)Database EngineerMEDICALFebruary 2023 - March 2025 (2 years and 1 month)Prilly, VD, Switzerland- Performance optimization and query tuning on critical health applications subject to high availability and confidentiality requirements.- Migration and clustering of the SQL Server infrastructure to version 2022 with the implementation of Always On Availability Groups; significant reduction of the estate's technical debt.- Industrialization of DBA operations via PowerShell and T-SQL: proactive monitoring, consistent patching strategy, automation of recurring tasks.- Oracle Database administration, introduction of PostgreSQL into the ecosystem, management of an Oracle Database Appliance (ODA).- Interventions within a demanding regulatory framework (healthcare): traceability, access controls, sensitive patient data management.
Recommendations
Be the first to recommend Edouard
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
- Professional License in Computer Systems and Software, Data MiningCNAM2011Licence Pro Systèmes informatiques et logiciels, Data Mining
- Higher National Diploma in Computer Management, ASR OptionCNED2010BTS Informatique de Gestion, option ASR
Certifications
- AZ-400 Azure DevOpsDigiComp2024
- MCSA SQL Server 2016CSC Computing2017