Project Case Studies

I designed and implemented a fault-tolerant PostgreSQL cluster with automatic failover, achieving 99.99% uptime for a critical financial application.

I built a real-time CDC pipeline using Debezium and Kafka to stream database changes to downstream systems, enabling real-time analytics and data synchronization.

I did comprehensive performance tuning of a struggling SQL Server instance, reducing query times by 85% and eliminating daily timeout errors.

I migrated legacy ETL processes from cron jobs and stored procedures to Apache Airflow, improving reliability, observability, and maintainability.

I executed a zero-downtime migration of a 2TB SQL Server database from on-premises to Azure SQL Database, with complete application compatibility.

I built a centralized monitoring and alerting platform for a multi-database environment, providing visibility into performance, availability, and capacity across 50+ database instances.

I built an AI-powered database intelligence platform that transforms raw telemetry into actionable insights, providing automated performance analysis, regression detection, and optimization recommendations with full explainability and human-in-the-loop controls.

End-to-end simulation of a banking data platform, including core banking schemas, synthetic data generation, and table creation scripts designed to model real-world financial systems and data engineering architectures.

Databricks Banking Lakehouse – Architecture

Collection of practical T-SQL scripts I use for SQL Server administration, performance tuning, and troubleshooting. Includes monitoring queries, index analysis, blocking detection, backups, integrity checks, and automation utilities.