PostgreSQL Specialist (SC Cleared)

The Role We''re looking for a senior PostgreSQL Specialist to investigate, reconstruct and explain what has happened inside business-critical databases on a UK public sector programme. You will work with security, delivery and engineering teams to find the root cause of data incidents, preserve evidence, and make recommendations that stop them recurring. At SFIA Level 5 you''ll work independently, advise at senior level, and set the standard for how the programme logs, audits and recovers its data. Key Responsibilities Investigate data incidents, such as unexpected changes, deletions, corruption, performance failures and suspected misuse, and establish the root cause. Reconstruct events using transaction logs, WAL archives, point-in-time recovery (PITR), audit logs and replication streams. Preserve and document evidence in a way that can be relied on in security and compliance reviews. Check data integrity and spot tampering or unauthorised access. Advise on audit and logging design (for example pgaudit and database activity monitoring) so future incidents can be traced. Support live incident response, including performance tuning and fault finding on production databases. Review backup, disaster recovery, replication and archiving arrangements. Support database migrations and upgrades, including near-zero-downtime approaches. Write clear investigation reports and recommendations for technical and non-technical audiences. Advise developers and architects ..... full job details .....