Senior SQL Server Performance Lead AWS Onsite Birmingham

Infused Solutions; Birmingham; On-site; GBP 60,000 - 65,000; Full time

Benefits offered by this job

Significant ownership of DB性能

Onsite in Birmingham

Autonomy in role

Job summary

Infused Solutions in Birmingham is seeking a Senior Database Performance Engineer to own SQL Server performance across a large AWS environment. You will identify issues, investigate root causes and work with developers to measure impact of improvements.

You will monitor, tune, and scale SQL Server instances, manage indexing and statistics, and collaborate on architecture decisions to ensure resilience and performance. This role is onsite in Birmingham with significant ownership.

Qualifications

• Strong SQL Server experience at senior level.
• Expert-level T-SQL and knowledge of the SQL Server query optimiser.
• Excellent understanding of execution plans, indexing and statistics.
• Experience managing multiple SQL Server instances rather than a single database.
• Strong understanding of Entity Framework and how it generates SQL.
• Experience proactively identifying database performance issues through monitoring and analysis.
• Experience working with SQL Server on AWS, including EC2 and/or RDS.
• Understanding of AWS infrastructure, storage and networking considerations affecting database performance.
• Experience with SQL Server HA/DR, such as Always On or Multi-AZ.
• Experience designing databases and applications to handle significantly larger data volumes.
• Scripting experience with tools such as PowerShell or dbatools.
• Strong communication skills and the ability to work closely with developers.
• A self-starter who can independently identify priorities and drive improvements through to completion.

Responsibilities

• Monitoring and improving SQL Server performance across multiple instances.
• Identifying expensive queries, blocking, deadlocks, indexing issues, execution plan regressions and resource pressure.
• Using Query Store, execution plans, DMVs and Extended Events to diagnose root causes.
• Comparing database instances to identify performance outliers and understand why they behave differently.
• Investigating how Entity Framework generates SQL and identifying performance issues such as N+1 queries and excessive data loading.
• Working closely with developers to implement application-level performance improvements.
• Managing database-side changes including indexing, statistics and configuration.
• Planning for database scalability as customers and data volumes grow.
• Advising on AWS infrastructure, database sizing and performance versus cost.
• Supporting backup, recovery, high availability and disaster recovery strategies.
• Leading database performance investigations during incidents.
• Building monitoring, dashboards and alerts to identify issues proactively.

Skills

SQL Server

T-SQL

Execution plans

Query Store

AWS (EC2/RDS)

Indexing/Statistics

PowerShell

dbatools

Tools

PowerShell

dbatools

Job description

Infused Solutions in Birmingham is seeking a Senior Database Performance Engineer to own SQL Server performance across a large AWS environment. You will identify issues, investigate root causes and work with developers to measure impact of improvements.

You will monitor, tune, and scale SQL Server instances, manage indexing and statistics, and collaborate on architecture decisions to ensure resilience and performance. This role is onsite in Birmingham with significant ownership.