Jagan Kumar

Jagan Kumar Email and Phone Number

Sr. Database Administrator @ Big Lots
columbus, ohio, united states
Jagan Kumar's Location
Lewis Center, Ohio, United States, United States
Jagan Kumar's Contact Details

Jagan Kumar personal email

About Jagan Kumar

Core Competencies on Microsoft SQL Server  Database Migrations and Upgrades HA- AlwaysOn, Mirroring, Clustering, In-memory Reporting solutions on Replication, Log Shipping Query Optimization and Performance Tuning SQL Server and Database Standards for Setup, Configuration, Security, best practices T-SQL, SSMS, SQLPS, SQLCMD, Powershell Troubleshooting complex issues with Microsoft  Automation on Database Maintenance tasks Microsoft Certified Technology Specialist  SQL Server Integration Services,  SQL Server Reporting Services SQL Server Analysis Services Core Competencies on Oracle and Oracle Cloud Infrastructure (OCI) Promote database and objects changes across database environments Oracle 11gR2, 12c, 19c, 20c Manage Single Instance, Multi Instance, RAC, ASM Database installation, patching and security File system and Tablespace management Database ad-hoc Backups, Restores and Disaster Recovery (RMAN) Redhat Linux and AIX OS management with Oracle Toad, SQL Developer, Putty, WinSCP, expdb and impdb Password less remote connectivity to OCI ResourcesCore Competencies on Snowflake Cloud (Azure and AWS) Promote database and objects changes across database environments Security management – users, roles, warehouse, MFA, RBAC model, Integrations Network policy management Database backups and tasks using crontab Database refresh using clone approach Automation on SnowSQL utility Federated authentication SSO, SAML, oAuth, MFACore Competencies on Teradata Promote database and objects changes across database environments Security management  Space management Client tools configuration integrated with Software center Teradata administrator, SQL Assistant, Viewpoint

Jagan Kumar's Current Company Details
Big Lots

Big Lots

View
Sr. Database Administrator
columbus, ohio, united states
Website:
biglots.com
Employees:
3941
Jagan Kumar Work Experience Details
  • Big Lots
    Database Administrator
    Big Lots Oct 2015 - Present
    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
  • Hcl America Inc
    Sr. Sql Server Database Administrator
    Hcl America Inc May 2009 - Oct 2015
    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
  • Mahendra Satyam
    Sql Server Dba
    Mahendra Satyam 2007 - 2009
  • Verizon Data Services
    Senior Sql Analyst
    Verizon Data Services Nov 2005 - Nov 2007
    Chennai Area, India
  • Ramco Systems
    Sql Developer
    Ramco Systems 2004 - 2005

Jagan Kumar Skills

Microsoft Sql Server Sdlc Software Project Management Oracle Ssis Performance Tuning Etl Requirements Analysis Databases Pl/sql Data Warehousing Solution Architecture Agile Methodologies Sql Ssrs

Jagan Kumar Education Details

Frequently Asked Questions about Jagan Kumar

What company does Jagan Kumar work for?

Jagan Kumar works for Big Lots

What is Jagan Kumar's role at the current company?

Jagan Kumar's current role is Sr. Database Administrator.

What is Jagan Kumar's email address?

Jagan Kumar's email address is 19****@****ail.com

What schools did Jagan Kumar attend?

Jagan Kumar attended Bharathiar University.

What skills is Jagan Kumar known for?

Jagan Kumar has skills like Microsoft Sql Server, Sdlc, Software Project Management, Oracle, Ssis, Performance Tuning, Etl, Requirements Analysis, Databases, Pl/sql, Data Warehousing, Solution Architecture.

Who are Jagan Kumar's colleagues?

Jagan Kumar's colleagues are Kayla Black, Ae En, Mimi Asel, Zane Martinez, Maileen Trader, Kaitlyn Mason, Pablo Bermudez.

Not the Jagan Kumar you were looking for?

  • Jagan Kumar

    Devops Engineer At Gap Inc.
    Pleasanton, Ca
    2
    gap.com, gapinc.com
  • Jagan Kumar

    Engineer V , Ericsson Inc
    Bothell, Wa
    2
    onmobile.com, ericsson.com

    2 (425) 3XXXXXXX

  • Mekala Jagan Kumar

    | Talent Acquisition Specialist | Infosys | North America
    Advance, Nc
    1
    infosys.com
  • Jagan Kumar

    Manager At Ey | Enabling Org And Workforce Transformation Through Data & Analytics
    New York City Metropolitan Area
    2
    spglobal.com, ey.com

    2 +131593XXXXX

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.