Senior SQL Server DBA - Lead Performance in AWS

Infused Solutions; West Midlands; Vor Ort; GBP 60.000 - 65.000; Vollzeit

Zusammenfassung

Infused Solutions in Birmingham is seeking a Senior SQL Server DBA to own database performance, reliability and optimisation across its AWS environment. This hands-on role places you as the primary technical owner of SQL Server administration, focusing on scalable solutions and proactive improvements to run-time efficiency.

You will collaborate with software developers to diagnose bottlenecks, optimise queries, implement resilient backup and recovery, and drive changes that boost application

Qualifikationen

• Proven experience as a SQL Server DBA, Senior Database Administrator or Database Performance Engineer.
• Strong Microsoft SQL Server administration and troubleshooting skills.
• Advanced T-SQL, including query optimisation and understanding of the SQL Server query optimiser.

Aufgaben

• Administer, maintain and optimise multiple Microsoft SQL Server instances.
• Monitor database performance and proactively identify potential issues.
• Investigate slow-running queries, blocking, deadlocks, indexing problems and execution plan regressions.
• Use Query Store, execution plans, Dynamic Management Views (DMVs) and Extended Events to diagnose performance issues.
• Optimise T-SQL queries, indexing strategies, database statistics and SQL Server configuration.
• Investigate SQL generated by Entity Framework, identifying N+1 queries, excessive data retrieval and inefficient application-to-database interactions.
• Collaborate with software developers to resolve application-level and database-level performance bottlenecks.
• Plan and implement database improvements to support increasing customer numbers and data volumes.
• Support SQL Server environments hosted on AWS, including EC2 and/or RDS.
• Evaluate database sizing, storage, infrastructure performance and cost efficiency.
• Maintain backup, recovery, high availability and disaster recovery processes.
• Support SQL Server Always On Availability Groups and relevant AWS resilience configurations.
• Lead technical investigations during database performance incidents and deliver permanent fixes.
• Develop monitoring, dashboards and alerts to identify performance issues before they affect users.
• Automate routine administration and maintenance tasks using PowerShell and related tools.
• Maintain documentation covering database configuration, performance, resilience and operational procedures.

Kenntnisse

SQL Server DBA

T-SQL

Performance tuning

Execution plans

Indexing and statistics

Always On

AWS (EC2/RDS)

PowerShell scripting

Entity Framework queries

Tools

PowerShell

dbatools

AWS EC2

AWS RDS

SSMS

Extended Events

Jobbeschreibung

Infused Solutions in Birmingham is seeking a Senior SQL Server DBA to own database performance, reliability and optimisation across its AWS environment. This hands-on role places you as the primary technical owner of SQL Server administration, focusing on scalable solutions and proactive improvements to run-time efficiency.

You will collaborate with software developers to diagnose bottlenecks, optimise queries, implement resilient backup and recovery, and drive changes that boost application