Postgre SQL DBA

Overview

We are looking for a Postgre

SQL 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 Postgre
  
  SQL database cluster across multiple environments across cloud and on premises
• Monitoring and tuning to optimise Postgre
  
  SQL 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 and data scientists to ingest a wide range of data sources
• Managing security controls across environments, including defining roles and 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

• Postgre
  
  SQL DBA with core development, maintenance and performance optimisation experience (including sharding, partitions). Experience with clustering, and extensions such as pgvector, PostGIS, and AGE is very useful
• Experience with Oracle or MSSQL would also be required
• Strong Postgre
  
  SQL database management skills: performance optimisation (index tuning, execution plan analysis, query optimisation, data partitioning); backup and recovery with strategies based on environment constraints; clustering with failover strategies
• Experience with data modelling: designing, creating and managing schemas, tables, and views to support the data models
• Understanding best practices for storing JSON objects within PostgreSQL
• Clear communication and ability to work collaboratively with developers to define and implement data model requirements