IBM DB2 Subsystem Systems Programmer

$100,000 - $120,000/Yr

IMRI Technology & Engineering Solutions - Los Angeles, CA

Full-time - Mid Level

Los Angeles, CA

About the position

The IBM DB2 Subsystem Systems Programmer will be responsible for managing, maintaining, and optimizing DB2 and IMS database subsystems on IBM mainframe platforms. This role is crucial for ensuring the reliability and performance of database systems, requiring a strong background in DB2 system software, disaster recovery, and technical documentation.

Responsibilities

• Install, upgrade, and maintain system software for DB2/IMS databases and related subsystem products.
• Perform SMP/E tasks to support and maintain required DB2/IMS products and ensure timely updates.
• Manage database subsystem resources to ensure availability and reliability.
• Execute recovery procedures for database subsystem resources as needed.
• Provide regular status updates and reports on the health of database subsystems upon request.
• Perform DB2 recoveries caused by hardware failures, focusing on DB2 system objects such as catalogs and directory tables.
• Deliver disaster recovery support for DB2 database software and system objects, maintaining technical procedures and documentation for disaster recovery scenarios.
• Configure utility jobs (e.g., image copies, reorganizations) for new DB2 system objects.
• Conduct DB2 subsystem performance tuning, capacity planning, and optimization of resources such as buffer pools, logging, EDM pools, and ZPARM settings.
• Schedule and support reorganization activities for non-application DB2 objects, including catalogs, directories, and third-party product databases.

Requirements

• Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience).
• Proven experience in IBM DB2/IMS systems programming, including subsystem installation, upgrades, and maintenance.
• Hands-on experience with SMP/E processes.
• Expertise in database performance tuning, capacity planning, and recovery procedures.
• Deep knowledge of DB2 on z/OS platforms.
• Strong understanding of DB2 utilities, buffer pools, logging, EDM pools, and ZPARM settings.
• Familiarity with disaster recovery practices and tools.
• Proficiency in technical documentation and procedure development.
• Strong analytical and problem-solving abilities.
• Excellent communication skills for status reporting and cross-functional collaboration.
• Ability to manage multiple tasks and projects in a dynamic environment.

Nice-to-haves

• Certification in IBM DB2 or related database technologies.
• Experience with third-party database products and tools.
• Familiarity with IMS database subsystems.

Benefits

• Medical coverage through nationally recognized carriers.
• Ancillary coverages.
• Paid vacation and sick leave in compliance with all state and local laws.
• 401(k) with company match.
• Company paid life insurance and LTD.
• Several additional voluntary coverages.