SQL Server lead

• Senior SQL Server developer with experience in programming, design and integration of data warehouse and data distribution platforms
• Designs, builds and optimises T-SQL code (stored procedures, functions, views) and data models to produce trusted security/risk reporting and records-management-aligned datasets
• Engineers resilient batch and near-Real Time data processing, with strong data profiling, root-cause analysis and incident/problem management.
• Owns performance tuning and capacity considerations for SOL Server workloads (query plans, indexing strategy, partitioning, statistics, IO/CPU optimisation) to meet SLAs.
• Works with engineers, analysts and control owners to translate security, risk and records-management requirements into robust schemas, data quality rules, lineage and reconciliations; ensures solutions are testable, supportable and compliant.
• Leads by example through peer reviews, coding standards, release discipline and mentoring; proactively manages delivery risks and dependencies across data platform, security, risk and governance stakeholder, * Owns end-to-end delivery of 5QL Server components for security, risk, control and records-management use cases: requirements capture, technical design, build, code review, deployment and documentation, aligned to agreed engineering standards.
• • Implements robust testing and quality controls (eg. t5OLt/unit tests, data quality checks, reconciliations) and supports SIT/UAT/release cycles.
• Ensures database solutions meet security and records-management requirements (classification, retention, access controls, segregation of duties, logging/audit trails), partnering with risk and platform governance as required.
• Designs and evolves data models and physical schemas that support security metrics, control monitoring and MI, with clear lineage and interfaces to upstream/downstream data products.
• Provides operational support for production services (monitoring, incident triage, problem management, remediation and performance optimisation) and drives continuous improvement through automation and, * Source control and branching strategies (Git/GitLab), pull requests, and code review standards.
• CICD tooling (eg GitLab) and release automation for database deployments.
• Artefact/repository management (eg, Nexus) and dependency/version control.
• Scripting/automation (eg, PowerShell and Linux Shell Scripting, plus Python where needed) and familiarity with server scheduling/orchestration patterns.
• Data governance/records management awareness (retention and evidencing) and how these apply to data products and reporting
• Working knowledge of Java and/or Scala particularly where used alongside Spark-based data processing.
• Stakeholder Management and Leadership
• Key stakeholders within the team are the Lead Product Owner, Data Andlysts, PM/scrum masters and Technical Leads.
• Key stakeholders external to the team are the Wealth Enterprise Architects and Client and architects on other platform or project teams that interface to PBTV.

Risk and Control Obiective

• Ensure that all activities and duties are carried out in full compliance with regulatory requirements, Enterprise Wide Risk Management Framework and internal Client Policies and Policy Standards.

• The role holder must be a strong computer scientist with a good appreciation of the fundamental principles of relational database technology
• The role holder must have strong time management skills and be able to juggle and complex and demanding workload
• The candidate will be educated to degree level or above, preferably in computer science or a closely related discipline.
• The role holder will have an excellent command of English language with strong written and verbal communications to deliver against our commitment to providing a world class service and drive our dedication to the client experience., * Expert T-SQL development (complex query design, stored procedures/functions, set-based approaches) with strong code quality and review discipline.
• Strong SQL Server performance engineering (execution plans, indexing, partitioning, temedh, concurrency) and ability to diagnose production issues under pressure.
• Testing mindset and automation: SOLt (or equivalent), data quality assertions, and ability to produce repeatable evidence for security/risk/control reporting
• Good understanding of secure database development and data controls (access management, auditing, sensitive data handling) and confidence engaging with security and risk stakeholders.

Glasgow, Scotland - £425 per day all inc. (PAYE through Umbrella) Contract Posted by: eTeam Workforce Limited Posted: Thursday, 2 July 2026

We are a Global Recruitment specialist that provides support to the clients across EMEA, APAC, US and Canada. We have an excellent job opportunity for you.