Solution Architect

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.