> Markdown version of [/jobs/ext/2444363-postgresql-forensic-specialist](https://www.wearedevelopers.com/jobs/ext/2444363-postgresql-forensic-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# PostgreSQL Forensic Specialist

- **Company:** scrumconnect ltd
- **Location:** London, UK
- **Contract:** Permanent contract
- **Skills:** Cloud Database, Databases, Concurrency Controls, Data Structures, Hibernate (Java), Java Database Connectivity, PostgreSQL, SQLAlchemy, Transaction Data, Data Logging, Diagnostic Tools
- **Published:** August 14, 2026
- **Apply:** https://www.careerboard.com/pt/en/find-jobs-in-United-Kingdom/-C8BAA1578841047525/

## About the Role

PostgreSQL Internals Expertise Required specifically:

 * MVCC (Multi-Version Concurrency Control)
 * Transaction semantics and Locking behaviour
 * Advance knowledge of PostgreSQL Write-Ahead Logging.
 * Expert or advanced experience with physical/logical PostgreSQL data structures.
 * highly proficient with PostgreSQL Toolkit and 3rd party diagnostic tools

The specialist must be experienced in:

 * correlating evidence across multiple systems/schemas/logs
 * investigating concurrency issues with cloud database vendors

Experience with common database-access frameworks is desirable, including:
JDBC;
Hibernate;
SQLAlchemy;
equivalent PostgreSQL frameworks.

Diversity & Inclusion
At Scrumconnect Consulting, we believe that diversity drives innovation and better outcomes. We are committed to fostering an inclusive environment where every individual is valued, respected, and supported.

We welcome applications from candidates of all backgrounds and actively encourage individuals from under-represented groups, including women, people with disabilities, and diverse communities, as well as those seeking flexible working arrangements.

As a Disability Confident Level 1 employer, we are committed to providing reasonable adjustments throughout the recruitment process and during employment to ensure equal opportunities for all.

## Description

We are looking for a PostgreSQL Forensic Specialist to lead a technical assessment into reported database anomalies, determining whether sufficient evidence and technical access exist to support a defensible, in-depth investigation. This is a highly specialised role suited to someone with deep PostgreSQL internals expertise, who can work methodically through complex transactional data, reconstruct historical activity, and identify the key technical and evidential risk areas that warrant further examination.

The specialist will be responsible for establishing whether sufficient evidence and technical access exist to conduct a defensible investigation into the reported anomalies.

The specialist should assess and document:

 * historical concurrency anomalies (eg, lost updates, stale writes, partial transactions)
 * The scale, complexity, and forensic relevance of the underlying PostgreSQL data structures and transaction model.
 * The availability and completeness of historical artefacts, including database records, WAL, logs, backups, audit data, and other sources.
 * The feasibility of reconstructing historical transaction activity and establishing reliable timelines for the reported anomalies.
 * The principal technical and evidential risk areas that may require deeper forensic examination during a subsequent investigation.

Also, the specialist should be able to:

Reconstruct transaction timelines where feasible
Correlate anomalies with audit/metadata to determine business impact
Catalogue distinct issue types with verifiable examples


## Related Videos

- [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Discover the open source trio you didn’t expect: .NET and PostgreSQL on Linux](https://www.wearedevelopers.com/videos/2042-discover-the-open-source-trio-you-didn-t-expect-net-and-postgresql-on-linux)
- [Tracking vehicles at scale](https://www.wearedevelopers.com/videos/1999-tracking-vehicles-at-scale)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Maximising Cassandra's Potential: Tips on Schema, Queries, Parallel Access, and Reactive Programming](https://www.wearedevelopers.com/videos/1167-maximising-cassandra-s-potential-tips-on-schema-queries-parallel-access-and-reactive-programming)

## Related Articles

- [Dev Digest 168: Hacking Postgres, Blocking Meta and Fixing CSS](https://www.wearedevelopers.com/magazine/588-dev-digest-168-hacking-postgres-blocking-meta-and-fixing-css)
- [SQL Murder Mystery: A game for hobby detectives who want to learn SQL](https://www.wearedevelopers.com/magazine/38-sql-murder-mystery-a-game-for-hobby-detectives-who-want-to-learn-sql)
- [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers)
- [Where To Find Software Engineering Jobs](https://www.wearedevelopers.com/magazine/396-where-to-find-software-engineering-jobs)
- [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)