Sr. System Database Analyst, Senior Db2 Dba And Db2 Systems Programmer Resume
EXPERIENCE SUMMARY:
- 11 years of experience in System z, DB2 z/OS and related Technologies.
- Played various roles as a developer, system support specialist, DB2 DBA, RACF Admin, SCLM Admin, Automation expert, build and customize z/OS for zPDT, Solutions architect and z/OS System programmer installing variety of products and middleware in z/OS.
- Excellent knowledge in DB2 on z/OS system programming, Installing and maintaining program products using SMP/E, JCL, DB2 DBA, SCLM, REXX, RACF and Unix System Services (USS).
- Familiar with z/VM, zLinux, PLI and COBOL development/enhancements in z/OS, WAS Configuration, CICS, IMS, RDz and zOSMF.
- Consecutive Top Performer in project deliverables for the last 11 years.
SOFTWARE SKILLS:
Languages: REXX, JCL, SQL, PLI, COBOL, Shell scripting, VBA
Mainframe OS: z/OS 1.9 - 1.13, z/OS 2.1-2.2, zVM 5.4 - 6.3, zLinux
Databases: DB2 V7 - V11 (Data Sharing) and IMS 11-13
Tools: SMP/E, SCLM, Tivoli Workload Schduler, DB2 Admin tool, SPUFI, QMF, Lotus Notes DB, zOSMF, FileManager, YaST, IBM DB2 Data Studio, Putty, FTP/SFTP, DFSMS, DB2 Object Compare, DB2 Log Analysis Tool, Omegamon XE for DB2, Websphere Application Server, IBM Output Manager, IBM Query Monitor, IBM DB2 Accessories Suite, Abend Aid, File-Aid, OPTIM, IS Replicator, XPEDITOR, DB2 Automation Tool, DB2 Table Editor, DB2 SQL Performance Analyser, Omegamon service management suite(includes all Omegamon products for zOS) and zPDT.
EMPLOYMENT HISTORY:
Confidential
Sr. System Database Analyst, Senior DB2 DBA and DB2 Systems programmer
Responsibilities:
- Worked as z/OS System programmer for Confidential project, part of Solution enablement applications with IBM Innovation Center, Dallas to enable ISVs and IBM Business partners in System z.
- Worked as a DB2 DBA, SCLM Admin, RACF Admin, Support and Application Developer and for National Legacy & LMTS - IGA from December 2007 to February 2010.
Confidential
Senior System Database Analyst
- Systems and DBMS related support was provided to all application development and testing groups and project level Database Administrators.
- Maintained 20+ Stand Alone and Data Sharing DB2 subsystems.
- Migrated to Omegamon Service Management suite for monitoring all zOS activities.
- I am part of the mainframe team which planned and executed Data Center failover project to improve availability of State mainframe systems.
- We successfully failed-over to alternate site without any issues in April 2018.
Confidential
Senior Database Administrator
Environment: z/OS v1.13 - z/OS v2.2, DB2 V10-V11, Omegamon XE, DB2 Admin Tool, DB2 Automation Tool, DB2 Object Compare Tool, SMP/E 3.6, DB2 Query Monitor, DB2 Log Analyzer, SQL performance analyzer, DB2 Table editor, Infosphere Data Replicator, IMS, QMF, Compuware products like File-Aid, File-Aid for DB2, Xpeditor, Abend-Aid, Optim Move etc..
Responsibilities:
- Maintenance of the ALL the DB2 related z/OS Boxed products in SMP/E
- Weekly and Daily Maintenance of DB2 and related software on the 14 PROD systems and 6 TEST systems.
- Migrate 20 DB2 zOS subsystems from V10 to V11.
- Weekly and Daily Housekeeping of DB2 Objects, Catalog and related software.
- Participate in the Disaster recovery planning, testing and execution process.
- Work with IBM DB2 Tools support team via PMRs/Service requests to inform about bugs, fixes, issues and PTF/APARs
- After the SMP/E APPLY process, Perform DB2/Tools Holddata activities on z/OS system after PUT/RSU maintenance.
- Participate in the change management meetings for z/OS upgrades and DBMS upgrades to ensure smooth migration of maintenance code and/or levels
- Work with the zOS, Network and CICS System programmers on DBMS/Tools affected system areas and improve performance of the overall operating system.
Confidential
System programmer and support for z/OS, DB2 DBA
Environment: z/OS v1.9 - z/OS v2.1
Responsibilities:
- Maintenance of the ALL the DB2 and related products in SMP/E
- Build the z/OS Base, Program products and Middleware for Application developer’s controlled Distribution(ADCD) for zPDT
- Maintenance of the ALL the z/OS class systems around the world.
- DB2 DBA for IIC Dallas Environment.
- Perform Maintenance on DB2 v9,V10,V11 and related DB2 tools using SMP/E
- Perform DB2 Holddata activities on class system after PUT/RSU maintenance.
- In charge of Usage reporting tools suite and ETPTools in z/VM
- Support ALL the z/OS related PMRs & provide support and guidance to the ISVs and IBM BPs in case of any problems.
- CORE Build team member for ADCD z/OS emulation running on Linux.
- IBM approved trainer for Introduction to z/OS class and workshop, held in many IBM IICs and universities to equip professors and students to work with mainframe.
- Primary contact for ADCD July 2013 Edition to build the z/OS base, program products and major middleware like DB2, IMS, CICS, WAS, WAS MQ and Omegamon.
- Conducted 15 days z/OS workshop for faculty and students at BINUS University, Jakarta, Indonesia in 2010.
- Conducted several weekend workshops for the staff and students at Vellore Institute of Technology, India and helped the faculties during trainings, labs and projects from 2010-2012.
- I was invited for presenting technical paper in VIT India which was well received by the students and faculty.
- Conducted several weekend workshops for the staff and students and worked with NGP College of science to setup z/OS curriculum in 2012.
- Conducted weekend workshop on z/OS to SASTRA University, India to setup z/OS curriculum in 2013.
Confidential
SCLM Admin, DB2 DBA, RACF Admin
Environment: & Tools: SCLM, RACF, DB2, JCL, OPC, REXX
Responsibilities:
- Technical support to enable unit/function/UAT testing for the Development and User Test groups
- Support to the technical testing of products and fixes which comes as PMRs, CRs and APARs
- Library management including rigorous change and configuration management control
- Package and shipment of Release and Maintenance upgrades
- Build and maintenance of Complex Test Environments
- Support to TRtools applications (TREAT, TRIP, TRAC Notes D/B) - Enhancements and Maintenance
- Automating and effort reduction on SCLM/RACF Administration tasks by developing Rexx tools.
Confidential
Application Developer
Environment: & Tools: JCL, PLI, DB2, TWS
Responsibilities:
- Daily batch monitoring of TA UK Batch process and fix problems providing solutions.
- The design, coding and unit testing of change requests or minor enhancements received from clients.
- Assisting in testing of new products from Training administrator (TA) and adding new Revenue codes to the system.
Confidential
Support & Application Developer, DB2 DBA
Environment: JCL, PLI, DB2, TWS, REXX
Responsibilities:
- Development and maintenance of the application programs.
- Execution of the month end jobs which generates the processed output which is used by the feeders to generate the bills.
- Enhancement of code based on the users’ request.
- Creation and maintenance of OPC applications required to run the month end process there by automating the whole process.
- Build and maintenance of Test Environments.
Confidential
Support & Application Developer
Environment: JCL, PLI, DB2, TWS, REXX
Responsibilities:
- Development and maintenance of the application programs.
- Execution of the month end jobs which generates the processed output which is used by the feeders to generate the bills.
- Enhancement of code based on the users’ request.
- Creation and maintenance of OPC applications required to run the month end process there by automating the whole process.
- Build and maintenance of Test Environments