Santa Clara County, California, United States
FKR-Products-ATELIER
(Back End system for a large E-commerce business)
Achieved 100% data integrity and increased data import efficiency by adopting a data management ETL process using MySQL for importing millions of data entries into a MysQl DB with tables structure optimized for efficient joins and querying
Reduced database instance populating time from 3hours to less than 5minutes by implementing a performant architecture, deploying server and database instances on AWS, and streamlining the ETL process using 'mysqlDump and SCP'
Introduced 'Indices' to 3 key columns, reducing DB query time from 53ms to 11ms and achieved a 0.00% error rate under stress testing with 1000 clients over 30 seconds using Loader.io
Enhanced reliability and increased performance by horizontally scaling AWS architecture from 1 to 2 additional server EC2 instances and implementing NGINX as a load balancer, ensuring even distribution of traffic, reduced server load, and improved response times by 96ms