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

Similar Profiles

  • Bhanu RBhanu R

    DB2 DBA at Wipro LimitedDB2 DBA at Wipro Limited

  • LINDSEY PEYROTLINDSEY PEYROT

    Technical Engineer 2- DB2 DBA at Fifth Third BankTechnical Engineer 2- DB2 DBA at Fifth Third Bank

  • Vikas BissaVikas Bissa

    Mainframe DB2 DBA Support at Kyndryl India Pvt. Ltd.Mainframe DB2 DBA Support at Kyndryl India Pvt. Ltd.

  • LUIS VALDESLUIS VALDES

    Designed, coded, tested, debugged, and migrated components of a Front-End application, using the following ISPF Dialog Manager Tools: Panels, Messages, Tables and Skeletons, along with REXX Execs, which facilitated Subject Matter Expert’s (SME’s) identification and extraction of Endevor elements, to prepare for transfer to a LINUX-based system named, “Informatica”. SMEs used Informatica to prepare the downloaded element’s flows to identify technical debt, so that the Agency could migrate away from, what it considered, Legacy development languages. This was due to the shrinking pool of expertise and availability of Legacy Language talent pool.Supplied support to many other mainframe developers, via a tool called Workbench from Allen Systems Group (ASG).The tool was a Data Resource Management System (DRMS) Facility, which provided a repository for and management of COBOL, HLASM, and CICS development metadata. Also managed by the tool were various other elements, such as user access, and Dynamic Table Access Management (DTAMS).Using JCL, REXX, Endevor, TADz, Workbench, and CyberFusion on the mainframe and UltraEdit, MS Access and Excel on the Network, developed a very extensive and complex spreadsheet, for a Tech 14 to evaluate and ultimately present to the Associate Commissioner and other higher-level SSA management. The spreadsheet was a depiction of the overall scope and effort that needed to transition from Workbench (SSA no longer received support for the product), and it aided the Tech 14 in his future presentation.Coding, testing, debugging, and migrating programs (HLASM/COBOL/CICS/Db2/IMS), routines, copybooks, and macros, in support of multiple applications across the Agency.Created and maintained numerous ISPF REXX and CLIST scripts.Created and updated Standard Operating Procedures (SOP) and User manuals, using M365 Tools, including VISIO Pro.Created and supported many MS Access and Db2 SQL scripts, to access and update related databases and tables.Involved in the testing of zOS Multi-Factor Authentication (zMFA), which supplanted Single Sign-On (SSO) at the Agency. zMFA provides multiple levels of authentication and thus, greater levels of security.Participated in Daily Stand-ups/Weekly/and Monthly and other Agile-Related meetings on multiple Teams.Maintained Team SharePoint sites (pages) which later were ported to Confluence. at Leidos, Inc., for Social Security AdministrationDesigned, coded, tested, debugged, and migrated components of a Front-End application, using the following ISPF Dialog Manager Tools: Panels, Messages, Tables and Skeletons, along with REXX Execs, which facilitated Subject Matter Expert’s (SME’s) identification and extraction of Endevor elements, to prepare for transfer to a LINUX-based system named, “Informatica”. SMEs used Informatica to prepare the downloaded element’s flows to identify technical debt, so that the Agency could migrate away from, what it considered, Legacy development languages. This was due to the shrinking pool of expertise and availability of Legacy Language talent pool.Supplied support to many other mainframe developers, via a tool called Workbench from Allen Systems Group (ASG).The tool was a Data Resource Management System (DRMS) Facility, which provided a repository for and management of COBOL, HLASM, and CICS development metadata. Also managed by the tool were various other elements, such as user access, and Dynamic Table Access Management (DTAMS).Using JCL, REXX, Endevor, TADz, Workbench, and CyberFusion on the mainframe and UltraEdit, MS Access and Excel on the Network, developed a very extensive and complex spreadsheet, for a Tech 14 to evaluate and ultimately present to the Associate Commissioner and other higher-level SSA management. The spreadsheet was a depiction of the overall scope and effort that needed to transition from Workbench (SSA no longer received support for the product), and it aided the Tech 14 in his future presentation.Coding, testing, debugging, and migrating programs (HLASM/COBOL/CICS/Db2/IMS), routines, copybooks, and macros, in support of multiple applications across the Agency.Created and maintained numerous ISPF REXX and CLIST scripts.Created and updated Standard Operating Procedures (SOP) and User manuals, using M365 Tools, including VISIO Pro.Created and supported many MS Access and Db2 SQL scripts, to access and update related databases and tables.Involved in the testing of zOS Multi-Factor Authentication (zMFA), which supplanted Single Sign-On (SSO) at the Agency. zMFA provides multiple levels of authentication and thus, greater levels of security.Participated in Daily Stand-ups/Weekly/and Monthly and other Agile-Related meetings on multiple Teams.Maintained Team SharePoint sites (pages) which later were ported to Confluence. at Leidos, Inc., for Social Security Administration

CREATE PROFILE
Narinder Singh