Database Administrator, Designer & Engineer

TPR grade & pay group: Grade 8 & Digital

Directorate: Digital, Data & Technology

Contract type: Permanent

Location: Brighton:
Hybrid (6 days per month in the office)

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

• Broad practical experience of the database development lifecycle, gained through building business database solutions.
• 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, denormalization, 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.
• Experience with Azure SQL Database, SQL Managed Instance, Synapse, or related Azure data services.
• Experience supporting high‑availability or performance‑sensitive SQL environments.
• Experience working in regulated or high‑governance environments.

We provide SQL Database SME consultancy, database support and backup, best practices, and expert development support for Service teams and the wider TPR audience. We are responsible for supporting and improving the existing SQL database estate for TPR, as well as providing expert advice and development resource for key TPR processes. We enable the Service Teams to develop and deploy more quickly to an agreed standard of database coding practices and translate logical model designs into physical databases.

• Genuine opportunities for learning and development.
• Hybrid working and flexible shift patterns.
• A vibrant workplace with employee networks (Disability, Family, LGBT+, Minority Ethnic, Mental Health, Women's).
• 25 days annual leave plus bank holidays.
• 35 hour working week (full‑time), flexible working patterns, and flexitime.
• Competitive parental leave.
• Civil Service Pension with an average employer contribution of 28.97%.
• Dedicated benefits portal (Edenred) offering retail, gym, tech and restaurant discounts, and a cycle to work scheme.

Equality, diversity and inclusion is very important to us and we strive to make sure everyone has an equal opportunity to succeed.