Lionel Vignot, DBA and MS SQL Architect | Power BI Fabric Expert

Freelancer profile translated to English.

Back to original language

Description

I started my career as a freelance MS SQL trainer in Microsoft training centers.

After that, I did a lot of field work as a Production DBA

I know the SQL engine and related products very well: SSIS, SSAS, SSRS, POWERBI, ADF

I also have strong expertise in clusters, Always On, and performance audits.

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Paris (up to 50km)

netprocess
Fabric
February 2026 - Today (6 months)
Self-training and practice on the SaaS platform

Definition of the medallion architecture (bronze, silver, gold)

Data ingestion into the unified LakeHouse: OneLake

PySpark Notebooks

Spark SQL Notebooks

DataFlows Gen2 (Power Query)

Semantic data modeling in star schema

PowerBI report creation

Pipeline creation for notebook orchestration
SAFRAN SAE
Production DBA
April 2024 - January 2026 (1 year and 9 months)
Within a team of 12 DBAs, I was responsible for these activities:

Level 3 support, installation, configuration, optimization, synchronous and asynchronous AlwaysOn Cluster, transactional replication, AWS RDS migration, on-call duty 24/24 for production systems in factories, upgrade from SQL 2019 to 2022, refactoring of maintenance jobs to Ola Hallengren, implementation of Filestream on a SQL cluster, migration of SSIS packages to Azure Data Factory, use of Azure Logic Apps
SQL Server AWS SQL Server DBA Transact-SQL SSIS
BPCE-IT
SSIS, SSRS, and Power BI Expert
TECH
March 2022 - April 2024 (2 years and 1 month)
Creation of DSC PowerShell scripts for binary installation, creation of PowerShell scripts with WMI to configure SSRS and Power BI, integration of the script into a DEVOPS solution: Actifactory, Bitbucket, XLD & XLR from Digital.ai
Microsoft Power BI SQL Server Analysis Services (SSAS) SSIS SSRS DevOps

Check out Lionel's experience

Be the first to recommend Lionel

Help this freelancer shine by sharing your experience working together.

A

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

B

Baptiste Duhen

Fullstack developer

4.6

(4)

5

A

Amed Hamou

Senior Lead Developer

4

(2)

7

A

Audrey Champion

Web developer

4.3

(3)

4

Signup to reveal

Senior Production DBA SQL 2022, BI, ETL, ADF
DBA PROD Senior SQL 2022, BI, ETL,ADF
Microsoft Certified System Engineer No: 327984
1996
Microsoft Certified System Engineer N°: 327984

Check out Lionel's education

Data Base Administrator