At a Glance
- Tasks: Manage PostgreSQL databases, optimise performance, and collaborate with developers on data models.
- Company: Join a forward-thinking tech company that values flexibility and teamwork.
- Benefits: Enjoy a hybrid work model, competitive salary, and comprehensive health benefits.
- Other info: Flexible working with excellent career growth opportunities and a supportive team culture.
- Why this job: Make a real impact by optimising data management in a dynamic environment.
- Qualifications: Strong PostgreSQL skills and experience in data modelling and performance optimisation.
The predicted salary is between 50000 - 65000 £ per year.
We are looking for a PostgreSQL database administrator with strong data modeling skills to join our team. The role includes managing a Postgres application data store across environments, whilst working closely with the rest of the development team to define the data model for new data feeds. You will be responsible for the maintenance and performance of the database and have ownership of the core data structures used within the application.
Responsibilities:
- Taking responsibility for the application PostgreSQL database cluster across multiple environments across cloud & on premises
- Monitoring and tuning to optimise PostgreSQL database performance
- Handling migration of data structures across database instances, including to offline environments
- Owning the data models and managing the lifecycle of data sitting within the Postgres database
- Working closely with data pipeline engineers & data scientists to ingest a wide range of data sources
- Managing security controls across environments, including defining roles & permissions, as well as RLS controls for the data
- Working directly with the infrastructure team to configure the installation and manage patching of the databases across all environments
Skills we can’t do without:
- PostgreSQL DBA, core development / maintenance and performance optimisation (sharding, partitions)
- Experience with clustering, and extensions such as pgvector, PostGIS, and AGE very useful
- Additional skills in Oracle or MSSQL would also be required
- Strong PostgreSQL database management skills:
- Performance optimisation – index tuning, execution plan analysis, query optimisation, data partitioning
- Backup and recovery – Capable of defining backup strategies based on environment constraints
- Clustering – Experience with managing database clusters, including handling failover strategies
- Experience with data modelling: designing, creating & managing schemas, tables, and views to support the data models
- Understanding best practices for storing JSON objects within PostgreSQL
- Clear communication & ability to work collaboratively with developers to define & implement data model requirements
Essential Criteria – BPSS Eligibility SC cleared as a minimum, DV as a target, you must have lived and worked in the UK continuously for the past 5-7 years.
Location: Flexible Work Model – Hybrid working with a minimum of 2-3 days per month in the office, supporting productivity, collaboration, and employee well-being.
Benefits:
- Pension Scheme - contributions matched up to 10%
- Private medical cover
- Income Protection
- Life Assurance
- 25 days paid leave + National Holidays
- Flex benefits program
PostgreSQL DBA employer: Atos
Join a forward-thinking company that values flexibility and employee well-being, offering a hybrid work model that allows you to balance productivity with personal life. With a strong focus on team coaching and measurable impact, you'll have the opportunity to take ownership of your work while benefiting from a comprehensive pension scheme, private medical cover, and generous leave policies. This is an excellent environment for professional growth, where collaboration with talented colleagues drives innovation in database management.
StudySmarter Expert Advice🤫
We think this is how you could land PostgreSQL DBA
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even local tech events. You never know who might be looking for a PostgreSQL DBA just like you!
✨Show Off Your Skills
Don’t just talk about your experience; demonstrate it! Consider creating a portfolio showcasing your database projects or contributions to open-source PostgreSQL tools. This can really set you apart from the crowd.
✨Ace the Interview
Prepare for those tricky interview questions by brushing up on your PostgreSQL knowledge and problem-solving skills. Practice explaining your thought process clearly, as communication is key when working with development teams.
✨Apply Through Our Website
Make sure to apply directly through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace PostgreSQL DBA
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your PostgreSQL DBA skills and experience. We want to see how you've managed databases, optimised performance, and worked with data models. Tailoring your CV shows us you're serious about the role!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for our team. Share specific examples of your past work with PostgreSQL and how you’ve contributed to projects. We love a good story!
Show Off Your Technical Skills:In your application, don’t forget to mention your technical skills like performance optimisation, clustering, and data modelling. We’re looking for someone who can hit the ground running, so let us know what you bring to the table!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy – just a few clicks and you’re done!
How to prepare for a job interview at Atos
✨Know Your PostgreSQL Inside Out
Make sure you brush up on your PostgreSQL skills before the interview. Be ready to discuss performance optimisation techniques like index tuning and query optimisation, as well as your experience with clustering and extensions like pgvector or PostGIS. The more confident you are in your knowledge, the better you'll impress the interviewers.
✨Show Off Your Data Modelling Skills
Since this role heavily involves data modelling, prepare to talk about your experience designing and managing schemas, tables, and views. Bring examples of how you've worked collaboratively with developers to define data model requirements. This will demonstrate your ability to contribute effectively to the team.
✨Prepare for Scenario-Based Questions
Expect questions that require you to think on your feet. For instance, you might be asked how you would handle a database migration or optimise performance under specific constraints. Practising these scenarios can help you articulate your thought process clearly during the interview.
✨Emphasise Your Teamwork and Communication Skills
This role requires close collaboration with data pipeline engineers and the infrastructure team. Be ready to share examples of how you've successfully communicated and worked with others in past roles. Highlighting your teamwork skills will show that you're not just a tech whiz but also a great fit for their collaborative culture.
