Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ankit Panwar

Noida

Summary

Over 11 years of experience in Database Technologies and Data warehouses, including IBM ISAS Server and DB2 SAP BASIS. Strong background in DB2 Database Administration. Well-versed in working with Standalone and DPF environments on Linux, Unix, Windows, and HP-UX. Extensive hands-on experience using ETL tools like Datastage and CDC Administration. Proficient in Installation, Patching, Implementing Backup and Recovery Strategy, User administration, and Table space Management on both Standalone DB and DPF. Skilled in performing database recovery from production backups. Expertise in Database Cloning and Database Upgradation/Migration across different operating systems. Experienced in offline/online database backup, restore, and point-in-time recovery using full/incremental backups in standalone and DPF environments. Strong exposure to storage management analysis in both DPF and Standalone environments. Adept at creating database/object level backup policies using Symantec Net Backup through Shell Scripts and manual methods. Hands-on experience with DB2 utilities for maintenance (Reorgchk/Reorg/Runstats) and data movement (Export/Import/Load/Move/Look). Troubleshooting database issues using tools such as db2diag, db2pd, db2dart, db2trace, db2support, db2top, explain plan, db2exfmt, and snapshots. Successfully implemented disaster recovery strategies/failovers on a quarterly basis using technologies like HADR/HADR with TSA and HACMP/HA. Extensive experience in Incident, Problem, and Change management. Managed IBM DB2 technical support cases and conducted RCA analysis. Strong knowledge of structured query language (SQL) with proficiency in shell scripting and scheduling tasks. Ability to provide 24/7 on-call support for the production environment and respond to off-hour emergencies while delivering rapid solutions under pressure.

Overview

11
11
years of professional experience

Work History

Senior Database Consultant

Kyndryl
10.2023 - Current
  • Configured and set up DB2 DPF, ensuring optimal performance and scalability.
  • Managed database migrations, including version and OS upgrades, ensuring smooth transitions and minimal downtime.
  • Performed backup, recovery, and space management to maintain database integrity and performance.
  • Led data reorganization efforts to optimize storage and retrieval efficiency.
  • Troubleshot and resolved database issues, executing recovery plans to minimize system disruptions.
  • Ensured compliance with industry regulations by staying up-to-date with relevant changes and implementing necessary updates to database systems.
  • Provided exceptional customer support by quickly addressing client concerns, fostering long-term relationships and satisfaction.
  • Designed scalable database architectures to support business growth and handle increasing data volumes without sacrificing performance.
  • Collaborated with developers on software integration projects, offering guidance on best practices for database use within applications.

DB2 SME

Kyndryl Pvt Ltd
03.2022 - Current
  • Company Overview: Kyndryl is a global technology services company
  • Client: Bharti Airtel India
  • Daily Management, Maintenance, Monitoring, Tuning and Support for DB2 v9.0 and V9.5, V9.7, V10.5 databases in UNIX and Linux environment (RHEL 5.0) and windows platforms
  • Perform database software installations including database creation, configuration and applying fix packs and migration of databases as per the Patch Applicability Matrix
  • Performing weekly offline backups and daily online backups to Disks and tapes using scripts and manual methods
  • Working on Database restores including Redirected restores within production and development environment as per client request
  • Table space management – Adding, dropping, extending, reducing and resizing table space containers, Create and managing SMS, DMS, and Automatic Storage table spaces
  • Change request verifying and implementation
  • Daily maintenance activities: Runstats, Reorgs, rebinds, Backups, Space management
  • Monitoring DB servers for paging, CPU, Memory requirements
  • Setting up new environments for debugging production issues in applications and setting environments for tests
  • Data Exporting, Importing and Loading
  • Database Backups, delta, incremental and full, offline and online to disks
  • Configured the databases as per client requirement by using catalog command
  • Kyndryl is a global technology services company
  • Client: Bharti Airtel India

DB2 DBA and SAP BASIS Admin

