Shaan Khan
Database Administrator
Hire this person
Send a job offer directly to this candidate
About
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.
Experience
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
Education
Bachelor of Science in Information Technology – Mumbai University
