Mainframe DB2 System Site Administrator (Melbourne / Sydney) Only

Hi
Role: Mainframe DB2 System Site AdministratorLocation: 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 architectureKnowledge of SMP/E and can prepare for and apply maintenance to a DB2 subsystemEngineer and execute the processes to upgrade and/or apply maintenance to releases / versions of mainframe database system software, and associated third party productsMaintain DSNZPARMs
Job Description
Maintain DSNZPARMsImplement automated disaster recovery mechanisms for Mainframe Database subsystems and associated third party products. Participate in all recovery coordination activitiesCreate & modify WLM address spaces for stored procedures as neededDatabase security managementBackup/Recovery strategiesStrategy ReviewsScalability AnalysisDatabase Architecture design strategyPlanning Database maintenance windowCapacity planningMonitor and troubleshoot DB2 address spaces for any potential issuesDB2 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 productsStrong experience managing Q-replication and IBM DB2 Data Analytics accelerator product suiteStrong experience working with large data sharing SysPlex environmentHands-on experience of managing system operations, problem diagnosis, performance tuning in both system and application arenaGood experience with IBM DB2 Utilities, Disaster recovery and system restorationInstall, 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 proceduresKnowledge 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.
RegardsJamesLead APAC Recruiter | Amsptek LLCCell: +61862450617Email: James@ampstek.com