Case studies

Work

Architecture deep-dives — the problem, the constraints, the decisions I made, and what I traded away to get there.

01

ETL Optimization → Data Platform

A PostgreSQL car-listings ETL took 16 hours to backfill one large brand against a 4-hour SLA. The real problem wasn't the engine — it was running an OLAP workload on an OLTP store. A primer on the option landscape and a two-horizon path from quick win to platform.

PostgreSQLClickHouseApache IcebergdbtDuckDB
Read case study02

Real-Time Pipeline for Wearable Health Data

Mirror a multi-tenant MySQL source into a queryable analytical store in under 5 minutes — built lean for a startup (~$200/mo) but designed to scale from 150M to 1B+ rows. CDC architecture, data modeling, failure handling, and the trade-offs.

DebeziumApache KafkaClickHouseS3 / R2Prometheus
Read case study