SQL Developer (SQL Server)

TL;DR

SQL Developer (SQL Server): Optimising and troubleshooting complex T-SQL queries and database performance for a technology-focused platform with an accent on scalability and reliability. Focus on designing indexing strategies, resolving production bottlenecks like deadlocks, and improving data access.

Location: Hybrid (Maidstone, UK) - must be in office 3 times a week

Salary: £30,000 - £55,000

Company

A growing technology-focused organisation enhancing its data engineering capabilities.

What you will do

• Optimise and troubleshoot complex T-SQL queries, execution plans, and database performance across large datasets.
• Design and maintain indexing strategies, database schemas, and data integrity standards.
• Investigate and resolve production issues, including blocking, deadlocks, and slow-running queries.
• Collaborate with engineering teams to improve data access and system scalability.
• Support database deployments and influence performance and design decisions.

Requirements

• Strong commercial experience with SQL Server, T-SQL, query optimisation, and performance tuning.
• Deep understanding of execution plans, indexing, transactions, and isolation levels.
• Proven experience diagnosing blocking and deadlocks within production environments.
• Track record of working on business-critical systems with strong analytical skills.
• Must be based in or able to commute to Maidstone for hybrid work (3 days/week).

Nice to have

• Experience with large-scale databases, ETL processes, or batch data processing.
• Familiarity with Query Store, Extended Events, and DMVs.
• Experience with cloud platforms such as Azure SQL.

Culture & Benefits

• Opportunity to work on core business-critical systems with real organisational impact.
• Ability to influence database architecture and design decisions.
• Collaborative engineering environment.
• Hybrid working flexibility.
• Ongoing opportunities for professional development and technical growth.