Senior SQL developer

Candour Solutions Limited; West Midlands; Hybrid; GBP 55,000 - 75,000; Full time

Benefits offered by this job

Hybrid working

Company pension

Free parking on-site

Competitive salary package

Generous annual leave

Enhanced family leave policies

Recognition schemes

Job summary

Candour Solutions Limited is seeking an experienced Senior SQL Developer to own a critical SQL Server environment. You will design, develop, and optimise database solutions while mentoring junior developers in a collaborative technology team.

The role focuses on improving SQL capability across the business, with hybrid working options and a competitive salary. Strong expertise in T-SQL, SQL Server 2019+, and data modelling is essential.

Qualifications

• 5+ years experience with Microsoft SQL Server development.

Responsibilities

• Lead the design, development, and optimisation of SQL Server database solutions.
• Develop and optimise complex T-SQL including stored procedures, functions, views, and triggers.
• Troubleshoot database performance issues, including query optimisation, blocking, and deadlocks.
• Support database security, backups, recovery, and high availability solutions.
• Work with developers, analysts, and stakeholders to deliver effective technical solutions.
• Provide technical guidance and mentor junior developers.

Skills

Microsoft SQL Server

T-SQL

ETL (SSIS)

Database performance tuning

Data modelling

Azure SQL (Desirable)

Tools

SQL Server Agent

Azure SQL Database

Job description

We are looking for an experienced Senior SQL Developer to take ownership of a critical SQL Server environment and play a key role in designing, developing, and optimising database solutions.

This is an opportunity for a strong SQL professional to influence technical direction, improve database performance, support business-critical systems, and mentor other developers. All the while, working within a collaborative technology team and playing a key role in improving SQL capability across the business.

Responsibilities

• Lead the design, development, and optimisation of SQL Server database solutions
• Develop and optimise complex T-SQL including stored procedures, functions, views, and triggers
• Troubleshoot database performance issues, including query optimisation, blocking, and deadlocks
• Support database security, backups, recovery, and high availability solutions
• Work with developers, analysts, and stakeholders to deliver effective technical solutions
• Provide technical guidance and mentor junior developers

Requirements

• 5+ years experience with Microsoft SQL Server development
• Strong T-SQL skills and experience with SQL Server 2019+
• Experience designing relational databases and data models
• Background working with high-volume transactional databases
• Experience with ETL processes (SSIS or similar)
• Strong knowledge of SQL performance tuning and execution plans
• Experience with SQL Server Agent, backups, disaster recovery, and security
• Exposure to Azure SQL Database / Azure SQL Managed Instance is desirable

Benefits

• Hybrid working opportunities with a flexible approach
• Company pension scheme
• Free on-site parking
• Competitive salary package
• Highly generous annual leave allowance
• Enhanced family leave policies
• Recognition schemes and long-service rewards