SQL Server Database Administration
BANKING, INVESTMENT, REAL ESTATE & INSURANCE
January 2022 – Today (2 years and 8 months)
Paris, France
- Audit and Analysis of SQL Instances
- Configuration: Compliance with “best practices” recommended by Microsoft.
- Security: Adherence to the principle of least privilege.
- Performance: Improved the most resource-intensive queries and stored procedures.
- Installation, Migration, Configuration and Maintenance
- Installation and configuration of instances up to version 2022 SQL Server (Windows)
- Management of high-availability environments (Always-On)
- Management, optimization and administration of database servers (SQL Server)
- Drafting and implementation of a global database administration and security policy.
- Implementation of monitoring probes allowing a real-time overview of the BDD fleet.
- Identification of performance bottlenecks and application of corrective solutions.
- Industrialization of complex tasks (maintenance, backup, ETL).
- Recently
- Migration of 2012R2 and 2016 servers to 2019 and 2022
- Troubleshooting performance issues
- Implementation of CheckMK monitoring