We are seeking an experienced AWS DevOps Engineer with strong backend development knowledge to optimize our database and application server load balancing infrastructure. Our current setup is underutilizing our database resources due to improper query routing configuration. Current Infrastructure Database Tier: • AWS RDS MySQL cluster with 1 writer instance and 2 reader instances • Issue: Load is not evenly distributed across reader instances • Problem manifestation: Majority of read queries are being routed to the writer instance; only the writer and 1 reader instance handle significant traffic; 1 reader instance remains largely idle Application Tier: • Backend system built with Laravel PHP and MySQL • Multiple EC2 instances requiring Application Load Balancer (ALB) configuration • ALB setup needs optimization/configuration Key Objectives: 1. Diagnose and fix RDS read/write query routing – Ensure read queries are properly distributed across both reader instances while write queries go exclusively to the writer instance 2. Review backend codebase – Audit Laravel PHP code to identify and correct any misconfigurations in database connection handling, query routing logic, or connection pool settings that may cause queries to default to the writer instance 3. Implement proper RDS reader endpoint usage – Configure the application to use RDS cluster reader endpoint for read operations and writer endpoint for write operations 4. Configure ALB for EC2 instances – Set up and optimize Application Load Balancer to properly distribute traffic across EC2 backend servers 5. Verify load distribution – Test and validate that read queries are evenly distributed across the 2 reader instances and that the previously idle instance is now receiving appropriate traffic Laravel: 5.8 PHP: 7.4 MySQL: 8 Please submit your proposal including your server management experience. Please note the selected candidate would be required to connect with us remotely and share the KT on the configuration and provide detailed documentation for our existing team.