Summary
Overview
Work History
Education
Skills
Languages
Personal Information
Timeline
Generic

Narinder Singh

Hamirpur

Summary

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)
08.2017 - 04.2018

SERVICE DELIVERY SPECIALIST - Circle TBO

IBM India Pvt Ltd
08.2015 - 08.2017

Software Developer - Circle TBO

IBM India Pvt Ltd (Experis IT Pvt. Ltd Payroll)
06.2014 - 08.2015

MCA -

PTU Jalandhar

BSC - IT

PTU Jalandhar

XII / Diploma - PCM

D. R. Jain National SR. Sec. School

X - PCM

D. R. Jain National SR. Sec. School
Narinder Singh