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
Legacy Modernization
End-to-end technical ownership for migrating decades-old ASP, .NET, and SQL Server monoliths onto typed NestJS, PostgreSQL, Next.js, and AWS architectures without halting daily operations.
Context
Classic ASP, stored procedures, and tightly coupled SQL Server tables make naive rewrites fail. Every implicit invariant has to be mapped before moving traffic.
At 50M+ rows, schema drift, slow ETL windows, and unindexed joins stall releases unless data validation and incremental sync run ahead of cutover.
Legacy reporting screens and unindexed search endpoints degrade to 60-second timeouts as table cardinality grows.
Architecture
01
Normalize brittle MSSQL schemas into clean PostgreSQL models with idempotent backfill pipelines, row-count/checksum verification, and rollback safety.
02
Carve out domain modules behind NestJS + TypeScript services and Next.js interfaces so teams ship value slice by slice instead of betting on a risky big-bang release.
03
Pair composite B-Tree, GIN, and full-text indexes with AWS compute/RDS observability so cutover day brings an immediate 10x–100x latency drop.
Try interactive PostgreSQL Index Advisor
Production proof
FAQ
By separating historical bulk backfills from incremental delta sync, validating row counts and financial/operational invariants before cutover, and rehearsing the switchover on production-sized snapshots so rollback remains deterministic.
Phased strangler delivery wherever possible. Isolating high-pain workflows, such as a 60-second search or reporting bottleneck, delivers measurable ROI early while keeping business operations stable.
Typically NestJS, Node.js, and TypeScript for backend APIs, PostgreSQL with Prisma or raw SQL for data-intensive paths, Next.js and React for operator dashboards, and AWS (RDS, S3, ECS/Lambda) for cloud infrastructure.
Legacy modernization
I have led a 50M-record migration from ASP1/MSSQL to NestJS, PostgreSQL, and AWS, including a core query that went from 60 seconds to 500ms. Email me if you are planning similar work.
Open to full-time and part-time roles (remote or onsite)
Also on Toptal. Email is the best way to start a conversation.