Hybrid PostgreSQL DBA - Data Modeling

Atos; City of Edinburgh; Hybrid; GBP 60,000 - 95,000; Full time

Benefits offered by this job

Pension Scheme - contributions matched

Private medical cover

Income Protection

Life Assurance

25 days paid leave + National Holidays

Flex benefits program

Job summary

Atos is seeking a PostgreSQL database administrator to manage a Postgres data store across cloud and on-premises environments. You will own core data structures, ensure performance, and work with data scientists and pipeline engineers to ingest diverse data sources.

The role supports a hybrid work model with two days per week in the Edinburgh-area office, offering pension, private medical cover and other benefits.

Qualifications

• Proven PostgreSQL DBA experience with core development and maintenance.
• Experience monitoring and tuning PostgreSQL for performance.
• Ability to design flexible data models and schemas for complex feeds.
• Experience with security controls, roles, permissions, and RLS.
• Experience with backup strategies and disaster recovery.
• Familiarity with clustering and failover strategies.
• Experience collaborating with data engineers and data scientists.

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

PostgreSQL

Performance tuning

Data modelling

Security & RLS

Backup & Recovery

Clustering

Cross-team collaboration

JSON in PostgreSQL

Oracle

MS SQL Server

Tools

Oracle

MS SQL Server

Job description

Atos is seeking a PostgreSQL database administrator to manage a Postgres data store across cloud and on-premises environments. You will own core data structures, ensure performance, and work with data scientists and pipeline engineers to ingest diverse data sources.

The role supports a hybrid work model with two days per week in the Edinburgh-area office, offering pension, private medical cover and other benefits.