Scrumconnect Limited
PostgreSQL Forensic Specialist
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
About Scrumconnect Consulting
Scrumconnect Consulting is a multi-award-winning digital consultancy, recognised for delivering impactful and innovative technology solutions across UK government departments. Our work has positively influenced the lives of over 40 million UK citizens.
We are passionate about user-centred design, agile delivery, and building digital services that make a real difference. Our teams work at the forefront of innovation, helping organisations transform and deliver high-quality, scalable solutions that truly matter.
Role: PostgreSQL Forensic Specialist
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.
Responsibilities
The specialist will be responsible for establishing whether sufficient evidence and technical access exist to conduct a defensible investigation into the reported anomalies.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
The specialist should assess and document:
- Historical concurrency anomalies (e.g., 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
Skills
PostgreSQL Internals Expertise Required specifically:
- MVCC (Multi-Version Concurrency Control)
- Transaction semantics and Locking behaviour
- Advanced 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
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills