We provide IT Staff Augmentation Services!

Senior Db2 Systems Programmer Resume

Detroit, MI

OBJECTIVE:

To obtain a position as the DB2 Systems Programmer position on IBM mainframe environment, where there is a need for creative talent, analytical problem - solving, technical expertise and the capacity to translate organizational needs into productive solutions to effectively impact operating performance.

SUMMARY:

  • Creative, competent information systems professional with enthusiasm for challenges and problem solving and able to visualize alternative to improve system integrity and performance as a strong team player.
  • Technically oriented and results focused on extensive expertise and experiences in IBM DB2 Datasharing and non Datasharing environments and BMC and CA OEM products for DB2 on IBM mainframe support, interfacing with client server platforms, and supporting a variety of application and database systems.
  • Possessing a working knowledge of a variety of computer systems and applications as a management and operation tools to be able to quickly grasp and apply new concepts, methods and technologies.

WORK EXPERIENCE:

Confidential, Detroit, MI

Senior DB2 Systems Programmer

Responsibilities:

  • Responsible for all aspects of systems programming support for 27 DB2 V10.1 subsystems running in large Data Sharing and non-Data-Sharing, Parallel Sysplex environment.
  • Providing SMP/E installation, migration, customization and maintenance of DB2 V10.1 NF mode across multiple z/OS 1.13 LPARs. Previously installed DB2 v9.1.
  • Implemented and supported PSSC(Partial Subsystem Cloning) utilizing IBM Cloning Tool V3.1.
  • Monitoring and tuning the performance utilizing Omegamon XE for DB2 Performance Expert V5.1 and DB2 Admin Tool and obj compare V10.2.
  • Troubleshot DB2-related systems problems using Omegamon/DB2 and DB2 admin Tool. Research problems utilize IBMLINK, open PMRs and apply PTFs to fix issues.
  • Worked for Databases with DB2 utilities such as LOAD, UNLOAD, RUNSTAT, REORG, COPY, MERGECOPY, and MODIFY for the User’s Databases.
  • Maintaining Disaster Recovery process for all DB2 subsystems.
  • Completed Online REORG for the DB2 Systems Catalog and Directory.

Confidential, Peoria, IL

Senior DB2 Systems Programmer

Responsibilities:

  • Responsible for all aspects of systems programming support for 45 DB2 subsystems running in a large Data Sharing and non Data Sharing, Parallel Sysplex environment.
  • Providing SMP/E installation, migration, customization and maintenance of DB2 V9.1 NF mode across multiple z/OS 1.13 LPARs. Previously installed DB2 v8.1.
  • Monitoring and Performing performance Tuning utilizing Omegamon DB2 and DB2 PM accounting report.
  • Troubleshot DB2-related systems problems using Omegamon/DB2 and DB2 System logs. Research problems utilize IBMLINK, open PMRs and apply PTFs to fix issues.
  • Maintaining Disaster Recovery process for all DB2 subsystems.
  • Support ERP Peoplesoft DB2 subsystems for HR.
  • Support CA Erwin Data Modeler r8.2
  • Providing COPY and REORG for the DB2 Systems Catalog and Directory utilizing REXX.
  • Providing SMP/E installation and customization of CA UNICENTER R1.14.

Confidential, Sterling Heights, MI

Senior DB2 Systems Programmer

Responsibilities:

  • Provided SMP/E installation, migration, customization and maintenance of DB2 V8.1 NF mode across multiple z/OS 1.11 LPARs. Previously installed DB2 v7.1.
  • Worked for Databases with DB2 utilities such as LOAD, UNLOAD, RUNSTAT, REORG, COPY, MERGECOPY, and MODIFY.
  • Tuned the SQL performance utilizing DB2 Explain, DB2 PM accounting report, Omegamon Db2 and the third party products such as BMC Explorer, Mainview, CA detector etc.
  • Provided COPY and REORG for the DB2 Systems Catalog and Directory
  • Configured WLM Stored Procedure in a distributed environment with Mainframe and Client Server.
  • Implemented On-line Copy and REORG procedure with BMC XBM(Extended Buffer Manager)
  • Provided SMP/E installation and customization of BMC products for DB2 V8. This included MAINVIEW V9.2, SQL Performance V6.2, SQL Explorer V6.2, APPTUNE V6.2, Catalog Manager V9.3, COPY+ V9.2, REORG+ V9.3 and XBM V5.6 for online REORG.
  • Monitored and Performed performance Tuning utilizing various monitoring tools.
  • Provided SMP/E installation and customization of CA Unicenter R1.15. This included RC/Update, RC/Secure and Log Analyzer.
  • Fulfilled reconfiguring of six DB2 subsystems for joining into a Bronze Sysplex to decrease a client’s budget caused by complex OS systems environment.
  • Troubleshot DB2-related systems problems using Omegamon/DB2 and DB2 System logs. Researched problems and applied PTFs to fix issues.
  • Maintained Disaster Recovery process for all DB2 subsystems.

Confidential, Sterling Heights, MI

Senior DB2 Systems programmer and DBA

Responsibilities:

  • Provided SMP/E installation, migration customization and maintenance of DB2 V8.1 and V7.1 NF mode across multiple z/OS 1.10 LPARs. Previously installed DB2 V6.1.
  • Provided SMP/E installation and customization of BMC products for DB2 V8 and V7. This included COPY+ V8.1, REORG+ V9.1 and XBM V5.5 for Online REORG.
  • Provided SMP/E installation and customization of CA Unicenter R1.14. This included RC/Update, RC/Secure and Log Analyzer.
  • Evaluated, installed/upgraded, deployed and maintained mainframe DB2 subsystem software which are IBM Query Monitor, OMEGAMON DB2, IBM File Manager, Debug Tool and Fault Analyzer.
  • Implemented and maintained RLF (Resource Limit Facility) and WLM SQL Stored Procedure for DB2 subsystems.
  • Implemented and managed WLM Stored Procedure for all applications on the DB2 subsystems.
  • Monitored and traced application’s systems to provide performance and/or diagnostic assistance with OMEGAMON DB2 and DB2PM.
  • Worked for Databases with DB2 utilities such as LOAD, UNLOAD, RUNSTAT, REORG, COPY, MERGECOPY, and MODIFY for the User’s Databases.
  • Provided COPY and REORG for the DB2 Systems Catalog and Directory
  • Configured WLM Stored Procedure in a distributed environment with Mainframe and Client Server.
  • Implemented On-line Copy and REORG procedure with BMC XBM(Extended Buffer Manager)
  • Monitored and Performed performance Tuning utilizing various monitoring tools.

Confidential

Senior CICS & DB2 Systems Engineer

Responsibilities:

  • Evaluated, installed, deployed and maintained DB2 Data Sharing and CICS PLEX on OS/390 SYSPLEX environment
  • Configured, monitored and tuned DB2 subsystems and CICS for production environment for Confidential .

Confidential

Senior CICS Systems programmer

Responsibilities:

  • Responsible for all aspects of systems programming support for CICS and DB2 subsystems running in a Single MVS environment.
  • Configured CICS, IMS/DB and DB2 subsystems for production environment and provide operational instructions.
  • Installed, deployed and maintained DB2 system support products.
  • Monitored and traced application's systems to provide performance and diagnostic assistance.
  • Reviewed installed products for price/performance, requirements, replacement or elimination.
  • Architected existing or new software infrastructure products for increased availability and reliability.

Hire Now