Senior Database Administrator – SQL Server, Db2 z/OS, Db2 Midrange and MongoDB platforms

Infrastructure Engineers implement, manage and retire the infrastructure (including physical, virtual, networking and cloud infrastructure) that supports digital services.

The Database Administrator will provide expert technical support across SQL Server, Db2 z/OS, Db2 Midrange and MongoDB database platforms, with an immediate focus on critical MongoDB upgrade and migration activities. The role will support planning, validation and controlled implementation of upgrades and migrations to current supported database versions, including performance optimisation, data consistency assurance, issue resolution and risk mitigation. The specialist will work with APS technical teams to support platform resilience, minimise downtime and document all work undertaken.

Out-of-hours work may occasionally be required to complete scheduled activities or resolve complex incidents.

Key duties and responsibilities

Duties may include:

• Provide specialist database administration expertise across SQL Server, Db2 z/OS, Db2 Midrange and MongoDB platforms.
• Support version upgrade, migration and optimisation activities, including the immediate MongoDB upgrade and migration requirement.
• Assess current database environments and identify upgrade, compatibility, migration, performance and operational risks.
• Optimise database performance and support remediation of identified issues across relevant platforms.
• Ensure data consistency, integrity and availability throughout upgrade, migration and support activities.
• Support database activities in containerised environments and advise on associated risk mitigation.
• Work collaboratively with APS technical teams to plan, test and implement upgrade and migration activities.
• Document all work undertaken, including configuration changes, upgrade steps, risks, issues and lessons learned.
• Support knowledge transfer to APS staff through blended delivery and targeted skills transfer activities.

Technical Skills (continued)

• Strong troubleshooting, technical documentation and stakeholder communication skills.

Knowledge / Qualifications

Demonstrated specialist knowledge of enterprise database platforms including SQL Server, Db2 z/OS, Db2 Midrange and MongoDB, with experience in upgrade planning, migration execution, performance optimisation, data consistency and operational support. Knowledge of container technologies and enterprise ICT change practices is highly desirable.

Technical skills

• Advanced database administration experience across SQL Server, Db2 z/OS, Db2 Midrange and MongoDB. • Strong knowledge of database upgrade, migration, performance tuning, replication, backup, recovery and data consistency controls. • Experience supporting MongoDB or other database technologies in containerised environments. • Ability to identify, assess and mitigate technical and operational risks during database upgrade and migration activities.

About the organisation

Services Australia is at the frontline of government service delivery, supporting millions of Australians, and is front and centre of a vision to be a world leader in government service delivery. It’s using cutting-edge technology to build world class platforms and capabilities to help Australians get on with their lives.

Essential criteria

1.Demonstrated expert-level Microsoft SQL Server administration capability, including performance tuning, backup and recovery, high availability, security and operational support in enterprise environments.

2.Demonstrated expert-level IBM Db2 z/OS administration capability, including performance monitoring, backup and recovery, data integrity, security and operational support in enterprise environments.

3.Demonstrated expert-level IBM Db2 Midrange administration capability, including performance monitoring, backup and recovery, data integrity, security and operational support in enterprise environments.

4.Demonstrated expert-level MongoDB administration capability, including replication, backup and recovery, performance tuning, data consistency and operational support in enterprise environments.

5.Demonstrated experience supporting database platforms in containerised environments, including identifying and managing platform, deployment and operational risks.

6.Demonstrated ability to plan, validate and implement controlled database upgrades and migrations while maintaining service continuity, data integrity and availability.

Desirable criteria

1.Experience working in complex government or enterprise ICT environments.

2.Experience contributing to knowledge transfer activities, technical documentation and skills uplift for internal teams.

The agency requires these services at the agency’s premises in either Canberra, Adelaide, Brisbane, Melbourne. Working from home arrangements may be considered in the provision of these services, ensuring the Labour Hire Worker’s residing address is within reasonable travel time and distance of the RFQ location to present onsite in cases of emergency or to meet business requirements.