Senior SQL Server Architect

Overview

We are looking for a highly experienced Senior SQL Server Database Specialist to support a critical Database Performance & Stability Assessment / Continuous Expert Review project.

The role will focus on assessing, monitoring and improving the performance, stability and resilience of critical SQL Server environments. The consultant will conduct an in-depth technical assessment, monitor the platform over an extended period, identify root causes and risks, and define a structured remediation roadmap.

What will you do?

Perform a comprehensive assessment of the SQL Server infrastructure, including

• SQL clusters and high availability configurations.
• Storage, network and operating system.
• SQL Server instance configuration and overall health.
• Resource utilization, memory pressure and I/O bottlenecks.
• Wait Statistics, blocking and deadlocks.
• TempDB, fragmentation and statistics.
• Database growth, capacity, logical architecture and indexes.
• Critical queries, Stored Procedures and Jobs.
• Monitor the platform for a period of 4 to 8 weeks to identify performance trends and progressive degradation.

Investigate potential issues such as

• Memory leaks.
• Cache pollution.
• Parameter sniffing.
• Growth of temporary objects.
• Fragmentation and other cumulative performance problems.
• Shadow operational activities, including hourly monitoring, recovery procedures, cluster failovers and incident/alert analysis.
• Identify technical risks, constraints, root causes and supported technical hypotheses.

Define a remediation plan covering

• Quick Wins – actions to be implemented within 2 weeks.
• Medium Term – improvements to be implemented within approximately 2 months.
• Long Term – architectural evolution and strategic improvements.
• Deliver knowledge transfer sessions to APS, DBA and Application teams.
• What are we looking for?
• Minimum of 10 years of experience working with critical database platforms.
• Proven experience with SQL Server Enterprise.
• Strong expertise in Always On Availability Groups.
• Strong knowledge of Windows Failover Clustering.
• Extensive experience in Performance Tuning and troubleshooting.
• Deep understanding of SQL Server Internals.
• Strong knowledge of Memory Management and memory-related performance issues.
• Extensive experience with TempDB optimization.
• Strong knowledge of Wait Statistics analysis.
• Experience with Query Store.
• Experience with Extended Events.
• Strong knowledge of Capacity Planning.
• Ability to perform complex root cause analysis and translate findings into clear technical recommendations.
• Experience working with highly available, business-critical SQL Server environments.
• What can you expect from us?
• A permanent job contract for a long term project;
• Tech equipment + SIM Card + personal smartphone;

Health and Life Insurance;

• Social events and team buildings;
• The commitment of letting you grow with us, and be rewarded accordingly;
• A dynamic and young team that will be always there to support you;
• Training in the latest technologies;
• Coffee, fruits, snacks and a warm welcoming when you pass by the office.