Tata Consultancy Services
05.2019 - 03.2022
  • Company Overview: Tata Consultancy Services is an IT services, consulting, and business solutions organization
  • Client: Department of Post, India
  • DB2 Installation and configuration, Fix packs & Version Upgrade
  • Working on Database restores including Redirected restores within production and development env
  • Table space management – Adding, dropping, extending, reducing and resizing table space containers, Create and managing SMS, DMS, and Automatic Storage table spaces
  • Performing table space re-balancing for ensuring the equal data distribution across all the data mounts and applying compress methods on tables for storage savings
  • Change request verifying and implementation
  • Daily maintenance activities: Runstats, Reorgs, rebinds, Backups, Space management
  • Monitoring DB servers for paging, CPU, Memory requirements
  • Setting up new environments for debugging production issues in applications and setting environments for tests
  • Designing appropriate Database configuration parameters and tuning buffer pools for better optimized database performance
  • Data Exporting, Importing and Loading
  • Database Backups, delta, incremental and full, offline and online to disks
  • Configured the databases as per client requirement by using catalog command
  • Tata Consultancy Services is an IT services, consulting, and business solutions organization
  • Client: Department of Post, India

DB2 Database Administrator

IBM India Private Limited
12.2014 - 05.2019
  • Company Overview: IBM India Pvt Ltd provides technology and consulting services
  • Client: Bharti Airtel India
  • Managed database instances for Consolidated Online trading system in DB2 UDB in version 9.7/10.1/v10.5 on AIX 6.1 and Linux (RHEL) servers
  • Managed large, mission-critical databases
  • Interpreted business requirements and recommended solutions
  • Installation and configuration of DB2 Database servers for standalone and DPF environments in Linux and AIX operating systems
  • Managing more than 2000+ DB2 database servers and ensuring the services availability by configuring alerting mechanisms for all the production servers
  • Performing table space re-balancing for ensuring the equal data distribution across all the data mounts and applying compress methods on tables for storage savings
  • Designing appropriate Database configuration parameters and tuning buffer pools for better optimized database performance
  • Separating the file systems enforced the UDB database standard practice and it also simplified table space and file system maintenance
  • Managing DB2 Security by implementing patch management, password management, license management and GSD across all servers
  • Interact with the System Administrator for database issues including capacity planning, such as installation and configuration of new disks on Unix Systems
  • Responsible for searching various DB2 Fix Packs for v9.7 and v10.5 and providing assessment about these Fix Packs to the upper management
  • Accordingly applying various Fix Packs to v9.7 and v10.5 database servers
  • Performing weekly offline and daily online backups and restore functions using Symantec Net Backup
  • Redirect restored test databases with production databases
  • Daily activities include removing deadlocks, transaction log resolution, bottle necks, dropping & re creating staging tables, optimizing complex queries using explain/db2exfmt
  • IBM India Pvt Ltd provides technology and consulting services
  • Client: Bharti Airtel India

DB2 Database Administrator

IBM India Private Limited
07.2014 - 05.2019
  • Company Overview: IBM India Pvt Ltd provides technology and consulting services
  • Client: Bharti Airtel Africa
  • Daily Management, Maintenance, Monitoring, Tuning and Support for DB2 v9.0 and V9.5, V9.7, V10.5 databases in UNIX and Linux environment (RHEL 5.0) and windows platforms
  • Perform database software installations including database creation, configuration and applying fix packs and migration of databases as per the Patch Applicability Matrix
  • Performing weekly offline backups and daily online backups to Disks and tapes using scripts and manual methods
  • Working on Database restores including Redirected restores within production and development environment as per client request
  • Table space management – Adding, dropping, extending, reducing and resizing table space containers, Create and managing SMS, DMS, and Automatic Storage table spaces
  • Change request verifying and implementation
  • Daily maintenance activities: Runstats, Reorgs, rebinds, Backups, Space management
  • Monitoring DB servers for paging, CPU, Memory requirements
  • Setting up new environments for debugging production issues in applications and setting environments for tests
  • Data Exporting, Importing and Loading
  • Database Backups, delta, incremental and full, offline and online to disks
  • Configured the databases as per client requirement by using catalog command
  • IBM India Pvt Ltd provides technology and consulting services
  • Client: Bharti Airtel Africa

Education

B.Tech - IT

Graphic Era University
Dehradun, Uttarakhand

Skills

Proficient in DB2 UDB on LUW

Timeline

Senior Database Consultant

Kyndryl
10.2023 - Current

DB2 SME

Kyndryl Pvt Ltd
03.2022 - Current

DB2 DBA and SAP BASIS Admin

Tata Consultancy Services
05.2019 - 03.2022

DB2 Database Administrator

IBM India Private Limited
12.2014 - 05.2019

DB2 Database Administrator

IBM India Private Limited
07.2014 - 05.2019

B.Tech - IT

Graphic Era University

Similar Profiles

CREATE PROFILE
Ankit Panwar