Database Administrator and Application Support Specialist with 11 years of experience in IT, focusing on Telecom and Enterprise sectors. Expertise in IBM DB2 LUW administration, including installation, backup, recovery, and performance tuning. Proven track record in incident, change, and problem management, ensuring compliance with SLAs and maintaining system stability. Proficient in Linux/Unix and SQL optimization, aiming to enhance IT service delivery in DB2 DBA or Application Support roles.
Overview
11
11
years of professional experience
Work History
Technical Support - DB2 DBA
Kyndryl Solutions Pvt. Ltd.
10.2021 - Current
Having 3+ years of experience in DB2 LUW Administration.
Rich experience with DB2 UDB v9.x, v10.x & v11.x Installations, Configurations and Administration.
Hands on Experience in Fix pack Installation.
Creating Databases, Table spaces, Tables, Views, Indexes etc.
Backup and Restores (Online & Offline) from Local disk in Linux, Aix.
Full database recovery and roll forward recovery to end of logs for no transaction loss or to specific point in time recovery.
Working on Database restores including Redirected restores within production and development environment as per client request.
DB2 data movement utilities - Export, Import, Load and db2move.
Troubleshooting database issues using db2diag, db2pd, db2dart, db2top, db2inspect, Snapshot monitors and Event monitors.
DB2 Maintenance and application Performance Utilities – Reorgchk, Reorg, Runstats.
SQL Tuning using db2advisor and db2explain tools.
Expertise in generating data definition language using DB2LOOK command from existing database and creating the same objects in newly created databases.
Knowledge and capable of working on HADR upon the opportunity.
Granting, revoking appropriate database access for users and groups.
Monitoring DB servers for paging, CPU, Memory requirements.
Change request creation for DB related activities and implementation.
Provided support on 24x7 shift rotation basis and monitor ticket/ Service requests & Changes and attending the user/ customer calls.
Software Developer - Circle TBO
IBM India Pvt Ltd (Experis IT Pvt. Ltd Payroll)
07.2020 - 09.2021
Taking care of Postpaid and Prepaid operations.
Responsible for error free application execution.
Automation and performance tuning of the reports.
Delivery of Daily/Weekly/Monthly and Adhoc MIS.
Handling Postpaid Application (SCRM, BCL etc) and L1/L2 related concern.
Continuous engagement with users for system/application improvement.
Resolving technical challenges encountered in daily operations.
Responsible for new project/processes/application deployment.
Raising & Closing change request for new change in application also handling application change request tickets using BMC remedy tool.
Designing and deployment of effective solution/improvement for the Business requirement.
Conduct user sessions to increase the effectiveness and usability of application.
Ensuring the Accuracy of the delivered data.
Creation and analyzing the Management Dashboards.
Software Engineer - Circle TBO
IBM India Pvt Ltd (Bizinnovativ Software PVT. LTD. Payroll)
05.2018 - 06.2020
Taking care of Postpaid and Prepaid operations.
Responsible for error free application execution.
Automation and performance tuning of the reports.
Delivery of Daily/Weekly/Monthly and Adhoc MIS.
Handling Postpaid & Prepaid CRM Application and L1/L2 related concern.
Continuous engagement with users for system/application improvement.
Resolving technical challenges encountered in daily operations.
Pre-bill error handling to identify all types of discrepancies before run live bill cycle.
Responsible for new project/processes/application deployment.
Raising & Closing change request for new change in application also handling application change request tickets using BMC remedy tool.
Designing and deployment of effective solution/improvement for the Business requirement.
Conduct user sessions to increase the effectiveness and usability of application.
Ensuring the Accuracy of the delivered data.
Creation and analyzing the Management Dashboards.
Application Support Engineer -Central BIAQ
IBM India Pvt Ltd (SOFTENGER (INDIA) PVT. LTD Payroll)
08.2017 - 04.2018
Client: Idea Cellular Ltd.
Project: Central BIAQ (Business Intelligence Ad_hoc Query)
BI is aimed at managing the entire business requirements in telecom domain and a vision of enabling easy to cross-functional data for effective business decision making.
Based on an IBM DB2 data warehouse, The entire project spans multiple source systems such as mediation, IN, post-Paid billing system, CRM, Provisioning, sales and dealer management system.
Interacted with Business Analysts and participated in user requirement sessions to analyse and gather business requirements.
Writing SQL queries for prepaid and postpaid as per business requirements.
Feasibility check of Adhoc query from end users.
Resolving the incidents and raising the incidents issues in BMC Remedy Tool with in a SLAs.
Monitoring the processes to ensure smooth functioning/loading of BU data in temp and aggregate tables.
Resolving some issues comes from corporate users.
Performing Daily checks and providing daily status reports to the users.
SERVICE DELIVERY SPECIALIST - Circle TBO
IBM India Pvt Ltd
08.2015 - 08.2017
Client: Idea Cellular Ltd.
Project: Circle TBO
Taking care of Postpaid and Prepaid operations.
Responsible for error free application execution.
Automation and performance tuning of the reports.
Handling Postpaid & Prepaid CRM Application and L1/L2 related concern.
Continuous engagement with users for system/application improvement.
Handling Postpaid Plans/Packs configurations and resolving/identifying configurations issue.
Pre-bill error handling to identify all types of discrepancies before run live bill cycle.
Responsible for new project/processes/application deployment.
Provide real time solution for issues as per the Service Level Agreement [SLA].
Coordination with the business core team and project teams for new requirement closure.
Conduct user sessions to increase the effectiveness and usability of application.
Ensuring the Accuracy of the delivered data.
Software Developer - Circle TBO
IBM India Pvt Ltd (Experis IT Pvt. Ltd Payroll)
06.2014 - 08.2015
Client: Idea Cellular Ltd.
Project: Circle TBO
Taking care of Postpaid and Prepaid operations.
Responsible for error free application execution.
Automation and performance tuning of the reports.
Handling Postpaid & Prepaid CRM Application and L1 related concern.
Continuous engagement with users for system/application improvement.
Handling Postpaid Plans/Packs configurations and resolving/identifying configurations issue.
Responsible for new project/processes/application deployment.
Provide real time solution for issues as per the Service Level Agreement [SLA].
Conduct user sessions to increase the effectiveness and usability of application.
Ensuring the Accuracy of the delivered data.
Education
MCA -
PTU Jalandhar
Jalandhar
01.2013
BSC - IT
PTU Jalandhar
Jalandhar
01.2011
XII / Diploma - PCM
D. R. Jain National SR. Sec. School
Jalandhar, Punjab
01.2008
X - PCM
D. R. Jain National SR. Sec. School
Jalandhar, Punjab
01.2006
Skills
Task achievement
Multi-tasking
Communication skills
Analytical thinking
IBM DB2 UDB and PostgreSQL
Shell scripting basics
Putty and WinSCP
Remedy and Jira
GLPI management
DB2 administration
SQL optimization
Database backup and recovery
Technical support
Languages
Punjabi
Hindi
English
Personal Information
Father's Name: Mr. Balbir Singh
Mother's Name: Mrs. Sarla Devi
Date of Birth: 05/31/91
Marital Status: Married
Timeline
Technical Support - DB2 DBA
Kyndryl Solutions Pvt. Ltd.
10.2021 - Current
Software Developer - Circle TBO
IBM India Pvt Ltd (Experis IT Pvt. Ltd Payroll)
07.2020 - 09.2021
Software Engineer - Circle TBO
IBM India Pvt Ltd (Bizinnovativ Software PVT. LTD. Payroll)
05.2018 - 06.2020
Application Support Engineer -Central BIAQ
IBM India Pvt Ltd (SOFTENGER (INDIA) PVT. LTD Payroll)