Trust In SODA
SQL Server lead
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
SQL Server Lead – Contract
Location: Glasgow | Hybrid – 2–3 days onsite
Rate: Up to £410/day Inside IR35
Contract until: 31 December 2026 (renewable)
We’re looking for an experienced SQL Server Lead to join a major financial services environment, supporting the design, development and optimisation of data warehouse and data distribution platforms across security, risk, controls and records management.
Key Responsibilities
- 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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Essential Skills
- 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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London