Ali Raza
Full Stack Developer · TypeScript, Node.js & PostgreSQL
Profile
Full stack developer with six years in small product teams, strongest on the back end: Node.js, TypeScript and PostgreSQL, with enough React to own a feature through to the browser. Recent work includes a payments integration processing around £2m a month and a query-tuning programme that cut dashboard load times by 90%.
Professional Experience
- Own the shipment tracking service end to end: PostgreSQL schema, Fastify API, React dashboard and the on-call rotation that covers it.
- Built the carrier payments integration handling roughly £2m a month, including idempotency keys, a reconciliation job and an audit trail the finance team uses directly.
- Traced a 9-second operations dashboard to a missing composite index and a per-row subquery; the rewrite as a lateral join brought it to 240ms and removed the nightly caching workaround.
- Moved releases from manual deploys to GitHub Actions with blue/green on ECS, cutting release time from around 40 minutes to under 6.
- Wrote the decision record for moving off a shared database to service-owned schemas, and led the four-month migration with no customer-visible downtime.
- Built three client products from empty repository to production, covering authentication, billing, admin tooling and the customer-facing app.
- Introduced Prisma and a migration review step after a manual schema change caused two hours of downtime; no repeat incident in the following two years.
- Added Sentry and structured logging across the estate, which turned "the site is broken" reports into traceable errors and cut mean time to diagnosis noticeably.
- Interviewed and onboarded four developers, and wrote the onboarding guide that got new starters to their first merged pull request within a week.
Selected Projects
- A command-line tool that reviews PostgreSQL migration files for locking operations that would block writes on a large table.
- Flags the six patterns responsible for most accidental table locks and suggests the concurrent equivalent.
- Used internally across three teams before being released publicly.
Education
- Final-year project: a distributed job queue with at-least-once delivery guarantees.