Freelancer profile translated to English.

Back to original language

Description

Freelance SQL Server DBA – Expert in database performance, availability, and security.

I optimize, secure, and automate your SQL Server environments to ensure stability and efficiency.

Currently on assignment until December 2025, available from January 2026 for new demanding projects.

Languages

French
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

CIB BANQUE BNP Paribas FRANCE
DBA SQL Server Study and Tuning
November 2023 - Today (2 years and 7 months)
Responsible for activities:
• Audit, tuning, and configuration of the architecture of 11 SQL Server 2017 instances: Processor, RAM, Disk Space, SWAP
• Audit, tuning, and configuration of 22 application databases: Table partitioning, storage space management, index defragmentation, statistics update
• Daily monitoring of the PROD SQL Server: SQL Monitor, extended events, performance counters, system views.
• Monitor and propose solutions for performance issues in views, SQL queries, and stored procedures.
• Audit and implement more performant indexes.
• Optimize statistics updates.
• Implement extended event sessions to capture deadlocks, slow queries, and frequent waits.
• Assist the SQL development team: provide advice, analyze and validate developed SQL queries.
• Splitting an application database into 7 databases. The main objective of this operation is to fix a fundamental design problem of the single application database and resolve its significant contention issues.
• Migration of databases from SQL Server 2017 to SQL Server 2022.
• Implementation of the IN-MEMORY OLTP technique.
• Study, develop, and implement new SQL processes.
Windows Server 2016/2022 SQL Server 2017/2022 Visual Studio 2017 Microsoft Visual Studio IntelliJ IDEA 2021
VINCI CONSTRUCTION
SQL Server Database Administration
November 2018 - October 2023 (4 years and 11 months)
France
• Administration of an IT park of 84 SQL Server instances (2005, 2008 R2, and 2012).
• Management of high availability (Mirroring and Always-ON) for various databases.
• Definition of server hardware and software architectures.
• Installation, configuration, and upgrading of servers.
• Management of database backups and restores.
• Management of database access rights.
• Creation of jobs, alerts, rules, and conditions.
• Server migration.
• Server monitoring: backups, logs, jobs, disk space… etc.
• Definition of strategies for database deployment: data files, log files, index files, naming conventions for tables and stored procedures, appropriate data types for columns.
• Development and optimization of administration stored procedures.
• Validation and deployment of SQL scripts coded by developers.
• Deployment of SSIS packages.
• Development and deployment of SSRS administration reports.
• Server monitoring: Redgate SQL Monitor 9.0, Profiler, Standard Reports, Data Collection, System Monitor, Alerts, Performance Counters, System Views.
• Server optimization: Processor, RAM, Disk Space, SWAP
• Database optimization: Table partitioning, storage space management, index defragmentation, statistics update
• Management of data integration and consistency.
• Assistance to development teams and users.

Environments: Windows Server 2012 R2, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, Visual Studio 2008/2017
AUDIM SA
SQL Server Database Administration
January 2015 - January 2018 (3 years)
France
• Definition of server hardware and software architectures.
• Installation, configuration, and upgrading of servers.
• Management of database backups and restores.
• Management of database access rights.
• Creation of jobs, alerts, rules, and conditions.
• Server migration.
• Server monitoring: backups, logs, jobs, disk space… etc.
• Design and modeling of databases: Collation, tables, columns, links between tables, views, keys, indexes… etc.
• Definition of strategies for database deployment: data files, log files, index files, naming conventions for tables and stored procedures, appropriate data types for columns.
• Development and optimization of stored procedures: use of