C S Vinay Kumar
Hyderabad
Summary
Currently working on IBM Mainframes Production DB2 DBA for Z/OS since 4+ years and having total 11 + years of diverse experience on IBM Mainframes which includes DB2 DBA for Z/OS, Application Design, Development, Testing, Maintenance and Production Support
Overview
14
14
years of professional experience
Work History
Lead Administrator
Wipro Technologies
Hyderabad
08.2022 - Current
- Handling data refresh from production to non-production schemas and carrying out Create/Alter/Drop DB2 objects like Tablespace, Table, Index, Constraint, and other DB2 objects both in Test and Production Environments
- Providing daily support activities like Performing health checks, monitoring Logs/thread activity; resolving various DB2 DBA job abend issues, locking issues and contentions, scheduling administration activities
- Providing DBA comments on long running DB2 Queries to application teams and suggesting performance improvements
- Removing various restriction like Check Pending, Copy pending, Rebuild Index pending and GRECP status and handling bind/rebind requests
- Working closely with other mainframe towers in resolving incidents during WD1/WD4, on daily basis and involved in converting old table spaces to DB2 V12 Standard Table spaces
Technical Lead
TATA Consultancy Services (TCS)
Hyderabad
05.2021 - 08.2022
- DB2 monthly space reporting, DB2 Performance Issues, working on long running jobs/monitoring performance on WD1/WD4 using CA SYSVIEW tool, providing improvement suggestions to application teams on SQL Tuning, and creating problem requests for repeated incidents and implementing change requests during our window time
- Quarterly maintenance activities which Includes DB2 Test Packs, DB2 Manual Tests, IMS Test Packs, DB2 and IMS Cloning on production and other development LPARS, CA Customization Process and working on ZPARM changes in all LPARS
- DB2 Refresh process, Implementing DDL changes which we get from DEV DBA's via DBA MAILBOX, granting access to Non Mainframe DBA's and other teams based on request which we get via service now
- Working closely with other mainframe towers in resolving incidents during WD1/WD4, on daily basis, quarterly and yearly activities, converting old table spaces to DB2 V12 Standard Table spaces
- On-call on rotation basis, which we get as service now incidents and resolving them by referring to mainframe DOCOPER, KEDB, previous incidents and standard operating procedure documents and other repositories
- Buffer pool sizes changes, Compare database objects of different regions and syncing up across the regions after production releases, Backup/Recovery, and Functional knowledge of Online utilities like IMAGE Copies, Quiesce, RUN-STATS, Package Rebinds, Normal REORG and REORG RE-BALANCES
Application Development Team Lead
Accenture Solutions Private Limited
Hyderabad
05.2016 - 01.2020
- Monitoring online utilities across various LPARs, and scheduling housekeeping jobs for new change requests and working on call production support
- End To End Transition Knowledge on IBM Mainframe Environments Experienced on working with Credit, Debit and Loyalty payment cards i.e.,VISA, MASTER, MAESTRO, EMV, Non - EMV, Contact, Contact Less.
- Experienced on working and understanding various billing disputes raised by customers
- Having knowledge on various point of sale devices and their respective host system's
- Worked on customer account settlement system were I have to make sure the dollar amounts of POS and Host system are matching.
Lead Consultant
Collabera Technologies Private Limited
Hyderabad
03.2015 - 05.2016
- Maintenance and Support of both batch and Online module (i.e., COBOL - DB2, COBOL - VSAM and COBOL - CICS)
- On call Production Support/Maintenance of both batch & Online modules
- Documenting work around resolutions of mainframe production abends in mainframe PDS library and in share point
Project Trainee and Associate Software Engineer
CGI
03.2010 - 06.2014
- Prepared high level functional, technical and design documentation based on business requirements
- Developed new Programs from scratch COBOL - DB2, Peer reviewing of newly created Codes & corresponding test documents
- Maintenance and Support of both online and batch modules COBOL - DB2, COBOL - VSAM and COBOL - CICS
- Worked on verizon's CBSS Product (i.e., Customer Billing Service System) and having exposure on both wireline and wireless customers of various provinces of canada.
Education
Accelerated General Management Program - General Management, Executive Education
Indian Institute of Management,Ahmedabad
04.2020
Bachelor Of Technology - Electronics And Communication Engineering - Full Time
Padmasri.Dr.B.V.Raju Institute Of Technology
04.2007
Intermediate - M.P.C - Full Time
Sri Chaitanya Junior Kalasala
04.2003
Tenth - 10th Standard - Full Time
The City High School
04.2001
Skills
- CA Platinum/CA SYSVIEW
- BMC DB2
- TWS
- SDSF
- COBOL
- JCL
- VSAM
- CICS
- IBM DB2
- Service Now
- BMC Remedy
- Endeavor
- SPUFI
- File AID
- TSO SAR
- TSO SARE
- TSO ACS
- TSO PSCS
- QMF
- CBSS - Verizon Product
- CA 7
- Pan valet
Technical Certifications
- IBM Mainframes DB2 DBA for ZOS, 02/2021, 02/2021, Themis Corporate Institute, USA
- IBM Mainframes Systems Administration for ZOS, 03/2021, 03/2021, Themis Corporate Institute, USA
- IBM Mainframes for Z/OS, 10/2009, 12/2009, Maintec Technologies, Hyderabad
- Cyber Security and Risk Management, 11/2019, 03/2020, Executive Education - IIM, Raipur
- Advanced Accelerated Engineering (EDGE Engineer), 06/2007, 01/2008, NIIT, Hyderabad
- DB2 DBA on LUW, 01/2016, 03/2016, Visual Path Corporate Institute, Hyderabad
- Business Analytics, 07/2019, 07/2019, Executive Education - IIM, Bangalore
International Experience
California State, USA, 10/2016, 11/2016, B1 VISA
Timeline
Lead Administrator
Wipro Technologies
08.2022 - Current
Technical Lead
TATA Consultancy Services (TCS)
05.2021 - 08.2022
Application Development Team Lead
Accenture Solutions Private Limited
05.2016 - 01.2020
Lead Consultant
Collabera Technologies Private Limited
03.2015 - 05.2016
Project Trainee and Associate Software Engineer
CGI
03.2010 - 06.2014
Accelerated General Management Program - General Management, Executive Education
Indian Institute of Management,Ahmedabad
Bachelor Of Technology - Electronics And Communication Engineering - Full Time
Padmasri.Dr.B.V.Raju Institute Of Technology
Intermediate - M.P.C - Full Time
Sri Chaitanya Junior Kalasala
Tenth - 10th Standard - Full Time
The City High School