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
Jalandhar01.2013
BSC - IT
PTU Jalandhar
Jalandhar01.2011
XII / Diploma - PCM
D. R. Jain National SR. Sec. School
Jalandhar, Punjab01.2008
X - PCM
D. R. Jain National SR. Sec. School
Jalandhar, Punjab01.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
Subhash ManjathodiSubhash Manjathodi
Cloud Architect at Kyndryl Solutions pvt Ltd / IBM India pvt ltdCloud Architect at Kyndryl Solutions pvt Ltd / IBM India pvt ltd
Kiran VuyyuruKiran Vuyyuru
Site Reliability Engineer (SRE) at Kyndryl Solutions Pvt Ltd / IBM India Pvt LtdSite Reliability Engineer (SRE) at Kyndryl Solutions Pvt Ltd / IBM India Pvt Ltd
MD DANISH IQBALMD DANISH IQBAL
Senior Associate II - SME at Kyndryl Solutions Pvt. Ltd.Senior Associate II - SME at Kyndryl Solutions Pvt. Ltd.
Jeevan LalJeevan Lal
MSSQL SERVER DBA at KYNDRYL SOLUTIONS PVT. LTD.MSSQL SERVER DBA at KYNDRYL SOLUTIONS PVT. LTD.
Tanish GuptaTanish Gupta
Senior Quality Analyst at Infosys LimitedSenior Quality Analyst at Infosys Limited