Senior Mainframe Db2 Systems Programmer

Xpt Software Australia Pty; City of Melbourne; On-site; AUD 150,000 - 210,000; Full time

Job summary

Xpt Software Australia Pty seeks a seasoned DB2 Systems Programmer to join a global team responsible for building, configuring and maintaining the Bank’s mainframe DB2 environments. You will manage DSNZPARMs, DR planning, and performance tuning across z/OS with strong CICS and MQ integration.

Ideal candidates have extensive DB2 subsystem maintenance experience, SMP/E familiarity, and a track record of upgrading DB2 and related tools in large SysPlex environments.

Qualifications

• Must have experience evaluating and implementing new features/functions of DB2 and third party products.
• Extensive use of performance monitoring tools (BMC, CA and IBM products).
• Consultant on DB2 database applications architecture.
• Knowledge of SMP/E and applying maintenance to a DB2 subsystem.
• Engineer and execute upgrades/maintenance to DB2 and related tools.
• Maintain DSNZPARMs.

Responsibilities

• Maintain DSNZPARMs.
• Implement automated disaster recovery mechanisms for Mainframe DB2 subsystems and related third party products.
• Create & modify WLM address spaces for stored procedures as needed.
• Database security management.
• Backup/Recovery strategies.
• Strategy reviews.
• Scalability analysis.
• Database architecture design strategy.
• Plan database maintenance windows.
• Capacity planning.
• Monitor and troubleshoot DB2 address spaces.
• DB2 configuration across Mainframe LPARs.
• Prepare and execute housekeeping for DB2 Catalog/Directory.
• Implement security for DB2 via RACF.
• Troubleshoot Level 3 DB2 issues.
• Provide Level 3 support to troubleshoot system and application problems with DB2
• Coordinate with vendors as needed.
• Hands-on experience managing system operations and performance tuning.
• Experience with IBM DB2 Utilities, DR, and system restoration.
• Install, upgrade and administer mainframe DB2 and related tools.
• Assist testing and installation of new systems and product upgrades.
• Experience with DB2 migrations/upgrades for V12.1 and V13.1.
• Strong DB2 system programming, recovery, and ZPARM configuration.
• Knowledge of DB2 tools installation/upgrades for IBM utilities and Broadcom products.
• SMPE RSU maintenance procedures experience.
• Experience with JCL, ISPF, DB2 products, WLM and stored procedures.
• Knowledge of performance monitoring and troubleshooting DB2 issues.
• Strong DB2 data sharing experience and failover processes.
• DR for DB2 systems including traditional and flash copy DR.

Skills

DB2 Systems Programming

Mainframe DB2

CICS expertise

MQ Series

SMP/E knowledge

RACF security

DSNZPARMs management

JCL/ISPF

WLM tuning

ZPARM configuration

SMPE maintenance

Tools

CA SYSVIEW

Omegamon

Mainview

IBM MQ for z/OS

RSU maintenance tools

DB2 Utilities

Job description

Job Description

Job Details:

• Must Have Skills: Evaluate and implement new features/functions of DB2 and associated third party products.
• Extensive use of utilities and Performance Monitoring tools using BMC, CA and IBM products.
• Consultant on DB2 database applications architecture
• Knowledge of SMP/E and can prepare for and apply maintenance to a DB2 subsystem
• Engineer and execute the processes to upgrade and/or apply maintenance to releases / versions of mainframe database system software, and associated third party products
• Maintain DSNZPARMs

Nice to Have Skills: Skill: Mainframe DB2 System Programmer

We are looking for DB2 Systems Programmer, who will be part of a Global team responsible for building, configuring and maintaining the Bank’s mainframe systems. Currently we are running the largest parallel SysPlex in the Nordic region. Our primary design goals are service availability, efficiency and resilience, underpinned by the architectural principle of cloned infrastructure, system configurations and applications.

Job Responsibilities

• Maintain DSNZPARMs
• Implement automated disaster recovery mechanisms for Mainframe Database subsystems and associated third party products. Participate in all recovery coordination activities
• Create & modify WLM address spaces for stored procedures as needed
• Database security management
• Backup/Recovery strategies
• Strategy Reviews
• Scalability Analysis
• Database Architecture design strategy
• Planning Database maintenance window
• Capacity planning
• Monitor and troubleshoot DB2 address spaces for any potential issues
• DB2 Database configuration across difference Mainframe LPARs.
• Prepare and execute housekeeping strategies for the DB2 Catalog and Directory.
• Implement security strategy for DB2 via RACF.
• Troubleshoot Level 3 DB2 Database issues.
• Provide Level 3 support to troubleshoot/resolve system level and application problems with DB2 Database technologies and associated Third Party products – coordinate escalation/intervention with vendor as necessary.
• Strong experience of installing, customizing and maintaining Mainframe DB2 and ISV products
• Strong experience managing Q-replication and IBM DB2 Data Analytics accelerator product suite
• Strong experience working with large data sharing SysPlex environment
• Hands‑on experience of managing system operations, problem diagnosis, performance tuning in both system and application arena
• Good experience with IBM DB2 Utilities, Disaster recovery and system restoration
• Install, upgrade and administer mainframe DB2 and DB2 related tools software.
• Assist with testing, implementation and installation of new or improved systems, as well as product upgrades.
• Good knowledge on DB2 migrations and upgrades for DB2 V12.1 and V13.1 versions.
• Good Knowledge on Problem diagnosis related to DB2 and their DB2 tools products.
• Strong DB2 system programming skill, DB2 recovery, maintain system objects and ZPARM parameter configuration.
• Good knowledge of DB2 tools installation and upgrades for IBM utilities, Broadcom products.
• Experience in SMPE knowledge of RSU maintenance apply procedures.
• Experience in JCL, ISPF, DB2 related products, WLM and stored procedures
• Knowledge of performance monitoring and troubleshooting DB2 issues.
• Strong skill set must be needed on DB2 data sharing experience and failover process.
• Good knowledge of Disaster recovery of DB2 systems includes traditional DR and flash copy DR.
• Interact with ticketing tool remedy, service center and other business support areas for problem escalations, resolutions, reporting and coordination.
• Attend meetings and interact regularly with management, team and clients to continuously improve services. Provide 24*7 support if needed on the project support.

Detailed Job Description

JD – For Heith replacement

• Should have experience in Mainframe CICS and MQ environment for 10+ years.
• Support the operations of the Mainframe CICS infrastructure(CICS & MQ series).
• Well versed with CICS resource definitions online(terminals, programs, bundles etc.), defining new CICS regions etc.
• Experience in upgrade of CICS TS from lower version to higher version.
• Knowledge on CICS Transaction Gateway and CICS webservices and CICSplex Operations
• Experience in vendor product install / upgrade and applying PTF for maintenance
• CICS SSL Setup Troubleshooting
• Experience in CICS Monitoring Tools - CA SYSVIEW / Omegamon / Mainview etc.
• Well versed with CICSPLEX Setup (CMAS), MRO region Setup and troubleshoot related issues.
• Experience and strong knowledge as a Websphere MQSeries on z/OS v7.1 / v9.0
• Install new releases, apply PTFs to Webshere MQ on z/OS
• Well versed with MQ Clustering and MQ Objects/Channels/Queues
• Experience with upgrading IBM MQ for z/OS will be added advantage.
• z/OS connect
• zIOA installation and configuration