Real estate
Real Estate Operations Platform
Modernizing a decades-old real estate platform: 50M+ records migrated from ASP1/MSSQL to NestJS, with page loads cut from 60s+ to under 1s.
- Amazon Web Services (AWS)
- React
- Nest JS
- Redis
Database & API Scale
Eliminate 60-second query timeouts, lock contention, and ORM N+1 traps across multi-million-row PostgreSQL databases and NestJS/Go backend services.
Context
Indexes that ignore equality-before-range ordering, sort direction, or soft-delete predicates force Postgres to scan millions of heap pages per request.
Unbounded Prisma/TypeORM includes, offset pagination on deep tables, and unbatched joins saturate connection pools under peak traffic.
`ILIKE '%term%'` and unindexed JSONB lookups grind dashboards to a halt without `pg_trgm` GIN or generated `tsvector` indexes.
Architecture
01
Design targeted composite B-Tree, partial, covering (`INCLUDE`), `pg_trgm`, and GIN indexes verified against real buffer hits and write amplification.
02
Replace deep `OFFSET` scans with cursor pagination, rewrite ORM bottlenecks in lean SQL where needed, and right-size pooling on AWS RDS or Neon.
03
Pair fast queries with idempotent background jobs, S3 streaming pipelines, and targeted Redis caching for predictable p95/p99 latency.
Try interactive PostgreSQL Index Advisor
Production proof
FAQ
Start with EXPLAIN (ANALYZE, BUFFERS) and pg_stat_statements to inspect actual row estimates, shared buffer reads, sort spills, and predicate selectivity. Then test composite/partial index candidates and query rewrites against production-scale data.
Yes. Use the free PostgreSQL Index Advisor at /tools/postgres-index-advisor on this site to generate exact CREATE INDEX CONCURRENTLY DDL for equality, range, sort, JSONB, full-text, and vector workloads.
AWS RDS and Aurora PostgreSQL, Neon serverless Postgres (including branching workflows), self-managed PostgreSQL in Docker, and extensions including pgvector, pg_trgm, and pg_stat_statements.
PostgreSQL performance
If a production query is blocking the product, I can walk through indexing, caching, and schema work from similar 50M-row systems. Email me with the constraint.
Open to full-time and part-time roles (remote or onsite)
Also on Toptal. Email is the best way to start a conversation.