SUMMARY:

• Extensive experience with utilization and performance tuning of zIIPs.
• Installed and implemented Z/OS, DB2, DB2 data - sharing groups (DSG), CICS, JES2 and software upgrades while maintaining production availability and service levels.
• Justified, installed, and implemented Confidential and non- Confidential software products and hardware facilities, along with regular installation of software maintenance.
• Performance evaluation and tuning of Z/OS systems and important Z/OS subsystems, with WLM, DASD, DB2 DSGs, and SYSPLEX tuning a specialty, as are system software version migrations.
• Extensive experience with SMP/E, for both Confidential and non- Confidential program products.
• Reported on system utilization, performance, and capacity utilizing extensive reporting and charting tools. Have written Assembler OS exits for various purposes.
• Considered a WLM SME in order to match workload with resources, and improve overall performance of facility.
• Trained technical and non-technical staff members in the utilization of available software products. Served as a Mentor to several Systems Programming interns.
• Established & implemented operating standards for several data centers.
• Disaster Recovery Testing and Planning. Successful in justifying and implementing both PAV/MA and HyperPAV.
• Extensive experience installing, customizing, and applying maintenance to many Confidential and OEM products, along with integration, testing, and troubleshooting. SME-level expertise as a Performance and Tuning Specialist in both DB2 and Z/OS, with special expertise in remediating DASD I/O delays.
• Considered a Senior-level Systems Programmer, dual-qualified in both DB2 and Z/OS. SME-level expertise in Performance and Tuning, WLM, and with Version Migrations.

TECHNICAL SKILLS:

Software: Z/OS, DB2, DB2 Data Sharing, IDAA, SYSPLEX Coupling Facilities, WLM, JES2, WAS, CICS, MQ, PR/SM, HCD, HMC, SMP/E, DFSMS, DFHSM, DFDSS, FDR, USS, CICS TS, CICS TG, VTAM, TCP/IP, TN3270, TSO/E, ISPF, REXX, SMF, RMF, RMF Spreadsheet Reporter, OMEGAMON, MAINVIEW, SYSVIEW, DB2 PM/PE, Platinum Tools, SPUFI, ASSEMBLER, TMON, RACF, TOP SECRET, SDSF, IOF, EJES, VSAM, FlashCopy, QMF, ISMF, ACS routines, IRD, ZFS, CA - Detector, BMC APPTUNE, Visual Explain, BMC & Confidential DB2 Utilities, IPCS, Insight/DB2, among many others.

Hardware: zSeries Confidential mainframes. Confidential and EMC DASD.

PROFESSIONAL EXPERIENCE:

Confidential

Senior DB2 Systems Programmer and Instructor

Responsibilities:

• Responsibilities include upgrading RSU maintenance levels for DB2 and BMC, troubleshooting both defect and performance problems and resolving, additionally upgrading DB2 subsystems to DB2 12 for Z/OS. Solved a Sev1 DB2 performance crisis for Confidential via a targeted WLM service policy change, and have opened and closed numerous PMRs with Confidential Support Center.
• Have led an upgrade of 20 DB2 subsystems from V11 CM RSU1605 BASIC RBA to DB2 V12 FL50x EXTENDED RBA for Confidential customer Confidential of MI. Also assigned as Instructor/Mentor of a group of Confidential GTS DB2 Systems Programmers.
• Most recently resolved a complicated cross-loaded DB2 Lmod situation left by a legacy predecessor causing 04E abends, solved via dump analysis, MEPL report, and trouble-shooting skills. Frequent Webex host demonstrating technical Issues and systems programming instruction to other IBMers at both a junior and senior level, with DB2 Systems and also with disparate Z/OS components such as WLM, SLIP traps, LLA/VLF, SMS/ACS, USS, and GRS. Sr Performance/Tuning SME, Sr DB2 Systems SME, also Confidential Instructor in Advanced DB2 Systems.

Confidential, Santa Clara

Senior DB2 Systems Programmer

Responsibilities:

