2 of 2 Permanent Statistics Jobs in Birmingham

such as N+1 queries and excessive data loading. Working closely with developers to implement application-level performance improvements. Managing database-side changes including indexing, statistics and configuration. Planning for database scalability as customers and data volumes grow. Advising on AWS infrastructure, database sizing and performance versus cost. Supporting backup, recovery ...

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 ...