SQL Server Lead

• 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.

• 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