Senior SQL DBA
- Hiring Organisation
- INFUSED SOLUTIONS LIMITED
- Location
- Birmingham, West Midlands, United Kingdom
- Employment Type
- Permanent
- Salary
- £65,000
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 … 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 ...