Solutions Architect

• Designed and deployed an automated RDS monitoring system using AWS Lambda to detect high CPU utilization. Dynamically enabled/disabling slow query logging and sent real-time insights—including top CPU-consuming SQL queries—to developers, significantly improving troubleshooting and optimizing memory and I/O performance.
• Automated provisioning of AWS EC2 and RDS instances using CloudFormation and Terraform. Implemented Elastic IP allocation, daily EC2 snapshot rotation, and automatic resource tagging—reducing manual configuration errors by over 85%.
• Architected an end-to-end CI/CD pipeline for Acumatica customization projects using Batch, PowerShell, Python, and REST APIs. Fully automated the build, backup, and deployment processes—cutting down release time from 3 hours to just 45 minutes.
• Developed a user-friendly PowerShell GUI tool for IIS web configuration management. Enabled secure reading, editing, and encryption of `web.config` files across multiple environments, minimizing manual intervention and risk.
• Created a robust MySQL backup automation script featuring encrypted credential handling, definer cleanup, 7z compression, S3 uploads, and automated pre-signed URL generation shared via AWS SES—reducing backup times by 65% while maintaining strict security protocols.
• Implemented comprehensive monitoring dashboards and alert systems using Grafana and CloudWatch, enabling real-time system health tracking and proactive incident response.