• Served as DB2 technical lead as a consultant under contract for a Z/OS 2.1 and DB2 V11 NFM system in a System z environment.
• Rewrote WLM Service Policy in a resource-constrained environment.
• Implemented system upgrade from DB2 V10 to V11.
• Ordered, received, and applied Confidential maintenance via SMP/E.
• Completely revamped Library LookAside(LLA) procedures to implement LLA/VLF.
• Redesigned DB2 bufferpool scheme in use for better performance.
• Implemented new DB2 workfile design for more efficient performance.
• Reviewed and corrected transaction performance issues as revealed by OMG/DB2 and RMF.
• Analysis and correction of numerous DB2 inefficiencies in both application threads and ZParms.
• Implemented new buffer settings for EDM, SKPT, SORT, and DYNCACHE after intensive performance analysis.
• Involved in implementing CICS thread resuse in DB2 and various other aspects of DB2 performance tuning.
• Designed Flashcopy solution to unacceptably slow DB2 Utility Suite reorgs of large tables and indexes.
• Identifed cause and solution to long-time and severe DB2 performance issue involving table/index maintenance negatively affecting CICS transaction response times.
• Several bare-metal DR system restores, including one non-exercise production DB2 subsystem after an I/O error corrupted a BSDS.

Confidential

Senior Z/OS and DB2 Systems Programmer

Responsibilities:

• Served as technical lead as a consultant under contract for a Z/OS 1.13 and DB2 V10 NFM system in a z12 EC sysplex environment.
• Completely rewrote WLM Service Policy in a resource-constrained environment after reviewing numerous performance metrics and statistics pertaining to Z/OS, DB2, MQ, and CICS TS/CICS TG.
• Supervised maintenance plan for system upgrade to Z/OS 2.1 and DB V11.
• Rewrote GRS RNLDEFs to eliminate HW RESERVEs after installing and monitoring ISGAUDIT.
• Implemented plan to convert HASP(JES2) CKPT1 to Coupling Facility.
• Primary initiator of conversion of ICF engine to zIIP usage.
• Completely revamped Library LookAside(LLA) procedures to implement FREEZE in CSVLLAxx, and installed and monitored Module Fetch Monitor (MFM).
• Identified and corrected a significant misconfiguration in a CICS TS File Owning Region (FOR) that involved incorrect CISIZE and LSR buffer specifications.
• Identified and corrected inefficient CISIZEs that reduced the SMF I/Os by 75% in the SYS1.MANx datasets.
• Identified and initiated plan to correct grossly excessive ViewDirect(VDT) program fetches involving LE SCEERUN2 through analysis of Mainview I/O and program traces.
• Identified application batch job inefficiencies driving excessive CPU consumption in the CATALOG address space.
• Analysis and correction of numerous DB2 inefficiencies in both application threads and ZParms.
• Involved in implementing High Performance (HP) DBATs in DB2 and various aspects of DB2 performance tuning.
• Completely revamped LLA/VLF caching mechanism including reviewing LLA system exit usage.

Confidential

Senior DB2 and Z/OS Systems Programmer

Responsibilities:

• Served as technical leader for a DB2 V9 to V10 migration effort in a z10 sysplex environment involving multiple DB2 data-sharing groups.
• In addition to performing all technical upgrade activity for DB2 V10, coordinated with DBAs and development groups to effect migration of the DB2 environment to DB2 10 for Z/OS NFM, serving as the primary DB2 technical SME.
• In addition, performed necessary upgrades to program products such as Insight/DB2, Fileaid/DB2, and a variety of BMC utility products.
• Completely revamped the site existing Disaster Recovery scripts and procedures, and successfully performed a bare-metal DR recovery of the entire production DB2 subsystem at an Confidential disaster recovery site while operating as the site’s sole DB2 systems programming resource.
• Reviewed and recommended many changes to the existing configuration, ranging from reconfiguring Coupling Facility structures and settings, to changes in WLM policy, Bufferpools and Group Buffer Pools, and WLM-managed stored procedure address space creation.
• Installed, maintained, and customized a DB2 10 for Z/OS environment ranging from V9 toleration PTFs to a successful implementation of V10 New Function Mode in the production environment from DB2 V9 NFM.

