PostgreSQL Database Administrator

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

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.

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

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