GrounDnD, System design for short term home rental service
• Designed, deployed, and scaled a backend for a related homes microservice to support 10M+ records on EC2 using a t2.micro instance.
• Optimized PostgreSQL read latency for multi-column range query from 2s to 12ms using multi-column b-tree indexing.
• Implemented a round robin HTTP load balancer via NGINX to achieve a throughput of 300 rps and an error rate of 0% during high, concurrent user connections.
• Improved average response time by 200ms by configuring Redis as an in-memory data cache resulting in an average latency of 700ms during high stress server load.