Senior SQL Server DBA – On-Site, Birmingham

Infused Solutions; Birmingham; Vor Ort; GBP 60.000 - 65.000; Vollzeit

Zusammenfassung

Infused Solutions in Birmingham is seeking a Senior SQL Server DBA to own database performance and reliability across an AWS environment. You will be the primary technical owner for monitoring, tuning and efficiency improvements, collaborating with developers to resolve complex performance issues.

This hands-on role offers significant autonomy, with responsibility for scalability, resilience and long-term database strategy, reporting to the technical leadership.

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.
• Excellent knowledge of execution plans, indexing, statistics and performance tuning.
• Experience administering and optimising multiple SQL Server instances.
• Strong understanding of Entity Framework and how application code generates SQL queries.
• Experience proactively monitoring and diagnosing database performance issues.
• Commercial experience with SQL Server in AWS environments, ideally EC2 and/or RDS.
• Understanding of AWS infrastructure, storage and networking considerations affecting database performance.
• Experience with database backup and recovery, high availability and disaster recovery.
• Familiarity with Always On Availability Groups and/or AWS Multi-AZ configurations.
• Experience planning for database scalability and growing data volumes.
• Scripting skills using PowerShell, dbatools or similar tools.
• Strong analytical and problem-solving skills.
• Excellent communication skills and the ability to work closely with software developers.
• A proactive approach, with the ability to work independently, prioritise issues and drive improvements through to completion.

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

Database Administration

T-SQL

Performance Tuning

AWS

Query Optimisation

Collaboration

Tools

PowerShell

dbatools

AWS EC2/RDS

Jobbeschreibung

Infused Solutions in Birmingham is seeking a Senior SQL Server DBA to own database performance and reliability across an AWS environment. You will be the primary technical owner for monitoring, tuning and efficiency improvements, collaborating with developers to resolve complex performance issues.

This hands-on role offers significant autonomy, with responsibility for scalability, resilience and long-term database strategy, reporting to the technical leadership.