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
Scalability Analysis
Planning Database maintenance window
Capacity planning
Monitor and troubleshoot DB2 address spaces for any potential issues
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 workplace
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.
Must Have Skills:
Evaluate and implement recent 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
#J-*****-Ljbffr

📌 Mainframe Db2 System Programmer (Melbourne)
🏢 Ampstek
📍 Melbourne