• Worked on SSIS packages deployment and troubleshooting the related job failure issues.• Set up and configured jobs running SSIS packages from file system.• Worked on ticketed client specific database and application related issues.• Migrated database from 2012 SQL Server Database to 2016 and 2019.• Migrated SQL Database from On-prim to Azure-based cloud and worked on hybrid MSSQL environments• Performance tuning and troubleshooting and debugging of servers running slow for… Show more • Worked on SSIS packages deployment and troubleshooting the related job failure issues.• Set up and configured jobs running SSIS packages from file system.• Worked on ticketed client specific database and application related issues.• Migrated database from 2012 SQL Server Database to 2016 and 2019.• Migrated SQL Database from On-prim to Azure-based cloud and worked on hybrid MSSQL environments• Performance tuning and troubleshooting and debugging of servers running slow for regular and periodicalreports.• Setup AlwaysOn Availability Groups for high availability and disaster recovery solution.• Worked on SQL Server Failover Clustering and administration.• Database level Index rebuild and updating statistics.• Created logins for users and granted permissions and configured server aliases for linked servers.• Implemented, managed, and troubleshoot SQL Server Always On Availability Groups• Granted object level permissions for users.• Participated in regular data purging on SQL Server database.• Conducted daily database server health checks and report issues to immediate supervisor.• Disaster recovery design and administration, like HA configurations• Used Jira and Service now for project and ticket service processes.• Intensively used profiler trace, extended events, dynamic management views, query execution plans, andother admin scripts for query performance troubleshooting and optimization.• Coordinated and conducted regular and ad hoc maintenance tasks with minimal client impact.• Proactively prevented occurrences of avoidable incidents and ensured a highly stable production serverenvironment with 24/7/365 standby support. Show less

• Architected and implemented AlwaysOn Availability Groups as high availability and disaster recoverysolution.• Recovered SQL Server after master database corruption by rebuilding the database then restoring frombackup.• Developed and utilized a PowerShell script for unattended SQL Server installation and configuration aswell as configuration of Windows Failover Cluster (WSFC) for Always on Availability Groups (AG) inmulti-subnet cluster environment across data centers… Show more • Architected and implemented AlwaysOn Availability Groups as high availability and disaster recoverysolution.• Recovered SQL Server after master database corruption by rebuilding the database then restoring frombackup.• Developed and utilized a PowerShell script for unattended SQL Server installation and configuration aswell as configuration of Windows Failover Cluster (WSFC) for Always on Availability Groups (AG) inmulti-subnet cluster environment across data centers. The script was used to install and configure 15+ AGclusters having three replica servers each.• Installed and configured 50+ SQL Servers (2016 SPI) on Windows 2016.• Administered Enterprise and Standard edition of SQL 2019, 2017, 2016 and 2014 instances in Always On,Failover Cluster, as well as stand-alone Environments.• Expertise in creating different datasets, pipelines to copy data from OnPrem to Azure, from Blob Storage toAzure PaaS.• Installed, configured, and administered Azure SQL Database, Azure SQL Managed Instance, and SQLServer on Azure Virtual Machines.• Managed the Azure and A WS SQL environments.• Worked with Azure SQL Database Import and Export Service.• Configured and managed SQL Server maintenance plans using Ola-Hallegren maintenance scripts forbackups, integrity checks, and index optimization with update statistics.• Automated database migrations using PowerShell and TSQL.•Created SQL jobs to monitor log-backup delays, free disk space, and Always on Availability Groupsynchronization issues.• Resolved log file growth and disk space issues.• Modified the Ola-Hallengren maintenance script for log backup by creating multiple log backups that usebucketing systems to run in parallel so that log backups don't take longer than recurrence time.• Conducted side-by-side migration of databases from enterprise SQL 2014 to enterprise SQL 2016. Show less

• Assisted in the administration and maintenance of SQL databases, ensuring availability, data integrity, andoptimal performance within McKesson's infrastructure.• Supported the maintenance of SQL database availability and performance, contributing to smoothoperations and improved customer satisfaction.• Collaborated with the DBA team on tasks such as database installation, configuration, and patching,aligning with McKesson's operational requirements.• Monitored… Show more • Assisted in the administration and maintenance of SQL databases, ensuring availability, data integrity, andoptimal performance within McKesson's infrastructure.• Supported the maintenance of SQL database availability and performance, contributing to smoothoperations and improved customer satisfaction.• Collaborated with the DBA team on tasks such as database installation, configuration, and patching,aligning with McKesson's operational requirements.• Monitored and analyzed database performance metrics, identifying improvement opportunities, andassisting in the implementation of solutions to enhance system efficiency and reliability. Show less