Database Administrator (Db2)

Application closing date: Friday, 12 April 2024 • 11:59pm, Canberra time (in Canberra)

Estimated start date: Wednesday, 01 May 2024

Location of work: ACT

Working arrangements: All work is to be undertaken at Services Australia's Canberra office.

Length of contract: 12 months

Contract extensions: 2 x 12 months

Security clearance: Must have Negative Vetting Level 1

Rates: $120 - $170 per hour (inc. super)

Services Australia is seeking a Db2 Database Administrator to work on the migration of ObjectStar Table data store to DB2 on Z/OS; design, maintenance and optimising DB2 databases; and upgrading DB2 to V13. Database Administrator Experts will engage in scoping, sourcing, and optimising database environments for analysis.

They will apply innovative analysis techniques and model results and scenarios, while maintaining the integrity of the system. The Database Administrator Experts will be proficient with system databases, data elements, application software, and other tool sets to develop enterprise data solutions.

They will use their extensive experience and an expert level of proficiency across a number of contemporary ICT systems, servers, coding languages and databases. Database Administrator Experts will exercise a considerable degree of independence and undertake a leadership role, with work performed under the general guidance of the leadership team. Some out of hours work may be required, to complete scheduled work or assist with complex incidents.

Key Tasks/Duties/Requirements:

• Providing expert advice to technical specialists and stakeholders and seek their cooperation in the provision of database administration.
• Schedule and manage database software installations and upgrades to maintain currency with supported environments.
• Administer the database configuration, security, scheme and objects, ensuring compliance against agreed standards and guidelines.
• Manage the data management process including initial loading, creating, maintaining, and distributing data.
• Implement corrective actions to improve performance and availability of databases.
• Design and plan operational backup, archival and recovery activities and cyclical disaster recovery exercises.
• Escalate unresolved system issues to appropriate vendors or stakeholders and manage these in accordance with agreed service level agreements to minimise user/system downtime.
• Manage the development of processes, security measures, standards and best practices aimed at enhancing the availability, security and performance of data assets.
• Prepare and review corporate and technical documentation.
• Develop data capability through coaching, mentoring and succession planning to increase performance, engagement and retention.

Essential Criteria

1. 2.5+ years of Mainframe Db2 Database Administration experience.
   

Desirable Criteria

1. 1.5+ years of experience with IBM Db2 tools (Recovery expert, clone tool etc.).
2. 2.5+ years of experience with monitoring and diagnostics using Omegamon and query monitor.
3. Experience with rolling out maintenance for Db2 across mainframe systems.
4. Experience with z/OS interfaces (ISPF, REXX, JCL etc.).
5. Understanding of z/OS software installation methodologies (SMP/E etc.).