Kraken Technologies
2026
Operational tooling
Operational jobs platform
Built a permissioned web interface for launching Kubernetes Jobs, tracking execution and inspecting captured output.
More of the work
Contribution archive.
Specific changes, projects and teaching work. Each entry links to a case study or role summary with more context.
13 contributions
Reset filtersEntries group related changes. Year filters use the case-study or project period; each story explains the scope of its results.
Kraken Technologies
2026
Reliability
Concurrent execution and recovery
Used ordered row locks to prevent equivalent jobs running concurrently, with reconciliation against Kubernetes state.
Kraken Technologies
2026
Performance
Batching settlement queries
Replaced per-meter queries with batches of 1,000: 200,001 queries become 201 in the query model for 100,000 meter points.
Kraken Technologies
2026
Performance
Bounded message queries
Limited ordered inputs before combining message results; recorded SQL execution fell from about 63 seconds to 16.5 ms in the query benchmark.
Kraken Technologies
2026
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
2026
Performance
Recovering production storage
Safely removed 11 redundant PostgreSQL indexes across two estates, reclaiming approximately 1.43 TB.
Kraken Technologies
2025–2026
Data integrity
Validate before submission
Blocked approximately 483,000 invalid updates per month across two enterprise clients.
Kraken Technologies
2025–2026
Data integrity
Repairing migration data
Corrected overlapping meter dates, preserved required fields and built bulk repair tooling with dry-run support.
Kraken Technologies
2025–2026
Reliability
Missing-timestamp handling
Fixed a validation defect responsible for 3.7 million application errors, adding regression tests and diagnostic logging.
Kraken Technologies
2026
Authentication
Multi-tenant authentication
Implemented and tested SSO for two organisations using OIDC, Okta and django-allauth with email-domain routing, plus signed access to a related service.
Kraken Technologies
2026
Database migrations
Staged schema migrations
Introduced a new settlement uniqueness constraint, updated application lookups, then removed the old constraint to accommodate rolling deployments.
Kraken Technologies
2026
Performance
Reusing connections at scale
Reused an S3 client instead of creating one per message in a consumer handling a reported 247 million notifications monthly.
Kraken Technologies
2025–2026
Data integrity
Keeping historical meter data separate
Fixed a handler that mixed historical and current meter details so it selected the latest complete set for the meter.