Job Description:
Australian Citizens residing in Australia only respond.
Must have Baseline.
Overview:
The successful candidate will focus on maintaining and sustaining Treasurys database environment, including on-premises and cloud hosted.
The Treasury is looking for a skilled resource that will play a key role in ensuring DBA project deliverables are met. The resource will have the ability to work across multiple work packages both on a project and a business-as-usual team.
Technical Capability
* The successful candidate will have demonstrated experience working as a database administrator.
* The candidate will have the ability to quickly adapt to the Treasury environment.
Deliverables
* The successful candidate will work to the direction of the project manager as well as:
* Deliver work packages to support multiple projects
* developing relevant documentation including handover to BAU, SoPs, detailed designs and high-level designs.
* (as time permits) providing on the job training and knowledge transfer to other Treasury staff to support internal capability uplift.
Experience
* Tertiary qualifications in ICT or a related field and/or equivalent experience as a database administrator (8+ years).
* Experience administering SQL Server, from legacy SQL Server 2012 to all versions of SQL Server in the Azure cloud.
* TSQL and powershell scripting experience
* Experience with on-premises high availability clusters
* Experience decommissioning legacy SQL Server 2012 servers
* Experience migrating databases between different versions of SQL Server
* Experience with Commvault backup and restore
* Experience with SAS Grid or SAS Viya is desirable but not essential
* Key Personnel Expertise
* Effective team player, and good communicator.
Address each selection criteria in detail.
Essential criteria
1. Tertiary qualifications in ICT or a related field and/or equivalent experience as a database administrator (8+ years).
2. Experience administering SQL Server, from legacy SQL Server 2012 to all versions of SQL Server in the Azure cloud.
3. TSQL and powershell scripting experience
4. Experience with on-premises high availability clusters
5. Experience decommissioning legacy SQL Server 2012 servers and Experience migrating databases between different versions of SQL Server
6. Experience with Commvault backup and restore
Desirable criteria
1. Experience with SAS Grid or SAS Viya
Required Skills:
High Availability
Handover
Powershell
SAS
Treasury
Deliverables
Servers
Availability
Databases
Documentation
SQL
Training