SQL Developer
Role details
Job location
Tech stack
Job description
Tune and optimise complex T-SQL queries working with large volumes of data Develop and maintain robust indexing strategies Review execution plans to identify and eliminate performance issues Diagnose and resolve production challenges such as blocking, deadlocks, and slow-running queries Enhance database schemas to support data quality and integrity Assist with controlled and reliable database releases and changes Work closely with developers to promote efficient data usage and access patterns
Requirements
Strong hands-on experience with SQL Server and T-SQL in live environments Demonstrated success improving query performance on large datasets In-depth knowledge of indexing techniques and execution plan analysis Proven ability to troubleshoot performance issues including locking and deadlocks Good understanding of transactions and isolation levels Solid experience in data modelling and schema design Background working with high-impact, business-critical systems Desirable
Experience with high-volume or large-scale database systems Knowledge of ETL pipelines or batch processing workflows Familiarity with tools like Query Store, Extended Events, and DMVs