At a Glance
- Tasks: Lead technical assessments on database anomalies and conduct in-depth investigations.
- Company: Award-winning digital consultancy transforming UK government services.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Other info: Join a dynamic team at the forefront of digital innovation.
- Why this job: Make a real impact by solving complex database challenges that affect millions.
- Qualifications: Deep PostgreSQL expertise and experience with transaction data analysis.
The predicted salary is between 57692 - 70512 £ per year.
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.
We are looking for a Postgre SQL 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 Postgre SQL 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 Postgre SQL 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: Postgre SQL Internals Expertise Required specifically: 1.
MVCC (Multi-Version Concurrency Control) 2.
Transaction semantics and Locking behaviour 3.
Advance knowledge of Postgre SQL Write-...
PostgreSQL Forensic Specialist (SC Cleared) in London employer: scrumconnect ltd
At Scrumconnect Consulting, we pride ourselves on being an exceptional employer, offering a dynamic work culture that fosters innovation and collaboration. Our commitment to employee growth is evident through continuous learning opportunities and the chance to work on impactful projects that benefit millions of UK citizens. Located at the heart of the digital transformation landscape, we provide our team with the resources and support needed to excel in their roles while making a meaningful difference in society.