Confidential

Senior Z/OS and DB2 Systems Programmer

Responsibilities:

• Served as Dual Z/OS and DB2 Sr. SysProg.
• Worked on Z/OS 1.10 software upgrade to Z/OS 1.12 level on a z10-196, and of numerous program product software packages in support of that OS level.
• Responsible for HMC remote troubleshooting, DASD, zIIPs, HiperPAV, Crypto, in addition to DB2 Sysprog responsibilities.
• Maintained multiple DB2 data-sharing groups. Involved in DB2 V10 migration planning, preparation, and execution.
• Heavily involved in both local and group DB2 Buffer Pool tuning, along with DASD I/O tuning. SMS customization and support of storage environment.
• DFHSM support with VTL/ATLs. Secondary Data Center (DR site) location planning and testing activities. Z/OS 1.10/DB2 V9 support.
• Responsible for complete redesign of WLM policy for production systems.
• Heavy involvement with real-time and historical monitoring systems for Z/OS, DB2, and CICS. Served as SME for comprehensive performance and tuning activities, plus Level 3 support of troubleshooting Z/OS and DB2 problems in addition to the usual installation, maintenance and customization activities for both Z/OS and DB2. SME for Coupling Facility(Sysplex) configuration, monitoring, and tuning.

Confidential

Senior DB2 and Z/OS Systems Programmer

Responsibilities:

• Member of team that upgraded Z/OS 1.9 software to Z/OS 1.12 level, and numerous program product software packages in support of that OS level.
• Installed and maintained multiple DB2 V9.1 data-sharing groups.
• Involved in DB2 V10 planning and preparation.
• Worked closely with SAP BASIS team on SAP V7 / DB2 V9.1 performance and operational issues.
• Worked closely with over-seas DBAs on DB2 problems.
• Heavily involved in both local and group DB2 Buffer Pool tuning. SMS customization and support of storage environment, especially implementation of DB2-managed allocations and BACKUP SYSTEM implementation.
• Data Center relocation planning activities. Z/OS 1.9 support, with involvement in present Z/OS 1.12 upgrade.
• Involvement in IRD conversion planning on z10 CECs containing 20 LPARs.

Confidential

Senior Z/OS Systems Programmer

Responsibilities:

• Responsible for systems programming activities in a large z9 and z10 multiple Sysplex environment at Confidential, primarily in the area of DB2 V9, Z/OS, CICS, WAS, and DASD performance.
• Responsible for resolving developing performance problems in the areas of Coupling Facility, DB2 V9, Z/OS 1.10, WLM policies(service class configuration), CICS, IRD, zAAPs, zIIPs, Websphere Application Server, and DASD performance, then devising proactive and effective solutions to performance problems.
• Heavily involved with Coupling Facility configuration and performance with multiple large Sysplexes at SSA.
• Directly responsible for a Coupling Facility hardware configuration change at SSA that cut in half the response time of a mission-critical CICS/DB2 transaction that was CF-bound.
• This was accomplished by my redesign of the SSA data center so that ICB-4 links could be utilized instead of the previous ISC-3 links. DB2 Cache and Lock structures were closely monitored for negative anomalies such as high SYNC times, Dir Reclaims, and NOSCH conditions.
• Close attention was paid to parameters for DB2 local buffer pools that affected the Group Buffer Pools that exist in the Coupling Facility, such as Castouts, XIs, and page residency times.
• When performance anomalies were noted, I was responsible for designing fixes for SSA. Heavily involved in monitoring and fixing DB2 performance problems.
• Omegamon, Spufi, QMF, CA-Detector, DB2 Perf Expert, RMF Spreadsheet Reporter, Buffer Pool Tool for DB2, along with many other standard DB2 utilities were used to check tablespaces, indexspaces, catalog statistics, Zparms and bind options.
• A particular area of expertise is catching and analyzing problematic dynamic SQL statements, with alternative statement coding and index changes suggested to programmers after EXPLAIN and Catalog analysis. Another area of extensive expertise is buffer pool tuning, both local and global.