PostgreSQL DBA

You’ll take ownership of the application database environment across multiple cloud and on-premise environments, working closely with developers, data pipeline engineers, data scientists and infrastructure teams., * Managing PostgreSQL database clusters across multiple environments

• Monitoring, tuning and optimising PostgreSQL database performance
• Hands-on administration and maintenance of Oracle 19c or 21c
• Managing data migrations between database instances, including offline environments
• Owning data models and the lifecycle of data within the database
• Designing, creating and managing schemas, tables and views
• Performance optimisation including index tuning, execution plan analysis, query optimisation and partitioning
• Managing database clusters and failover strategies
• Defining and implementing backup and recovery strategies
• Managing database security, roles, permissions and RLS controls
• Working with infrastructure teams on database installation and patching
• Working with data pipeline engineers and data scientists to ingest a wide range of data sources
• Applying best practices for storing JSON objects within PostgreSQL

You will need strong hands-on experience across both technologies, with the ability to confidently talk through your experience during a technical interview., * Strong hands-on DBA experience across PostgreSQL and Oracle

• Recent and meaningful PostgreSQL DBA experience - this must go beyond basic exposure, installation or support-level knowledge
• Strong hands-on experience with Oracle 19c or 21c
• Experience with PostgreSQL performance optimisation, including index tuning, execution plan analysis, query optimisation, sharding and partitioning
• Experience managing database clusters and failover
• Strong data modelling experience
• Experience working closely with development and infrastructure teams
• Experience with PostgreSQL extensions such as pgvector, PostGIS or AGE would be beneficial
• Additional MSSQL experience would be useful
• Single British Nationality
• SC clearance as a minimum, with DV targeted
• Ability to meet the required UK residency criteria for security clearance

Please ensure your CV clearly outlines your hands-on responsibilities and experience with Oracle 19c/21c and PostgreSQL, as candidates will need to demonstrate their experience across both technologies during the technical interview.