← Back to the network

The work between the stops

Contribution archive.

Engineering, teaching and the things on the side. Grouped into initiatives, with a story behind each one.

6 contributions

Reset filters

Years refer to the project or role period. These summaries draw on my CV and published recipes; private PRs and client data are not reproduced.

Kraken Technologies

2025–present

Performance

Lazy pagination at scale

Replaced full-table counts and added filter indexes, eliminating timeouts on a view spanning approximately 26 million records.

Kraken Technologies

2025–present

Performance

Recovering production storage

Safely removed 11 redundant PostgreSQL indexes across two estates, reclaiming approximately 1.43 TB.

Kraken Technologies

2025–present

Data integrity

Validate before submission

Blocked approximately 483,000 invalid updates per month across two enterprise clients.

Kraken Technologies

2025–present

Data integrity

Repairing migration data

Corrected overlapping meter dates, preserved required fields and built bulk repair tooling with dry-run support.

Kraken Technologies

2025–present

Reliability

Missing-timestamp handling

Fixed a validation defect responsible for 3.7 million application errors, adding regression tests and diagnostic logging.

Kraken Technologies

2025–present

Authentication

Multi-tenant authentication

Implemented and tested SSO for two organisations using OIDC, Okta and django-allauth with email-domain routing.