SQL Server Developer

Job Description:

• Senior SQL Server developer with experience in programming, design and integration of data warehouse and data distribution platforms.
• Designs, builds and optimizes 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 SQL Server workloads (query plans, indexing strategy, partitioning, statistics, IO/CPU optimization) to meet SLAs.
• Works with engineers, analysts and control owners to translate security, risk and records-management requirements into robust schema, 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 Accountability:

• 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 schema 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 optimization) and drives continuous improvement through automation and standardization.

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, tempdb, concurrency) and ability to diagnose production issues under pressure.
• Testing mindset and automation: tSQLt (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.
• CI/CD 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 Analysts, 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.