Hi

Role: Mainframe DB2 System Site Administrator

Location: Melbourne / Sydney

Contract

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

- 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.
- Solid 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.

Regards

James

Lead APAC Recruiter | Amsptek LLC

Cell: +61862450617

Email: [email protected]

📌 MainframeSystem Site Administrator (Melbourne / Sydney) Only
🏢 Ampstek
📍 Sydney