Jagan Kumar Email & Phone Number

Columbus, Ohio Metropolitan Area

Provide End to End Management on DBA activities on 24x7 basis in both technical and leadership skills• Managed Microsoft SQL Server databases (versions 2022 to 2000) for continuous availability• Snowflake database administration: Security, Deployments, and Database refresh• Administered and managed On-prem Oracle, Microsoft Azure, and Oracle Cloud Infrastructure (OCI) databases• Evaluated and provided training on Google Cloud SQL architecture• Oversaw software licenses for Microsoft SQL Server and Idera• Migrated and managed eCommerce product databases using OCI• Administered Teradata databases: Security, Deployments, and space management• Utilized Idera SQL Diagnostic Manager with custom metrics for setup and monitoring• Monitored Oracle environments with OEM and managed with Toad• Managed high-visibility applications with AlwaysOn, In-memory, and DR procedures• Conducted database migrations and automated data transformations• Improved performance through query optimization, infrastructure configuration, and design• Recovered SQL Server and Databases from crashes and automated recurring replication failures• Developed and automated audit packages using SSIS• Evaluated third-party software for monitoring, backup, and performance needs

San Antonio, Texas Area

• Manage Microsoft SQL Server databases for continuous availability by establishing and enforcing organization standards with version from 2000 to 2012• Datacenter Server migration and Database Migration of SQL Servers• Challenged, Analyzed, Coordinated and performed database Migration from 2000 to 2012 using step down approach• Expertise in troubleshooting database issue achieve Service Level Agreements (SLA) and work with problem management for permanent resolution• Improvement on complex Performance issues based on Query Optimization, Database/Server configuration, Indexes, Table Design etc• Various SQL Server and Database recoveries from Crash by best method understanding the business criticality on the part of corruption level• Automation of recurring replication using SQL Agent jobs integration with distribution• Automation of SQL Reports using TSQL, Powershell ,SSIS• Automation of Database Inventory data collection across all SQL Servers, for database discovery, space usage, various properties etc• Design and Development of Audit package using SSIS to capture the changes across database Server• Working with culturally diverse resources in a team, which is geographically distributed in Asia and the U.S, leading and providing timely performance support• Evaluation of third-part software for the organization needs for Monitoring, Backup, Performance boost needs

Chennai Area, India