Job Description
o
Must Have Skills:
Evaluate
n and implement new features/functions of DB2 and associated third party
n products.
n
o Extensive use of utilities
n and Performance Monitoring tools using BMC, CA and IBM products.
n
o Consultant on DB2 database
n applications architecture
n
o Knowledge of SMP/E and can
n prepare for and apply maintenance to a DB2 subsystem
n
o Engineer and execute the
n processes to upgrade and/or apply maintenance to releases / versions of
n mainframe database system software, and associated third party products
n
o Maintain DSNZPARMs
n
Nice to Have Skills:
Skill:
Mainframe DB2
n System Programmer
n
Job
n Description:
n
We are looking for DB2 Systems
n Programmer, who will be part of a Global team responsible for building,
n configuring and maintaining the Bank's mainframe systems. Currently we are
n running the largest parallel SysPlex in the Nordic region. Our primary design
n goals are service availability, efficiency and resilience, underpinned by the
n architectural principle of cloned infrastructure, system configurations and
n applications. Job Responsibilities
n
o Maintain DSNZPARMs
n
o Implement automated disaster
n recovery mechanisms for Mainframe Database subsystems and associated third
n party products. Participate in all
n recovery coordination activities
n
o Create & modify WLM
n address spaces for stored procedures as needed
n
o Database security management
n
o Backup/Recovery strategies
n
o Strategy Reviews
n
o Scalability Analysis
n
o Database Architecture design
n strategy
n
o Planning Database maintenance
n window
n
o Capacity planning
n
o Monitor and troubleshoot DB2
n address spaces for any potential issues
n
o DB2 Database configuration
n across difference Mainframe LPARs.
n
o Prepare and execute
n housekeeping strategies for the DB2 Catalog and Directory.
n
o Implement security strategy




n for DB2 via RACF.
n
o Troubleshoot Level 3 DB2
n Database issues.
n
o Provide Level 3 support to
n
troubleshoot/resolve
system level and application problems with DB2 Database
n technologies and associated Third Party products – coordinate
n
escalation/intervention
with vendor as necessary.
n
o Strong experience of
n installing, customizing and maintaining Mainframe DB2 and ISV products
n
o Strong experience managing
n Q-replication and IBM DB2 Data Analytics accelerator product suite
n
o Strong experience working with large data
n sharing SysPlex environment
n
o Hands-on experience of managing system
n operations, problem diagnosis, performance tuning in both system and
n application arena
n
o Good experience with IBM DB2
n Utilities, Disaster recovery and system restoration
n
· Install, upgrade and administer mainframe DB2 and DB2 related
n tools software.
n
· Assist with testing, implementation and installation of new or
n improved systems, as well as product upgrades.
n
· Good knowledge on DB2 migrations and upgrades for DB2 V12.1 and
n V13.1 versions.
n
· Good Knowledge on Problem diagnosis related to DB2 and their DB2
n tools products.
n
· Strong DB2 system programming skill, DB2 recovery, maintain system
n objects and ZPARM parameter configuration.
n
· Good knowledge of DB2 tools installation and upgrades for IBM
n utilities, Broadcom products.
n
· Experience in SMPE knowledge of RSU maintenance apply procedures.
n
· Experience in JCL, ISPF, DB2 related products, WLM and stored




n procedures
n
· Knowledge of performance monitoring and troubleshooting DB2
n issues.
n
· Strong skill set must be needed on DB2 data sharing experience and
n failover process.
n
· Good knowledge of Disaster recovery of DB2 systems includes
n traditional DR and flash copy DR.
n
· Interact with ticketing tool remedy, service center and other
n business support areas for problem escalations, resolutions, reporting and
n coordination.
n
· Attend meetings and interact regularly with management, team and
n clients to continuously improve services. Provide 24*7 support if needed on
n the project support.
n
Detailed Job Description:
JD – For
n Heith replacement
n
n
n
Should
n have experience in Mainframe CICS and MQ environment for 10+ years.
n
Support
n the operations of the Mainframe CICS
infrastructure(CICS
& MQ
n series).
n
Well
n versed with CICS resource definitions online(terminals, programs,
n bundles etc.), defining current CICS regions etc.
n
Experience
n in upgrade of CICS TS from lower version to higher version.
n
Knowledge
n on CICS Transaction Gateway and CICS webservices and CICSplex Operations
n
Experience
n in vendor product install / upgrade and applying PTF for maintenance
n
CICS
n SSL Setup Troubleshooting
n
Experience
n in CICS Monitoring Tools - CA SYSVIEW / Omegamon / Mainview etc.
n
Well
n versed with CICSPLEX Setup (CMAS), MRO region Setup and troubleshoot
n related issues.
n
Experience
n and strong knowledge as a Websphere MQSeries on z/OS v7.1 / v9.0
n
Install
n new releases, apply PTFs to Webshere MQ on z/OS
n
Well
n versed with MQ Clustering and MQ
Objects/Channels/Queues
n
Experience
n with upgrading IBM MQ for z/OS will be added advantage.
n
z/OS
n connect
n
zIOA
n installation and configuration
n
n

📌 Lead Consultant- Db2 On Mainframe (Melbourne)
🏢 XPT Software Australia Pty
📍 Melbourne