Mainframe DB2 DBA And Mainframe DB2 Systems Programmer

Position Overview:

We are seeking a seasoned Mainframe DB2 DBA with 5 8 years of hands-on experience to support, maintain, and optimize mission-critical DB2 for z/OS databases. This role requires deep technical knowledge of DB2 internals, high availability architecture, performance tuning, disaster recovery, and database security.

Key Responsibilities:

• Administer, maintain, and optimize DB2 for z/OS environments to ensure performance, availability, and security.

• Implement DB2 backup and recovery strategies (Image Copy, Recovery, REORG, COPY, LOAD).

• Work closely with DB2 Systems Programmers to install, patch, and configure DB2.

• Perform performance tuning (SQL optimization, buffer pool tuning, index analysis).

• Troubleshoot DB2-related issues and provide root-cause analysis.

• Monitor and analyze database health using DB2 tools and SMF metrics.

• Collaborate with application development teams for schema design and query optimization.

• Support application upgrades, data migrations, and release deployments.

• Participate in disaster recovery and business continuity planning/testing.

• Maintain audit and compliance with internal and regulatory standards.

Required Skills:

• 5 8+ years of Mainframe DB2 for z/OS DBA experience.

• Deep understanding of DB2 internals, DCL, DML, and DDL.

• Experience with utilities such as REORG, RUNSTATS, LOAD, UNLOAD, COPY.

• Hands-on experience with RACF, DB2 security, and access control.

• Expertise with DB2 monitoring tools (OMEGAMON, CA Insight, or BMC).

• Strong understanding of SQL performance tuning and index optimization.

• Experience with JCL, REXX, and TSO/ISPF.

• Excellent documentation, communication, and troubleshooting skills.

• Willingness to provide on-call support and respond to after-hours emergencies.

---

Position Overview:

We are looking for an experienced DB2 System Programmer to join our enterprise infrastructure team. The role includes the installation, customization, maintenance, and upgrade of IBM DB2 for z/OS subsystems. The candidate will work across infrastructure, security, operations, and application teams to ensure a stable, secure, and high-performing DB2 environment.

---

Key Responsibilities:

• Install, upgrade, and configure IBM DB2 for z/OS and related tools (BMC, IBM, CA).

• Perform DB2 subsystem tuning and maintenance of buffer pools, WLM, zPARMs.

• Apply IBM and vendor PTFs, APARs, and service packs using SMP/E.

• Customize and configure DB2 exit routines, data sharing, and disaster recovery.

• Troubleshoot DB2 subsystem errors and analyze abends and logs.

• Support DB2 connectivity (DRDA, DDF, TCP/IP), and manage distributed access.

• Collaborate with DBA, system, and application teams during release planning.

• Ensure SLA compliance through system performance monitoring and optimization.

• Participate in disaster recovery and capacity planning initiatives.

• Provide detailed documentation for processes, upgrades, and system architecture.

---

Required Skills:

• 5 8+ years as a Mainframe DB2 Systems Programmer.

• Expert knowledge of DB2 architecture, SMP/E, IBM PTF management.

• Experience with subsystem configuration and tuning (IRLM, WLM, DDF).

• Knowledge of z/OS environments, JES2, VTAM, TCP/IP configuration.

• Familiarity with performance monitoring tools (OMEGAMON, RMF, SMF).

• Experience with high availability, Sysplex, and data sharing groups.

• Strong scripting skills in REXX, CLIST, and shell scripting.

• Excellent problem-solving and communication skills.

• Willing to work flexible shifts and be available for on-call rotation.