Shaan Khan

SQL Server Database Administrator with 6+ years of experience in managing, optimizing, and supporting high-volume, mission-critical production databases (2TB+). Expertise in performance tuning, High Availability (Always On Availability Groups, Failover Clustering), and advanced troubleshooting of deadlocks, blocking, and resource bottlenecks. Hands-on experience in diagnosing production issues using DMVs, execution plans, and wait statistics.

Strong background in implementing backup/recovery strategies, disaster recovery planning, and ensuring high system availability in 24/7 environments.

Primary Consultant – SQL Server DBA at Clover InfoTech (2021-07 – Present)

Client: Emkay Global Financial Services. Environment: SQL Server 2008R2 / 2012 / 2016 / 2019

• Managed and supported large-scale production databases (>2TB) in a 24x7 environment
• Diagnosed and resolved performance bottlenecks using DMVs, wait stats, and execution plans
• Analyzed and resolved blocking and deadlocks, improving system stability
• Performed query tuning and index optimization to enhance performance
• Implemented backup and recovery strategies ensuring data safety and minimal downtime
• Configured SQL Server Agent jobs, alerts, and monitoring systems
• Optimized TempDB configuration, reducing contention issues
• Resolved transaction log full and disk space issues in production
• Executed database migrations and upgrades with minimal downtime
• Applied SQL Server best practices for performance and reliability

Primary Consultant – SQL Server DBA at Clover InfoTech (2021-07 – Present)

Client: Reliance Nippon Life Insurance. Environment: SQL Server 2008R2 / 2012 / 2016

• Implemented and supported High Availability solutions (Always On, Clustering, Log Shipping)
• Performed database consistency checks (DBCC CHECKDB) and resolved corruption issues
• Conducted failover testing and disaster recovery drills
• Applied SQL Server patches (CU/SP) in production environments
• Configured Database Mail, Alerts, and Operators
• Monitored and optimized backup jobs and transaction logs
• Analyzed SQL Server logs and Windows Event Logs for issue detection
• Supported audit and compliance activities

Database Administrator at Athena BPO Pvt Ltd. (2019-03 – 2020-12)

• Managed daily SQL Server operations, including monitoring, backups, and job execution
• Created stored procedures, triggers, and reports
• Handled transaction log management and disk space issues
• Performed database restore and recovery validation
• Monitored job failures and resolved production issues

Bachelor of Science in Information Technology – Mumbai University