We provide IT Staff Augmentation Services!

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

Hire Now