Projects

A selection of projects showcasing infrastructure, automation, and system design expertise

🗄️

High-Availability PostgreSQL Cluster (Patroni)

Deployed a 3-node auto-healing PostgreSQL 15 cluster on AWS EC2 using Patroni and etcd for leader election and consensus. Infra managed end-to-end with Terraform and drift controls.

Auto-healing Patroni etcd Monitoring <5s Failover
PostgreSQL AWS EC2 Patroni Terraform Prometheus Grafana
🤖

ML-Powered Database Anomaly Detection

Built a Python + Scikit-learn Isolation Forest model using 6 months of pg_stat_statements metrics to detect deadlocks, I/O spikes, and autovacuum storms.

Isolation Forest 91% Precision 87% Recall Regression Detection
Python Scikit-learn PostgreSQL Grafana SQL
☁️

AWS Cost Optimization Framework

Built a comprehensive cost optimization framework that analyzes AWS usage patterns, identifies waste, and provides automated recommendations. Drove $1.2M annualized savings through EC2, RDS, and EBS right-sizing.

Cost Analysis Automation Reporting Right-sizing
AWS Cost Explorer Lambda Python CloudWatch
🔄

Infrastructure as Code Platform

Created a standardized Terraform-based infrastructure platform that enables rapid deployment of cloud resources with consistent configurations, security policies, and best practices across multiple environments.

Terraform Modules CI/CD Integration Multi-environment Security Hardening
Terraform GitHub Actions AWS GitOps
📊

Observability & Monitoring Stack

Designed and implemented a comprehensive observability platform integrating metrics, logs, and traces. Provides real-time insights into system health, performance, and user experience with intelligent alerting.

Metrics Logging Tracing Dashboards
Prometheus Grafana ELK Stack OpenTelemetry
🚀

Zero-Downtime Migration Framework

Developed a framework for performing zero-downtime database migrations and infrastructure upgrades. Enables seamless transitions between systems without impacting user experience or business operations.

Zero Downtime Blue-Green Deploy Rollback Capability Validation
PostgreSQL AWS Scripting Automation