Detail 01 · scale 1:1012024
pgtrace
A terminal tool that watches Postgres for slow queries and suggests the index that would fix them. 4.1k stars; used in production at a few hundred companies.
- A — Go
- B — PostgreSQL
Sheet A-001 — General arrangement
Ines Okafor
Staff Software Engineer
I make slow systems fast and confusing ones obvious, mostly in Postgres, Go and TypeScript.
- Project
- Staff Software Engineer
- Location
- Lisbon, Portugal
- Status
- Open to staff and principal roles from January
- Drawn
- Ines Okafor
SheetA-001
01 · General notes
- 1.I’ve spent eleven years on the unglamorous middle of software: the queue that backs up at 9am, the query that worked fine until the table hit forty million rows, the deploy nobody wants to run on Fridays.
- 2.Lately I lead platform work at a payments company, write about database internals, and maintain pgtrace, a small tool that has saved a surprising number of on-call weekends.
02 · Details
Detail 01 · scale 1:1
Detail 02 · scale 1:1022023 · Northwind Pay
Ledgerline
Rebuilt the cash-position service behind a treasury dashboard. Reports that took 40 seconds now load in under one, on a third of the hardware.
- A — Go
- B — Kafka
- C — React
Detail 03 · scale 1:1032021 · City of Porto
Transit Live
Real-time arrivals for 380 bus stops, built with a team of four in ten weeks and still running on the original architecture.
- A — TypeScript
- B — Redis
- C — MapLibre
03 · Elevation — career
2014201520162017201820192020202120222023202420252026
Staff Software EngineerNorthwind Pay
Senior EngineerTalo
Software EngineerPorto Digital
2022 – Present
Northwind Pay
Lead the platform group: payments ledger, event streaming and the internal developer portal. Cut p95 settlement latency from 2.3s to 180ms.
2018 – 2022
Talo
Built the multi-tenant data layer and the on-call practice that took incidents from weekly to quarterly.
2014 – 2018
Porto Digital
Public-sector web services, from parking permits to the city’s open-data portal.
04 · Parts list
| Item | Part | Qty |
|---|---|---|
| 01 | Go | 1 |
| 02 | TypeScript | 1 |
| 03 | PostgreSQL | 1 |
| 04 | Kafka | 1 |
| 05 | Kubernetes | 1 |
| 06 | Terraform | 1 |
| 07 | React | 1 |
| 08 | Distributed systems | 1 |
| 09 | Observability | 1 |
| 10 | Incident response | 1 |
05 · Key dimensions
11
4.1k
−92%