About

SQL Server DBA with 3 years at HCLTech running 2,000+ SQL Server instances across production and DR at 99.9% availability. Strong in Always On AGs, clustering, replication, log shipping, tuning, backup and recovery and patching, plus Azure SQL Managed Instance, Ansible/PowerShell automation and ITIL-based incident handling.

Experience1

  1. Database Administrator

    Dec 2023 — Present

    HCLTech · Noida

    Administer 2,000+ SQL Server instances across production and DR in rotational-shift and on-call support, sustaining 99.9% availability through proactive monitoring, alert triage and stakeholder communication. Design and manage Always On Availability Groups, Failover Clusters, replication, log shipping and database mirroring for high-volume OLTP databases. Administer and monitor Azure SQL Managed Instance and Azure SQL Database alongside on-premises estates, covering backups, security and performance tuning. Tune high-volume databases through execution plan analysis, indexing, statistics and parameter sniffing fixes.

    • Sustained 99.9% availability across 2,000+ SQL Server instances
    • Cut incident MTTR by 20%
    • Saved 20+ hours per week through automation with Ansible and PowerShell

Projects2

  • Cloud Migration to Azure SQL for Pharma Data

    Simulated a legacy SQL Server to Azure SQL Database migration: schema assessment, DTU sizing, cost estimation, firewall rules, elastic pools, geo-redundancy, post-migration validation and rollback plan.

  • SQL Server Monitoring Dashboard for Pharma Inventory

    T-SQL and Power BI dashboard tracking inventory, batch expiry and storage conditions from ERP tables, with SQL Server Agent alerts for low stock and near-expiry.

Education1

  • Bachelor of Engineering

    2019 — 2023

    Punjab Technical University

    Computer Science and Engineering

Certifications4

  • Microsoft Azure Administrator (AZ-104T00-A)

    Skillsoft (HCLTech)

  • Database Administrator

    Skillsoft (HCLTech)

  • Oracle SQL

    Great Learning Academy

  • Cloud Computing Architecture

    Great Learning Academy

Employer sign-in for résumé