At a Glance
- Tasks: Design and implement innovative database systems while collaborating in a dynamic Agile team.
- Company: Join a vibrant organisation committed to diversity and inclusion.
- Benefits: Enjoy flexible working, 25 days leave, and a competitive pension scheme.
- Other info: Opportunities for learning and development in a hybrid work setting.
- Why this job: Make a real impact by enhancing data solutions in a supportive environment.
- Qualifications: Experience with SQL Server and a passion for database design and optimisation.
The predicted salary is between 55000 - 65000 £ per year.
TPR grade & pay group: Grade 8 & Digital
Directorate: Digital, Data & Technology
Contract type: Permanent
Location: Brighton: Hybrid (6 days per month in the office)
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.
Qualifications / Criteria
- 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.
The Team
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.
Benefits
- 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.
Diversity and Inclusion
Equality, diversity and inclusion is very important to us and we strive to make sure everyone has an equal opportunity to succeed.
Database Administrator, Designer & Engineer in Brighton employer: The Pensions Regulator
As a Policy Delivery Lead at TPR, you will join a vibrant and inclusive workplace in Brighton, where collaboration and personal growth are at the forefront of our culture. We offer genuine opportunities for learning and development, alongside a competitive benefits package that includes flexible working arrangements and a strong commitment to diversity and inclusion. With a focus on making a positive impact for savers, this role provides a unique chance to influence policy in a supportive environment that values your contributions.
StudySmarter Expert Advice🤫
We think this is how you could land Database Administrator, Designer & Engineer in Brighton
✨Tap into Local Tech Meetups
Get yourself to local tech meetups or database management conferences. It's a really great way to meet industry professionals and potentially uncover unadvertised full-time roles. When chatting with people, mention your skills and interests in database management; you never know who might be looking for someone just like you!
✨Contribute to Open Source Projects
Diving into open-source projects can not only sharpen your database skills but also get you noticed by employers. Many companies look for candidates who actively contribute to projects – it shows initiative and a real passion for the field. Plus, it's a perfect excuse to connect with other developers and expand your professional network.
✨Utilise Professional Bodies
Sign up for professional bodies related to database management, like the British Computer Society. They often host events and networking opportunities that can lead directly to job openings in the full-time market. Plus, it adds a nice touch to your professional profile!
✨Showcase Your Skills in a Public Portfolio
As you’re on the hunt for that full-time role, make sure to have a public portfolio that displays your best database projects. This can easily set you apart from the competition. And when you apply for roles, definitely mention it – it shows employers you mean business and are proud of your work!
We think you need these skills to ace Database Administrator, Designer & Engineer in Brighton
Some tips for your application 🫡
Show off your database skills:When applying for a full-time role in database management, it’s super important to highlight your skills with specific database technologies like SQL, NoSQL, or any relevant data visualisation tools. We want to see how you've used these tools in real projects, so don't shy away from detailing your hands-on experience!
Tailor your CV for data:Make sure your CV is structured clearly, focusing on your previous experience in database management. Use specific metrics to demonstrate your impact, like how you improved data retrieval times or reduced errors. This isn't just about what you've done; it’s about what you’ve achieved with your skills!
Craft a compelling cover letter:In your cover letter, share what excites you about database management and how you can contribute to The Pensions Regulator. Mention any relevant projects where you tackled challenges or implemented new solutions. Let us know why you want to join our team and how your passion aligns with our goals.
Document your projects:If you've worked on interesting database projects—maybe during your studies or in previous roles—be sure to include those in your application. If you can, link to a portfolio or GitHub repo where we can see examples of your work. Having a tangible showcase of your skills will really make your application stand out!
How to prepare for a job interview at The Pensions Regulator
✨Brush Up on Database Tools
Make sure you're well-versed with popular database management systems like MySQL, PostgreSQL, or MongoDB. Incorporating real-world examples of how you've used these tools in past projects will show that you can put theory into practice, which is something The Pensions Regulator will definitely appreciate.
✨Know Your SQL Inside Out
Get ready for some technical questions focused on SQL queries and database design. We should anticipate coding challenges where you might need to optimise queries or design a database schema on the spot. Practising these problems will build our confidence to impress in the interview.
✨Demonstrate Problem-Solving Skills
Besides just technical know-how, be prepared to answer scenario-based questions that test your critical thinking and problem-solving abilities. Think about how you would approach data integrity issues or handle performance bottlenecks — The Pensions Regulator will want to see your analytical side!
✨Show Your Collaboration Spirit
Since this is a full-time role, it's crucial to highlight how you've collaborated with cross-functional teams or contributed to team projects in the past. Emphasising our interpersonal skills will demonstrate that you’re not just a tech wizard, but also a team player who fits well with The Pensions Regulator's culture.
