DB2 Systems Programmer Resume Profile

TECHNICAL SKILLS

z/OS, DB2, SAP, CICS, WORKLOAD MANAGER, QMF, DROP, QREP, XCF, Coupling Facility, Assembler, SQL, SAS, SMPE, SMF, RMF, JCL, TSO, IPCS, FDR, OMEGAMON, MAINVIEW and several other CA, BMC RESPONSIVE SYSTEMS tools

PROFESSIONAL EXPERIENCE

Confidential

Sr. DB2 Systems Programmer

The production environment consisted of Data Sharing groups of several sizes from a few 3-way to several 12-way Data Sharing groups spread throughout the US and UK.
Led/assisted in several DB2 migrations from V6 until the latest V10, as well as applied maintenance across multiple DB2 versions.
DB2 installation, Capacity Planning, System Performance and Disaster Recovery
Responsible for DB2 system tuning of over 190 subsystems spread throughout the US and UK.
Assisted in the redesign/consolidation strategies of LPARs in a sysplex data sharing environment.
Worked closely with z/OS specialists to design WLM policies and insure that enclaves from different DB2 workloads had classifications according to their SLAs.
Worked closely with z/OS specialists in problem determination analysis of CPU and DASD delays. Specialty engines DB2 usage was monitored closely across all lpars.
Designed and maintained local group buffer pools of all production Data-sharing environments.
Buffer pools were set according to the different characteristics of the workloads. Analyzed local pools' behavior and page fixed I/O intense buffer pools.
Worked with DBA team to identify rogue workloads which had intense tablespace scans. Page residency time was used to size local pools. This insured a minimum consumption of virtual storage while providing a robust pool configuration. This strategy took into account the ability of surviving members to absorb the workload of a failed subsystem.
Group buffer pools were sized to avoid cross-invalidations due to directory reclaims. GBPs synchronous hit ratios were monitored closely.
GBP's internal thresholds were adjusted to provide a trickle writing effect.
Lead the resolution process of complex database systems problems where analysis of situations or data requires an in-depth evaluation of various factors.
Reviewed and updated zparms across different DB2 versions with the objective of tuning systems.
Pseudo-closing was monitored constantly to avoid high number of latch counters and unnecessary messages sent to the Coupling Facility, thus avoiding CF overhead. This provided a faster throughput for batch workloads.
Package authorization cache and caching routine authorization high misses rates were corrected by adjusting CACHERAC and CACHEPAC values.
Implemented a DB2PM Statistics Performance Database to be used for trend reports and problem determination.
Several SQL queries were automated to help identify possible performance issues.
Implemented a DB2PM Accounting Performance database to be loaded only for problem determination reasons.
Lead and participate in the design, development, and implementation Bank of America's DB2 Disaster Recovery strategy.
Sized DB2 pools in large Data Sharing group to allow surviving members to absorb the workload of failing members.

Confidential

Consultant

Provided guidance on DB2 system performance on a large SAP/DB2 configuration
Worked with SAP Basis Administrators to adjust DB2 internal parameters to accommodate the workload
Used page residency time to size local pools properly
Monitored group buffer pools to avoid cross-invalidation and maintain a high synchronous hit ratios
Interfaced with MVS Systems programmers to design WLM policies
Assisted on LPAR, number of processors and weights configuration
Lead migration from OS/390 DB2 V6 to V7
Applied DB2 maintenance

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship