Ofertas › Infused Solutions Ltd
Infused Solutions Ltd · Birmingham, United Kingdom · £60,000 - 65,000 per year
Salary: £60,000 - 65,000 per year Requirements: 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 skills, 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 that affect 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 ability to work closely with software developers. A proactive approach, with the ability to work independently, prioritise issues and drive improvements through to completion. Beneficial experience with Redgate SQL Monitor, SolarWinds Database Performance Analyzer (DPA), Datadog, AWS CloudWatch, Application Insights, Entity Framework Core logging, MiniProfiler, load testing, performance benchmarking, database partitioning, data archiving, large tables, high-volume databases, DACPACs, Flyway, Redgate deployment tools, or Microsoft SQL Server or AWS database certifications. Methodical, analytical and self-motivated, with an interest in investigating complex technical problems. Comfortable working directly with developers, challenging inefficient queries or application designs where necessary, and explaining technical findings clearly to technical and non-technical stakeholders. Responsibilities: 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 issu