Portfolio
Dhirender Choudhary
Full-stack engineer. TypeScript, Postgres, and the boring parts done properly
Indiadhirender@example.com+91 98000 00000example.com
Overview
I build products end to end: schema first, then the server, then the screens. Most of my work is in TypeScript and Postgres, and most of what I care about is the part users never see. The constraint that makes a bad state unrepresentable, the index that keeps a page fast at 10,000 rows, the check that runs twice because once is a hope.
Experience
2022-03 to Present
Kavach Systems
Senior Full-Stack Engineer
- Rewrote the billing state machine as a set of database constraints instead of application checks, which ended a class of double-charge bugs that had been reopened four times.
- Cut p95 dashboard load from 3.8s to 340ms by replacing six client round-trips with one indexed query.
- Introduced typed end-to-end contracts between the API and the web app; the first quarter caught 11 breaking changes before they shipped.
- Mentored two engineers through their first on-call rotations and wrote the runbook they onboard with.
2020-01 to 2022-02
Pallas Health
Full-Stack Engineer
- Owned the appointment-booking product end to end. Schema, API and interface. Through 6× growth in bookings without a rewrite.
- Reduced the nightly batch window from 5 hours to 40 minutes by replacing row-by-row processing with set-based SQL.
- Rebuilt the patient search on Postgres full-text instead of a second search service, deleting an entire piece of infrastructure.
2018-06 to 2019-12
Tellus Labs
Software Engineer
- Built the ingestion pipeline for imagery metadata. 200GB/day, idempotent, restartable.
- Replaced a hand-rolled job scheduler with Postgres advisory locks, deleting 1,400 lines of code.
2017-09 to 2018-05
Jaypee Institute of Information Technology
Teaching Assistant, Databases
- Ran lab sessions on relational design and query planning for two cohorts of undergraduates.
Projects
pgdrift
A CLI that diffs a running Postgres database against your migration history and tells you which change nobody committed. Used in production by a handful of teams that found it before I told anyone about it.
Go / PostgreSQL
FromYourCV
This product. Upload a resume PDF, get a live portfolio site at your own address in about a minute. Thirty-four templates over nine distinct layouts, with the parsing, the editor and the renderer all sharing one schema.
Next.js / TypeScript / Supabase / PostgreSQL
Slowquery
A small web app that takes a Postgres EXPLAIN plan and renders it as a flame graph. Built in a weekend because I got tired of reading nested text.
React / D3
Skills
- TypeScript
- React
- Next.js
- Node.js
- PostgreSQL
- Supabase
- SQL performance tuning
- Schema design
- REST and RPC APIs
- Redis
- Docker
- CI/CD
- Playwright
- Tailwind CSS
Education
- Jaypee Institute of Information Technology, B.Tech, Computer Science and Engineering2014-08 to 2018-06
Achievements
- Shipped FromYourCV end to end. Schema, parser, editor, renderer and billing. As a single-maintainer product.
- Maintainer of two small open-source tools with about 3,000 combined downloads a month.
- Wrote the internal guide to on-call that three teams at Kavach now onboard with.
How I work
I read the code before I read the ticket. I write the migration down before I write the feature. I would rather ship something boring on Tuesday than something clever in three weeks, and I will always argue for deleting code over adding a flag.