SQL Developer

Candour; Stoke-on-Trent; Hybrid; GBP 40,000 - 50,000; Full time

Benefits offered by this job

Hybrid work

Company pension

Free on-site parking

Generous annual leave

Enhanced family leave

Long-service rewards

Job summary

Candour is seeking an experienced Senior SQL Developer to own a critical SQL Server environment, designing, developing and optimising database solutions. You will lead complex T-SQL work, optimise performance, and mentor junior developers in a collaborative tech team.

The role offers hybrid working with a flexible approach, a strong salary package (£40,000 - £50,000 per year is stated), and benefits including pension and on-site parking.

Qualifications

• 5+ years of MS SQL Server development experience.
• Strong T-SQL proficiency and SQL Server 2019+ experience.
• Experience designing relational databases and data models.
• Background working with high-volume transactional databases.
• Experience with ETL processes such as SSIS.
• Knowledge of SQL performance tuning and execution plans.
• Experience with SQL Server Agent, backups, disaster recovery, and security.
• Exposure to Azure SQL Database or Azure SQL Managed Instance is desirable.

Responsibilities

• Lead 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.
• We work with developers, analysts, and stakeholders to deliver effective technical solutions.
• Provide technical guidance and mentor junior developers.

Skills

MS SQL Server

T-SQL

Relational DB design

High-volume transactions

ETL (SSIS)

Performance tuning

SQL Server Agent / backups / DR

DB security

Azure SQL (desirable)

Tools

SSIS

Azure SQL Database

SQL Server Management Studio

Job description

Salary: £40,000 - 50,000 per year

Requirements

• We require 5+ years of experience with Microsoft SQL Server development.
• We require strong T-SQL skills and experience with SQL Server 2019+.
• We require experience designing relational databases and data models.
• We require a background working with high-volume transactional databases.
• We require experience with ETL processes, such as SSIS or similar.
• We require strong knowledge of SQL performance tuning and execution plans.
• We require experience with SQL Server Agent, backups, disaster recovery, and security.
• Exposure to Azure SQL Database or Azure SQL Managed Instance is desirable.

Responsibilities

• We lead the design, development, and optimisation of SQL Server database solutions.
• We develop and optimise complex T-SQL, including stored procedures, functions, views, and triggers.
• We troubleshoot database performance issues, including query optimisation, blocking, and deadlocks.
• We support database security, backups, recovery, and high availability solutions.
• We work with developers, analysts, and stakeholders to deliver effective technical solutions.
• We provide technical guidance and mentor junior developers.

Technologies

• Azure
• ETL
• Support
• SQL
• Security
• SSIS
• Cloud

More

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. You will work within a collaborative technology team and help improve SQL capability across the business. We also offer hybrid working opportunities with a flexible approach, a company pension scheme, free on-site parking, a competitive salary package, a highly generous annual leave allowance, enhanced family leave policies, and recognition schemes with long-service rewards.