SQL Server lead

Trust In SODA; Glasgow; Hybrid; GBP 90,000 - 110,000; Full time

Job summary

Trust In SODA seeks an experienced SQL Server Lead to oversee the design, development and optimisation of data warehouse platforms in a major financial services environment. You will lead end-to-end SQL Server components from design to deployment and documentation, and mentor junior developers.

The role focuses on tuning performance, building real-time data processing, and ensuring security and audit controls. Hybrid working in Glasgow with on-site presence 2-3 days per week is expected.

Qualifications

• Expert-level T-SQL/SQL Server development is required.
• Strong SQL Server performance engineering and troubleshooting experience.
• Excellent understanding of relational database principles and data modelling.
• Experience with database testing, automation and data quality controls.
• Strong understanding of secure database development, access management and auditing.
• Excellent communication and stakeholder management skills.
• Strong problem-solving and ability to manage complex workloads.

Responsibilities

• Lead end-to-end delivery of SQL Server components from technical design through to deployment and documentation.
• Develop and optimise complex T-SQL, including stored procedures, functions, views and data models.
• Own SQL Server performance tuning, including execution plans, indexing, partitioning, statistics and CPU/I/O optimisation.
• Build resilient batch and near-real-time data processing solutions.
• Implement testing, data quality checks and reconciliations for trusted reporting.
• Support production services, incident/problem management and root-cause analysis.
• Ensure database solutions meet security, access control, audit and records-management requirements.
• Work closely with analysts, engineers, architects and risk/governance stakeholders.
• Provide technical leadership through code reviews, engineering standards and mentoring.

Skills

T-SQL / SQL Server development

SQL Server performance engineering

Relational database principles

Database testing & data quality

Security, access & auditing

Communication & stakeholder management

Problem solving & workload management

Tools

Git/GitLab

CI/CD

Nexus','6 weight?

PowerShell

Python

Java/Scala

Spark

Job description

SQL Server Lead - Contract

Location: Glasgow | Hybrid - 2-3 days onsite

Rate: Up to £410/day Inside IR35

Contract until 31 December 2026 (renewable)

We’re looking for an experienced SQL Server Lead to join a major financial services environment, supporting the design, development and optimisation of data warehouse and data distribution platforms across security, risk, controls and records management.

Key Responsibilities

• Lead end-to-end delivery of SQL Server components from technical design through to deployment and documentation.
• Develop and optimise complex T-SQL, including stored procedures, functions, views and data models.
• Own SQL Server performance tuning, including execution plans, indexing, partitioning, statistics and CPU/I/O optimisation.
• Build resilient batch and near-real-time data processing solutions.
• Implement testing, data quality checks and reconciliations for trusted reporting.
• Support production services, incident/problem management and root-cause analysis.
• Ensure database solutions meet security, access control, audit and records-management requirements.
• Work closely with analysts, engineers, architects and risk/governance stakeholders.
• Provide technical leadership through code reviews, engineering standards and mentoring.

Essential Skills

• Expert-level T-SQL / SQL Server development.
• Strong SQL Server performance engineering and troubleshooting experience.
• Excellent understanding of relational database principles and data modelling.
• Experience with database testing, automation and data quality controls.
• Strong understanding of secure database development, access management and auditing.
• Excellent communication and stakeholder management skills.
• Strong problem-solving and ability to manage complex workloads.

Desirable

• Git/GitLab, branching strategies and pull requests.
• CI/CD and database release automation.
• Nexus or similar artefact repositories.
• PowerShell, Linux shell scripting and/or Python.
• Data governance and records-management experience.
• Java and/or Scala, particularly alongside Spark-based processing