Overview

We are looking for an experienced SQL Server Performance & Stability Consultant to assess and improve a critical database platform, combining deep technical analysis with a long-term evolution strategy.

The role will focus on identifying the structural causes behind recurring performance degradation, defining a clear improvement roadmap, and ensuring sustainable platform stability through infrastructure, SQL Server, database and application-level analysis.

What will you do?

• Relate current performance and stability issues to the platform’s long-term evolution strategy.

• Identify structural limitations of the existing platform and define an improvement roadmap.

• Perform a comprehensive assessment covering:

  • SQL clusters and high availability configurations.

  • Storage, network and operating system.

  • SQL Server health and instance configuration.

  • Resource utilization, Wait Statistics, blocking and deadlocks.

  • Memory pressure and I/O bottlenecks.

  • Fragmentation and statistics.

  • Database growth, logical architecture, indexes and capacity.

  • Critical queries, Stored Procedures and Jobs.

• Monitor the platform for 4 to 8 weeks to understand its behaviour over time and identify progressive degradation.

• Investigate issues such as:

  • Memory leaks.

  • Cache pollution.

  • Parameter sniffing.

  • Temporary object growth.

  • Fragmentation and other cumulative performance issues.

• Shadow operational activities, including:

  • Hourly platform monitoring.

  • Recovery procedures.

  • Periodic cluster failovers.

  • Incident and alert analysis.

• Identify risks, constraints, root causes and technically supported hypotheses.

• Define a remediation plan divided into:

  • Quick Wins – up to 2 weeks.

  • Medium Term – approximately 2 months.

  • Long Term – architectural evolution.

• Define a roadmap to ensure sustainable platform stability over the next 18 months.

• Recommend tools, configurations and monitoring improvements to anticipate potential issues more effectively.

• Deliver knowledge transfer sessions to APS, DBA and Application teams.

What are we looking for?

• Strong experience assessing and troubleshooting critical SQL Server environments.

• Deep expertise in SQL Server performance and stability analysis.

• Strong knowledge of SQL Server clusters and high availability architectures.

• Experience analysing storage, network and operating system dependencies affecting database performance.

• Strong knowledge of:

  • Wait Statistics.

  • Blocking and deadlocks.

  • Memory management and memory pressure.

  • I/O bottlenecks.

  • Database fragmentation and statistics.

  • Database growth and capacity planning.

  • Index optimization.

  • Critical queries and Stored Procedures.

• Experience diagnosing complex and progressive performance degradation across infrastructure, database and application layers.

• Ability to perform root cause analysis and distinguish between infrastructure, SQL Server and application-related issues.

• Experience defining technical remediation plans and long-term architectural roadmaps.

• Strong analytical skills and the ability to translate technical findings into clear, actionable recommendations.

• Experience working closely with APS, DBA and Application teams and providing technical knowledge transfer.

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.