Dhirender Choudhary
Full-stack engineer. TypeScript, Postgres, and the boring parts done properly
Indiadhirender@example.com+91 98000 00000example.com
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
Senior Full-Stack Engineer
2022-03 to PresentKavach Systems
- 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.
Full-Stack Engineer
2020-01 to 2022-02Pallas Health
- 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.
Software Engineer
2018-06 to 2019-12Tellus Labs
- 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.
Teaching Assistant, Databases
2017-09 to 2018-05Jaypee Institute of Information Technology
- 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
2014-08 to 2018-06B.Tech, Computer Science and Engineering
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.