Profile
Construction
Financial Services
Holding Companies
Administrative and Support Services
Hospitals and Health Care
Oil, Gas, and Mining
Professional Services
Real Estate and Equipment Rental Services
Retail
Technology, Information and Media
Active

Olivier Sanzot

Data & BI architect, SQL Server professional DBA

About Me

With a comprehensive background in SQL Server, a passion for performance excellence, and a commitment to continuous learning, I am dedicated to driving success and efficiency in all database-related projects, from ETL to Business Intelligence implementation. During the last 25 years, I successfully led numerous performance tuning projects (SQL Server, Oracle), resulting in significant improvements in database speed and efficiency. I also led several VB6, VBA and VB.Net projects, mainly in the finance and Strategic Intelligence fields using mainly SQL Server, Oracle and PostgreSQL. I demonstrated exceptional problem-solving skills and a proven ability to quickly learn and adapt to new technologies and methodologies.

Jurisdiction

Luxembourg | Belgium | France | Netherlands

Experience

Seniority LevelDirector
Years of Experience20+ years
Current StatusActive
SQL Server mentorPartena Professional Services
2020 - Present

• Help development team to write more efficient T-SQL code • Detect performance issues an provide a fix • Improve indexing and partitioning strategies • Improve ETL flows (SSIS) • Monitor SQL Server infrastructure in an Always-On scenario • Work on deploying and migrating SQL Server instances to Azure and MS Fabric

SQL Server AuditorRed Cross Belgium
2025 - 2025

• Audit of the SQL Server infrastructure • Action plan design with focus on o Server consolidation o HR/DA o Performance

BI Architect / MicroStrategy DeveloperBanque Internationale à Luxembourg
2024 - 2024

• Review of the MicroStrategy implementation • Data Warehouse design updates • MicroStrategy dashboards development • MicroStrategy mentoring for internal teams • PL/SQL Queries tuning for direct access to reports

SQL Server ExpertMetron - Dapesco
2021 - 2024

Provide expertise on SQL Server performance improvements in the context of a web application • Detect performance issues and provide a fix • Mentor developers to help writing better T-SQL code • (Re)Organize SQL Server infrastructure to improve performances

Data ArchitectSafran Aerobooster
2020 - 2022

Guarantee best practices in SQL Server development, Talend and SSIS development as well as documentation • Platform and documentation review • Mentoring of PowerBi developers

Data ArchitectSolvay
2004 - 2019

Integrated into several teams on several projects with a business focus on Finance and a technical focus on performances • Financial reporting and consolidation. VB6 development, Oracle / SQL 2005 DBA. Project manager and Team leader of 14 developer in India (3 months on site) • MicroStrategy prototypes. Access to SQL Server, SFDC, SAP BW data • PRG (Prix de Revient Groupe). Maintenance of an Excel application allowing the generation of the Group Carbon report • Executive Committee dashboard on mobile devices development (MicroStrategy) • Focus: Solvay Group Financial reporting web application. Winform (C#) application for Admins. MicroStrategy project for users.

Skills

Core skills0
Languages3

Languages

English
French
Dutch