Fahad H.

I’m an EXPERT SQL Server & Cloud Database Performance Engineer with 8.6+ years of experience optimizing production systems across SQL Server, Azure SQL, and AWS RDS. I specialize in identifying performance bottlenecks, fixing slow systems, and improving overall database efficiency — end-to-end. How I Work (Step-by-Step Approach) Phase 1 – Performance Audit Analyze SQL Server / Azure SQL / AWS RDS environments (CPU, IO, memory, DTU/vCore) Identify top resource-consuming queries using Query Store / DMVs Check wait stats, blocking, and deadlocks Review index usage (missing, duplicate, unused) Analyze data growth and large table patterns Evaluate workload, concurrency, and peak usage Phase 2 – Deep Dive Analysis Analyze actual execution plans to find scans, bad joins, and inefficient queries Identify parameter sniffing and cardinality issues Review schema design and data models Assess concurrency issues and workload contention Identify cloud-specific constraints (Azure throttling / RDS limits) Phase 3 – Recommendations Provide clear, prioritized optimization plan: Quick wins (indexing, query fixes) Medium improvements (schema tuning, partitioning) Long-term strategy (scaling, architecture) Define expected performance improvements and impact Phase 4 – Implementation Rewrite and optimize complex SQL queries Design and implement effective indexing strategies Tune stored procedures and database objects Resolve blocking, deadlocks, and concurrency issues Optimize configurations across SQL Server, Azure SQL, and AWS RDS Phase 5 – Validation & Monitoring Benchmark performance before vs after changes Set up monitoring (Query Store, Extended Events, Azure Monitor, alerts) Provide long-term performance management guidance Core Skills : SQL Server (2008–2022), Azure SQL Database, AWS RDS (SQL Server) SQL Server Performance Tuning & Database Optimization Query Optimization & Execution Plan Analysis T-SQL Development (SPs, functions, complex queries) Index Optimization & Statistics Management Blocking, Deadlocks & Concurrency Troubleshooting High-Concurrency & Production System Performance Monitoring (Query Store, DMVs, Extended Events, PerfMon)