Mainframe DB2/ZOS DBA specialist

Job Title: Mainframe DB2/ZOS DBA specialist
Contract Type: Contract
Location: Canberra, Australian Capital Territory
Salary: Negotiable
Start Date: ASAP
Reference: 206722_1606791214
Contact Name: Priya Kuncham
Contact Email:
Job Published: December 01, 2020 13:53

Job Description

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.

Skills required for the role:

  • 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
  • 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

Due to security clearance requirements for this role, candidates must be Australian Citizens who are able obtain a Federal Government Security Clearance.

Apply now for immediate consideration - contact Priya Kuncham on 02 6245 1730 quoting Job Reference: 206722

Please note: only candidates that meet the above criteria will be contacted. Thank you for your interest in the position.

Get similar jobs like these by email

By submitting your details you agree to our T&C's