At a Glance
- Tasks: Manage PostgreSQL databases and optimise performance while collaborating with a dynamic development team.
- Company: Atos Group, a global leader in digital transformation and cybersecurity.
- Benefits: Competitive salary, pension scheme, private medical cover, and flexible work options.
- Other info: Embrace diversity and inclusion in a supportive work environment.
- Why this job: Join a purpose-driven company and make an impact in the tech world.
- Qualifications: Experience in PostgreSQL management, data modelling, and performance optimisation.
Atos Group is a global leader in digital transformation with approximately 63,000 employees and annual revenue of around €8 billion, operating in 61 countries. 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 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.
- 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).
- 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
Mostly remote with 1-2 days per week on client site where there is an S terminal. Locations nationally (typically Andover, Corsham, London but opportunities for Edinburgh, Catterick and Manchester areas).
Benefits
- Pension Scheme - contributions matched up to 10%.
- Private medical cover.
- Income Protection.
- Life Assurance.
- 25 days paid leave + National Holidays.
- Flex benefits program.
Diversity, Equity & Inclusion
Here at Atos, diversity and inclusion are embedded in our DNA. We encourage applications from all applicants, especially differently abled applicants. We aim to ensure that those who meet the minimum criteria for this position will be offered an interview. We are committed to making reasonable adjustments to the application and assessment process to accommodate your needs.
Postgresql DBA in Manchester employer: 慨正橡扯
At Third Bridge, we are not just offering a job; we are providing a career launchpad in a vibrant and fast-paced environment. With a strong focus on employee growth, our Client Services Associate role allows you to develop essential skills while working with top-tier clients, all within a supportive culture that values work-life balance and personal development. Join us to accelerate your career and enjoy comprehensive benefits, including generous vacation days and the flexibility to work from anywhere for a month each year.
StudySmarter Expert Advice🤫
We think this is how you could land Postgresql DBA in Manchester
✨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 Postgresql DBA in Manchester
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 慨正橡扯. 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 慨正橡扯
✨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 慨正橡扯 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 — 慨正橡扯 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 慨正橡扯's culture.
