Mainframe DB2 System Programmer SME

Job Summary


Responsibilities

• Installation/maintenance of IBM DB2 z/OS software and related 3rd-party products utilizing SMP/E. This includes working with IBM and other vendors to address product defects, issues, and usage questions.
• Configuration of DB2 groups and subsystems in SYSPLEX data-sharing environment, supporting mainframe DB2 applications.
• Perform problem analysis and resolution for mainframe DB2 system related issues.
• Performance and capacity tuning of system parameters and resources, utilizing various monitoring and reporting tools. Currently a separate team (PCM) handles this at Kyndryl.
• Responsible for the DB2 subsystem availability, backup and recovery strategies and procedures. DR tests.
• Maintain the DB2 Catalog, Directory and other DB2 system objects.
• Documentation of policies and procedures.
• Provide secondary support for the DBA staff on DB2 subsystem issues.
• Security services in regards to systems support role for DB2.

Required Technical and Professional Expertise

• 7+ years IBM System Z experience and concepts, with considerable knowledge in the following:
  • Administration tooling: software installation via SMP/E, along with database management and performance optimization using IBM, BMC, and Broadcom toolsets.
  • Distributed access security: remote client/application connectivity via DDF and DRDA, integrated with RACF, ACF2, or TopSecret access control.
  • Storage, DR architecture: FLASH copy, DASD replication, DB2 forward recovery, z/OS storage management, Coupling Facility, networking (TCP/IP, SNA), WLM, and USS.
• 5+ years IBM DB2 experience, with advanced knowledge in the following:
  • Memory internal structures: buffer pools, page and tablespace layouts, and DB2 internal components (EDM pool, RIDs).
  • Data sharing, logging availability: data sharing sysplex management, ZPARMS configuration, and backup, recovery, and logging strategies.
  • Concurrency performance diagnostics: lock/latch contention management, IFCID tracing, and performance monitoring.
• Experience in problem determination and analysis
• Analytical / critical / outside-the-box thinking in problem solving, especially in possible critical, high-pressure situations.

Preferred Technical and Professional Experience

• Bachelor's degree in computer science or a related field.
• BMC Mainview For DB2, IBM Omegamon for DB2
• IBM Query Monitor for DB2
• Java, web services, SOA concepts
• REXX programming

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.