
Over 15 years of experience in Microsoft SQL Server Administration across multiple versions and environments, including on-premises and cloud (Azure, AWS). Demonstrated leadership as a Technical Lead DBA, managing mission-critical database platforms and optimizing performance. Extensive expertise in migrating SQL Server databases to Azure and AWS, ensuring high availability and security. Proficient in implementing advanced security measures and automating database management processes to enhance operational efficiency.
Executed database migrations from on-premises systems to Azure cloud environments.
Integrated GitHub for effective version control of SQL code and automation scripts.
Managed Transparent Data Encryption (TDE) across standalone and clustered SQL environments.
Established Elastic Pools, Geo-Replication, and failover groups to ensure high availability.
Administered AWS SQL Server instances (EC2 and RDS) while leading migration projects.
Utilized PowerShell scripting for automation of SQL server installations via Ansible Tower.
Established robust disaster recovery procedures, including server-level firewalls and TDE.
Executed database maintenance, performance tuning, and backup/restoration procedures effectively.
Executed migrations of on-premises databases to Azure and AWS cloud environments.
Provided 24/7 production support for database and application issues, resolving deadlocks efficiently.
Configured Always On Availability Groups in cloud VMs to ensure high availability.
Automated SQL Server installations and operational tasks using PowerShell scripting.
Implemented disaster recovery measures with Transparent Data Encryption (TDE) and server-level firewalls.
Delivered Level 2 and 3 support for SQL database environments, ensuring timely issue resolution.
Oversaw security policies, managed logins and users, and supported transaction replication.
Executed maintenance tasks such as index defragmentation and rebuilds across databases.
Managed database security by implementing logins, creating users, and assigning responsibilities.
Identified and resolved fragmentation issues to enhance database performance.
Provided 24/7 production support for database and application issues, ensuring high availability.
Performed failover and failback operations on clusters as required.
Collaborated with development teams to analyze and troubleshoot code issues, including deadlocks.
Configured Azure services for PaaS and IaaS, migrating databases from on-premises to Azure.