SQL Server developer in Glasgow

Role Title: SQL Server lead

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/Git Lab), pull requests, and code review standards.
• CICD tooling (e. g. Git Lab) and release automation for database deployments.
• Artefact/repository management (e. g., Nexus) and dependency/version control.
• Scripting/automation (e. g., Power Shell 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.