Mainframe DB2 System Programmer SME

Overview

Mainframe DB2 System Programmer SME responsible for installing, maintaining and supporting IBM DB2 z/OS systems and solving complex problems across platforms and services.

What you'll do

• Install and maintain IBM DB2 z/OS software and related 3rd-party products using SMP/E.
• Work with IBM and other vendors to address product defects, issues and usage questions.
• Configure DB2 groups and subsystems in SYSPLEX data-sharing environments, supporting mainframe DB2 applications.
• Perform problem analysis and resolution for mainframe DB2 system related issues.
• Tune system parameters and resources for performance and capacity using various monitoring and reporting tools.
• Be responsible for DB2 subsystem availability, backup and recovery strategies and procedures, and DR tests.
• Maintain the DB2 Catalog, Directory and other DB2 system objects.
• Document policies and procedures.
• Provide secondary support for the DBA staff on DB2 subsystem issues.
• Provide security services in regards to the systems support role for DB2.

What you'll need

• 7+ years IBM System Z experience and concepts.
• Administration and tooling: software installation via SMP/E, along with database management and performance optimization using IBM, BMC, and Broadcom toolsets.
• Distributed access and security: remote client/application connectivity via DDF and DRDA, integrated with RACF, ACF2, or TopSecret access control.
• Storage, DR and 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.
• Memory and internal structures: buffer pools, page and tablespace layouts, and DB2 internal components (EDM pool, RIDs).
• Data sharing, logging and availability: data sharing sysplex management, ZPARMS configuration, and backup, recovery and logging strategies.
• Concurrency and performance diagnostics: lock/latch contention management, IFCID tracing, and performance monitoring.
• Experience in problem determination and analysis.
• Analytical, critical and outside-the-box thinking in problem solving, especially in critical, high-pressure situations.

Nice to have

• 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.

Details

• Location: Chennai, Tamil Nadu, India.
• Hybrid-friendly work environment.