ASD 4, 5 & 6 Database Administrators

Mission Data (MD) Division within ASD is responsible for providing the foundational data capabilities to support all of ASD’s functions. We achieve this via the provision of data platforms and services, management of ASD’s mission data, and providing complex analytic development and support, including Artificial Intelligence and Machine Learning capabilities. All roles within MD require knowledge of and strict compliance with legislative frameworks, government decision-making and ASD’s mission and policies requirements.

The Databases and Indexing team (DBI) provides a reliable corporate database environment to ensure uninterrupted and reliable database services for owners and users of multiple systems running on the corporate databases used in ASD and wider Defence. 

Key Duties

ASD 4 Database Administrator 

The successful applicant will: 

• Develop their expertise in managing corporate databases and supporting data owners and users. 
• Create, maintain and follow standard operating procedures based on outcomes of our internal testing, work implementation and environmental changes. 
• Be flexible to meet changing work requirements to ensure the reliability and ongoing enhancements for supported databases. 
• Upskill in a variety of database technologies to meet on-going or new operational requirements. 
• Learn a number of fundamental Oracle and Microsoft technologies such as MSSQL, SQL, table structure, indexes. 
• Learn a number of fundamental MongoDB technologies such as Operations Manager, JSON, key-value pairs. 

ASD 5 Database Administrator 

In addition to duties in the ASD 4 category, the successful applicant will: 

• Mentor junior DBAs in the team. 
• Work on supporting issues of a more technical nature that require investigation and debugging. 
• Learn a number of ASD specific requirements for our Oracle databases such as EUS, RAs, RMAN, Commvault, EMCC, materialized views, GRPs, flashbacks, APEX. 
• Learn a number of ASD specific requirements for our MongoDB databases such as Replication Server, Sharding, and Compacting. 

ASD 6 Database Administrator 

In addition to duties in the ASD 4 & 5 categories, the successful applicant will: 

• Be a source of technical expertise in the team on all Database matters, and have the ability to utilise all available resources to come to meaningful conclusions. 
• Have a previous strong and demonstrated working knowledge of Oracle, MongoDB or MSSQL. 
• Work on scripts written and running on Linux or Windows environments. 
• Have a focus on providing clear guidance to the team. 
• Be willing to automate tasks as needed and to make the team more efficient where practical. 
• Master a number of Oracle specific requirements such as PLSQL, Commvault, backups, flashbacks, APEX. 
• Master a number of MongoDB specific requirements such as Collections, Aggregation, Indexing and all CRUD operations. 

Further information can be found at: I’m changing my career | Australian Signals Directorate (asd.gov.au)

ASD is seeking applicants to fill current and anticipated vacancies and to create a merit pool for future vacancies. In line with the Australian Public Service Commissioner’s Direction 2022, upon completion of the recruitment activity, the merit pool will be available to locations across Australia.

We are seeking applicants who: 

• Have the ability to think critically. 
• Are able to communicate with both technical and non-technical people. 
• Are able to work in a team, following established priorities and procedures and sharing information with others, while prioritising and managing their own workflows. 
• Are motivated to learn and further develop their skills and accept feedback. 

To be eligible for employment with ASD, you must meet all of the following eligibility criteria:

• Australian Citizenship - Applicants must be an Australian citizen. Only in exceptional circumstances can this requirement be waivered. 
• Organisational Suitability Assessment – The preferred applicant will be required to undergo an Organisational Suitability Assessment (see Organisational Assessment section).
• Security Clearance - It is a condition of employment that applicants are willing and able to obtain and maintain the requisite security clearance for the duration of their employment with ASD.
• Health Assessment - The preferred applicant may be required to undergo a medical examination conducted by the Agency’s preferred medical provider. 

Please ensure that you meet the eligibility requirements outlined in the Information Pack prior to submitting an application.

Desirable Qualifications, Experience or Training

Experience or Training in one or more of the following areas is highly desirable but not mandatory for the ASD 4 role: 

• Database Administrator experience on Oracle, MongoDB or MSSQL. 
• Database implementation in a Cloud environment (eg OpenSearch, AWS RDS, Azure SQL). 
• Developer who’s worked on systems that use a database. 

Experience in one or more of the following areas is highly desirable but not mandatory for the ASD 5 role: 

• Database Administrator experience on Oracle, MongoDB or MSSQL. 
• Work experience with Database implementation in a Cloud environment (eg OpenSearch, AWS RDS, Azure SQL). 
• Work experience with Linux or Windows system administration. 
• Work experience with cloud database solutions like Azure SQL or AWS RDS. 

Experience in two or more of the following areas is highly desirable but not mandatory for the ASD 6 role:

• Leading Database Administrator experience with Oracle, MongoDB, MSSQL or Sybase. 
• Leading role experience with Database implementation in a Cloud environment (eg Opensearch, AWS RDS, Azure SQL). 
• Leading role experience with Linux or Windows system administration. 
• Experience as a general developer (eg Java, Python, Android dev, C, C#, React, Powershell).