e-Gain Technologies

Database Solution and Performance Tuning

A large restaurant chain was facing an MS SQL database performance issue along with a scalability issue. Their application went down several times due to database health issues. The customer has engaged us to find the root cause of the database issue. We worked with the customer's application team closely and helped them to fine-tune their store procedure, functions, and other select queries. Overall, they wanted the database to be scalable and highly available. We proposed the optimum solution in cost-effective way and successfully implemented.

Load Testing to make sure their application can take peak load

Customer wanted to make sure their application can take load once it will live on production. Their internal team was not confident of doing such activity. Customer has engaged us to perform such activity.

Database Analysis

As-IS database is not scalable and performant both from logical and physical design structure. We helped customer to figure out existing database landscape and future state design. We have observed existing database is not optimum to take future load and based on various metrics AWS managed database on PostgreSql was proposed.

AWS Security Posture Review and Implementation

The customer was running his applications stack across 4 AWS accounts. However, the customer was concerned about security gaps to protect the application from internal and external security threats. The customer belonged to a public sector and security was the top most priority. We helped the customer to project many security gaps as per AWS' best practices and some of the gaps were severely vulnerable. We also helped the customer to implement SSO, layer 3 and 7 firewall along with other AWS native services including control tower.

Micro-service based Application Deployment on Cloud to optimise cost

Customer's existing workload was running on on premise but during several technical deep dive sessions with customer's technical team, they are agreed to go ahead with Micro-service based architecture. Developers currently using Github and Github action for their code repo and build. They wanted an integration mechanism with Github with ECR. We have showed them the mechanism and steps to do that. We have educated customer how ECS cluster deployment works and how DynamoDB can be a good candidate for their use case. They further explored and agreed to replace IaaS stack with micro services. Initial workload to be deployed on AWS using ECS, ECR, DynamoDB, S3 and ALB.