Freelancer profile translated to English.

Description

For over 20 years, I have acquired solid expertise in various technical fields (SQL Server DBA, SSIS ETL, VB.Net/C# back-end Developer) which allows me to have a global vision of company issues.

From modeling (MERISE) to optimization or feeding your Data Warehouses, I can work on all your SQL Server databases.

Passionate about the DBA profession, I have a pragmatic approach to SQL Server issues:

- analysis, audit, and needs assessment

- implementation of sustainable solutions, configuration, indexing, rewriting of procedures and Best Practices

- monitoring, maintenance plan

Good communication and interpersonal skills, I can quickly integrate into existing teams to implement effective solutions in the shortest possible time, both in person and remotely.

The transmission of good practices is an essential part of my mission.

The remote work pace is negotiable depending on the distance and the mission's needs.

Languages

French
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

Crédit Agricole Immobilier
SQL Developer
BANKING AND INSURANCE
January 2024 - Today (2 years and 5 months)
Guyancourt, France
Maintains operational databases (optimization, indexing, tuning, query rewriting).
Optimization of synchronization tools between databases (Informix & SQL Server); SSIS & linked servers.
SQL 2008 => 2016 Migration
Creation of a Windows service (C#, Quartz.NET) to replace SQL Agent.
Extraction, Reporting
SQL Server SQL Server Reporting Services (SSRS) SSIS Transact-SQL .NET C#
CEGOS
BI Developer
EDUCATION AND E-LEARNING
May 2023 - December 2023 (8 months)
Issy-les-Moulineaux, France
Development, maintenance of DWH (SSIS / SQL Server 2016)
Development, maintenance of OLAP CUBE (pricing, center performance)
Creation, development of SSIS packages
SSRS Reporting & PowerBI dashboards
SQL Server Analysis Services (SSAS) Microsoft Power BI SSRS SSIS SQL Server
Orsys
SQL Server DBA
EDUCATION AND E-LEARNING
December 2021 - April 2023 (1 year and 5 months)
Courbevoie, France
Implementation of maintenance plans (backup, re-indexing)
Optimization (indexing, parallelism, sizing)
DWH Modeling / SSAS Cube Creation
Training / assistance for developers
SQL Server SSIS SQL Server Reporting Services (SSRS) Transact-SQL