PostgreSQL Database Administrator
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+4 more
Job description
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., * 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
Requirements
Do you have experience in PostgreSQL?, * 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 days per week in the office, supporting productivity, collaboration, and employee well-being.
Benefits & conditions
Pulled from the full job description
- Annual leave
- Company pension, Pension Scheme - contributions matched up to 10%
Private medical cover
Income Protection
Life Assurance
25 days paid leave + National Holidays
Flex benefits program
About the company
Atos Group is a global leader in digital transformation with c. 63,000 employees and annual revenue of c. €8 billion, operating in 61 countries under two brands - Atos for services and Eviden for products. European number one in cybersecurity, cloud and high performance computing, Atos Group is committed to a secure and decarbonized future and provides tailored AI-powered, end-to-end solutions for all industries. Atos Group is the brand under which Atos SE (Societas Europaea) operates. Atos SE is listed on Euronext Paris.
The purpose of Atos Group is to help design the future of the information space. Its expertise and services support the development of knowledge, education and research in a multicultural approach and contribute to the development of scientific and technological excellence. Across the world, the Group enables its customers and employees, and members of societies at large to live, work and develop sustainably, in a safe and secure information space., Here at Atos, diversity and inclusion are embedded in our DNA. Read more about our commitment to a fair work environment for all. As a Disability Confident employer, 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 and willing to making reasonable adjustments to the application and assessment process to accommodate your needs.
Here at Atos, diversity and inclusion are embedded in our DNA. Read more about our commitment to a fair work environment for all.
Atos is a recognized leader in its industry across Environment, Social and Governance (ESG) criteria. Find out more on our CSR commitment.
Choose your future. Choose Atos.
You must create an Indeed account before continuing to the company website to apply
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on indeed.comGood distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
Data Engineer Salary UK
Best Companies to work for in London: Top 25 Companies in 2023
Fullstack Developer Salary UK
Software Engineer Salary in The UK