Postgre SQL DBA

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

• 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