SQL Developer | Azure Data & Performance Tuning

Castle Water; Blairgowrie and Rattray; Hybrid; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Company pension

Life insurance

Sick pay

Hybrid working

Job summary

Castle Water is seeking a SQL Developer to join our IT Data Services team. You will contribute to high-quality SQL Server development, database optimisation, automation, and data operations across the business, with opportunities to grow into Data Engineering practices and Azure data services.

You will work in a collaborative environment with a focus on continuous learning, technical excellence, and professional development, supporting enterprise data workflows and cross-team collaboration

Qualifications

• Must have strong T-SQL skills and a developer mindset.
• Degree or substantial relevant experience in Computer Science/IT/Engineering/Math.
• Experience in SQL Development, Data Analysis, BI or Data Engineering is advantageous.

Responsibilities

• Develop complex, high-performance T-SQL queries, stored procedures, and database logic.
• Manage SQL Server objects including tables, indexes, constraints, views, and functions.
• Optimize database performance through indexing, query tuning, and maintenance.
• Support schema design, normalization, and relational modelling best practices.
• Assist application teams with SQL guidance and integration considerations.
• Ensure secure access to production and non-production environments and monitor data operations.

Skills

T-SQL

SQL Server

Python basics

Data analysis

Relational databases

Azure data services

Education

Degree in Computer Science / IT / Engineering / Mathematics

Tools

Azure

SQL Server Management Studio

ETL/ELT tooling

Job description

Castle Water is seeking a SQL Developer to join our IT Data Services team. You will contribute to high-quality SQL Server development, database optimisation, automation, and data operations across the business, with opportunities to grow into Data Engineering practices and Azure data services.

You will work in a collaborative environment with a focus on continuous learning, technical excellence, and professional development, supporting enterprise data workflows and cross-team collaboration