Engineer — Databases and data pipelines that hold up

We design, tune and migrate the databases a business runs on, and we build the pipelines that move data between them. Everything below is work that was delivered: the situation it started from, what was done, and what changed as a result.

Data & Databases

Somewhere sensible to keep your data

Database Design & Modeling

A structure that matches how the business actually works, so the questions you need answered later are still possible to ask.

Built a database‑driven CV, references, portfolio and cover‑letter generator in Python — 41 modules, 10,580 lines — rendering six output formats from one 23‑table SQLite source assembled by a 19‑step idempotent pipeline.
Built the hiring marketplace and the seafarer career workspace — 151 stored functions across 48 tables — covering vacancies, applications, certificates, rank progression and verified sea time.
Built the loyalty and reputation system — 67 functions over a 31‑table ledger, with leagues, badges and a redemption shop — taking a row lock on the balance to close the double‑spend window.

See all 14 achievements →

Data & Databases

Looking after the database

Database Administration (DBA)

Somebody responsible for the thing the whole company rests on: it is up, it is backed up, and it is not quietly rotting.

See all 9 achievements →

Data & Databases

Making the slow parts fast

Database Performance Tuning

Finding the queries and the missing indexes behind a system that has got heavier every year, and fixing the ones that matter.

See all 6 achievements →

Data & Databases

Getting off the old system

Database Migration & Modernization

Data taken out of something ageing and into something supported, with the business still running while it happens.

Data & Databases

Getting your data from A to B on its own

Data Pipeline Development (ETL/ELT)

Numbers arriving where they are needed, on a schedule, without anyone copying a spreadsheet at the end of the month.

See all 15 achievements →

Data & Databases

One place where all the numbers agree

Data Warehouse Design

Sales, operations and finance figures brought together, so two departments stop bringing two answers to the same meeting.

Data & Databases

Seeing what is going on

Data Analytics & BI Dashboards

Dashboards and reports showing the handful of figures a decision actually turns on, refreshed without being asked.

See all 11 achievements →

Data & Databases

Trusting the numbers

Data Governance & Quality

Rules and checks that catch bad data on the way in, and a clear answer to who owns which figure and where it came from.

See all 15 achievements →