Amitav Roy
I help engineering teams design systems that scale.
17 years building production systems across fintech, e-commerce, and SaaS. I write about system design, architecture decisions, and the patterns that keep software running at scale for engineering leaders and developers.
Consultant · Architect · Speaker
What I write about
System Design & Architecture
How distributed systems fail, scale, and recover.
Multi-cloud strategy, database design patterns, and race conditions at production scale.
Read system design articles →Software Engineering & AI
Building with modern tools, done right.
AI-assisted development, MCP integrations, and Laravel delivery practices.
Read engineering articles →Practical How-To Guides
Solutions to real problems. No filler.
Latest articles
See all →
System design · March 2026 · 7 min read
Multi-Cloud Redundancy: The Gap in Our Resilience Thinking
Multi-region is not enough. Recent outages exposed the gap between region and provider redundancy.
Read article →System design · March 2026
PostgreSQL's GiST Exclusion Constraint: The Database-Level Answer to Double Bookings
PostgreSQL's GiST exclusion constraint prevents overlapping hotel bookings at the database layer — making double bookings structurally impos...
System design · February 2026
Race Conditions in Hotel Booking Systems: Why Your Technology Choice Matters More Than You Think
Race conditions in hotel bookings: PHP needs only DB protection, Node.js/FastAPI need both DB and app-level locks. Use atomic updates by def...