Senior SQL Server Performance Engineer for AWS | Ownership

Infused Solutions Ltd

Birmingham

In loco

GBP 60.000 - 65.000

Tempo pieno

6 giorni fa

Candidati tra i primi

Generatore di candidature

Una candidatura fatta su misura per questo lavoro — un curriculum e una lettera di presentazione personalizzati, perfettamente in linea con l'annuncio.

Supera i filtri ATS

Descrizione del lavoro

Infused Solutions Ltd in Birmingham is seeking a Senior Database Performance Engineer to own SQL Server performance across a large AWS environment. You will identify performance bottlenecks, optimise queries and work with developers to measure impact.

The role requires expert SQL Server experience, T-SQL, execution plans, and experience across EC2/RDS. You’ll lead investigations, build dashboards, and ensure high availability and disaster recovery while driving scalable database solutions.

Competenze

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.

Mansioni

Monitor and improve SQL Server performance across multiple instances.
Identify expensive queries, blocking, deadlocks, indexing issues and resource pressure.
Use Query Store, execution plans, DMVs and Extended Events to diagnose root causes.
Compare database instances to identify performance outliers and understand why they behave differently.
Investigate how Entity Framework generates SQL and identify performance issues such as N+1 queries.
Work with developers to implement application-level performance improvements.
Manage database-side changes including indexing, statistics and configuration.
Plan for database scalability as customers and data volumes grow.
Advise on AWS infrastructure, database sizing and performance versus cost.
Support backup, recovery, high availability and disaster recovery strategies.
Lead database performance investigations during incidents.
Build monitoring, dashboards and alerts to identify issues proactively.