SQL Server Developer

Role Title: SQL Server lead Location: Glasgow/ 2-3 days a week onsite Duration: 31/12/2026 Role Description: Overall purpose of role • 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 stakeholders. Key Accountabilities • Owns end-to-end delivery of SQL 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 (e.g.. TSQLT/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 Person Specification • 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. Essential Skills/Basic Qualifications: • 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: SQLT (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. Desirable skills/Preferred Qualifications • Source control and branching strategies (Git/GitLab), pull requests, and code review standards. • CICD tooling (e.g. GitLab) and release automation for database deployments. • Artefact/repository management (e.g., Nexus) and dependency/version control. • Scripting/automation (e.g., 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 BAs 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 Policies and Policy Standards.