Shivam Dahiya

MS SQL Server Database Administrator with strong expertise in production support, database administration, and high-availability SQL Server environments. Experienced in supporting Airtel's production SQL Server infrastructure for the Aarcos application through Quadrafort Technologies. Skilled in SQL Server installation, configuration, Always On Availability Groups, Failover Cluster Instances (FCI), backup and recovery, performance tuning, query optimization, Grafana monitoring, Linux administration, and incident management.

Associate Application Engineer (SQL DBA Support) at Quadrafort Technologies (2022-07 – Present)

Client: Airtel | Sep 2023 – Present

• Provided production SQL Server DBA support for Airtel's mission-critical database infrastructure supporting the Aarcos application.
• Managed production Microsoft SQL Server databases ensuring high availability, optimal performance, and SLA compliance.
• Configured and maintained Always On Availability Groups (AG), replicas, and failover mechanisms.
• Administered SQL Server Failover Cluster Instances (FCI).
• Performed SQL Server installation, configuration, patching, upgrades, and validation in standalone and clustered environments.
• Executed Full, Differential, and Transaction Log backup and recovery strategies.
• Diagnosed and resolved blocking, deadlocks, long-running queries, and performance bottlenecks.
• Monitored production database clusters and infrastructure using Grafana.
• Managed SQL Server Agent jobs, database users, roles, and permissions.
• Performed query optimization, index tuning, and execution plan analysis.
• Worked extensively in Linux environments for database operations, monitoring, and troubleshooting.
• Handled L1/L2 production incidents and participated in Root Cause Analysis (RCA).

SQL DBA Support at Quadrafort Technologies (2022-07 – 2023-08)

Client: MMTC-PAMP | Jul 2022 – Aug 2023

• Provided L1/L2 support for Microsoft SQL Server production databases.
• Monitored database performance and availability.
• Performed backup and recovery operations.
• Assisted in Always On Availability Group monitoring.
• Troubleshot performance and permission issues.
• Supported Root Cause Analysis (RCA).
• Executed SQL Server patching and upgrade validation.
• Assisted in cluster environment validation.

Bachelor of Technology in B.Tech – Jamia Hamdard (2019 – 2023)