About the Team
The role is within our client's Enterprise Solutions and Technology business line, within the Infrastructure Services branch of Service Operations. The Mainframe Delivery Centre (MDC) is part of the Infrastructure Services Branch. The Mainframe Environment Services team within MDC is responsible for delivering quality and timely mainframe services to Application Developers, Testers and production support teams. The team is based in Canberra.
About the Role
We are looking for a hands on, experienced, technical Mainframe DB2/ZOS DBA specialist. The ideal candidate would have immediate hands on technical skills and would not require Mainframe DB2/ZOS database administration training - other than local site and tool familiarization.
You will have
- Able to articulate their advanced knowledge of Mainframe DB2/ZOS database administration and apply it independently in complex situations, understanding the why
* Generating and executing DDL scripts to create, change and drop database objects in any environment from Development to Production
and more importantly, understand the issues, challenges and risks when doing that
o Familiarity with CA-DMS toolset would be an advantage
* Very comfortable with working with many millions (if not billions) of rows of data in a single table
* Understands and can execute tablespace/index reorganization process and candidate selection
* Understands and can articulate the different tablespace types and their relative advantages and disadvantages (including V12); and how to migrate between them.
* Soon ready to participate in an on-call roster (1 in 5 weeks) for production support, and be confident to independently troubleshoot complex situations including recovering dropped objects
* Access path, SQL and Indexes Tuning
* Skills in SAS and/or Rexx to maintain and enhance automation processes
* Database Job scheduling experience - Knowledge of TWS/OPC would be an advantage
* Experience in the use and/or installation of Db2 Connect and Data Studio would be an advantage
* An advantage If you have other z/OS experience such as MQ/CICS/zOS or other tools in terms of usage and customisation.
For more information or to apply, please contact Ateet Jaiswal on 02 6245 1707 quoting Job Reference: 243030
