SQL Developer

Candour
Stafford, United Kingdom
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Stafford, United Kingdom

Tech stack

Azure
Databases
Continuous Integration
Data Integrity
ETL
Relational Databases
Database Development
Disaster Recovery
Monitoring of Systems
Log Shipping
Microsoft SQL Server
SQL Azure
Powershell
Query Optimization
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
T-SQL
System Availability
GIT
Sql Tuning

Job description

We're looking for an experienced Senior SQL Developer to take ownership of a Microsoft SQL Server environment, leading the design, development and optimisation of business-critical database solutions. This role offers the opportunity to provide technical leadership, influence database strategy, mentor other developers and deliver scalable, high-performance solutions that support a growing business. This is an ideal opportunity for someone who enjoys combining hands-on SQL development with technical leadership in a collaborative environment., Take ownership of the design, development and ongoing enhancement of SQL Server database solutions.Serve as the technical expert for the SQL Server environment, driving best practices and providing guidance across the team.Maintain and optimise business-critical databases to ensure high levels of performance, security and availability.Develop and enhance complex stored procedures, functions, views, triggers and database integrations.Monitor database health and identify opportunities to improve performance, scalability and reliability.Investigate and resolve complex database issues, including performance bottlenecks, locking, blocking and data integrity challenges.Oversee database backup, recovery and disaster recovery strategies to ensure business continuity.Work closely with developers, analysts and key stakeholders to deliver robust technical solutions.Review code, uphold development standards and champion best practices across the team.Support project delivery through technical input, solution design and accurate effort estimation.Keep up to date with emerging technologies and recommend improvements to database architecture and development processes.

Requirements

5+ years' experience developing and administering Microsoft SQL Server database solutions.Expert knowledge of T-SQL, including stored procedures, functions, views and performance optimisation.Strong experience with relational database design, ETL processes (SSIS or equivalent) and high-volume transactional databases.Proven ability to troubleshoot and optimise SQL performance, including query tuning, execution plans, locking and deadlocks.Experience with SQL Server backup, recovery, disaster recovery and High Availability technologies (Always On Availability Groups, Log Shipping and Replication).Experience with Azure SQL Database and/or Azure SQL Managed Instance.Familiarity with Git, Azure DevOps, CI/CD pipelines, PowerShell and SQL monitoring tools is advantageous.Excellent analytical, problem-solving and stakeholder communication skills. Desirable: Previous experience mentoring or coaching junior developers and helping to drive development best practices.Experience providing technical leadership and contributing to technical strategy and solution design.

Benefits & conditions

Up to 35 days holiday (including bank holidays).Enhanced family leave.Death in service cover.Employee Assistance Programme.Gym membership contribution.Private dental support.Employee recognition schemes and social events.Annual eye tests and contribution towards prescription glasses.Ongoing professional development within a collaborative and supportive working environment. If you are interested, please apply now!

Apply for this position