Database Architect & SQL Engineer (Hybrid)

The Pensions Regulator; Brighton; Hybrid; GBP 51,000 - 62,000; Full time

Benefits offered by this job

Hybrid working

Civil Service Pension

25 days annual leave

Employee networks

Job summary

The Pensions Regulator ( Brighton ) is seeking a Database Administrator, Designer & Engineer to design, implement and maintain SQL database systems within a hybrid Brighton office model. You will lead performance tuning, data integration, and security across production and test environments.

Key responsibilities include triaging incidents, mentoring team members, and collaborating in an Agile setting to deliver robust data solutions and scalable architectures using SQL Server, Azure, SSIS and

Qualifications

• Broad practical experience of the database development lifecycle.
• Strong hands-on experience with SQL Server 2017 and above.
• Deep knowledge of T-SQL, relational databases, and SQL Server performance tuning.
• Strong understanding of database design, data modelling, normalisation, denormalisation, indexing, partitioning, query optimisation, and concurrency design.
• Experience of administering, monitoring, and supporting SQL Server environments in production and test.
• Good understanding of Microsoft Azure concepts and Azure-based database solutions.
• Experience with ETL and data integration tools and techniques, including SSIS and/or Azure Data Factory.
• Experience investigating and diagnosing technical problems in complex business systems.
• Good understanding of data security principles, including access control and encryption.
• Good understanding of data quality, cleansing, and testing principles.
• Experience working with Agile methods to plan, develop, test, and deliver data solutions.
• Knowledge of capacity planning and data archiving principles.

Responsibilities

• Design, estimate, implement, plan, and test new database systems as defined by the project portfolio.
• Provide administration, monitoring, backup, recovery, and performance tuning of operational and test database systems.
• Support production systems by triaging incidents, investigating issues, and implementing fixes.
• Maintain a high standard of data solutions through code reviews, knowledge sharing, mentoring, documentation, and process improvement.
• Engage with business users to gather information about defects and change requirements.
• Work with technical colleagues to diagnose problems, design solutions, and evaluate technology choices.
• Collaborate in a multi-skilled Agile team to estimate, plan, deliver, and test prioritised features.
• Design robust database structures and data integration solutions that meet storage, performance, security, and data integrity requirements.
• Support technical standards and best practice across SQL development and database operations.

Skills

SQL development lifecycle

SQL Server performance tuning

T-SQL

Data modelling

Agile methodologies

Tools

SQL Server 2017+

Azure

SSIS

Azure Data Factory

Azure SQL Database

Synapse

Job description

The Pensions Regulator ( Brighton ) is seeking a Database Administrator, Designer & Engineer to design, implement and maintain SQL database systems within a hybrid Brighton office model. You will lead performance tuning, data integration, and security across production and test environments.

Key responsibilities include triaging incidents, mentoring team members, and collaborating in an Agile setting to deliver robust data solutions and scalable architectures using SQL Server, Azure, SSIS and