APS Level 6
- Canberra, ACT
- $98,105 - $107,880
**About the Department of Employment and Workplace Relations**
We are committed to empowering futures, ensuring rights and enriching lives. We support people to have safe, secure and well-paid work with the skills for a sustainable future as we ourselves strive to be a model employer.
We provide the framework for fair and productive relationships between employers and employees. We also oversee skills development and training initiatives to support those entering the workforce or re-training to take advantage of emerging employment opportunities.
With us, your work directly contributes to shaping the employment landscape. Whether you are engaging in policy development, program implementation, or direct support services, your efforts will have a tangible impact on job seekers, employees and the economy by giving them a framework to build a future anchored and realised through employment.
It is our ambition to do things differently, to create the 'department of great jobs'- where our people reflect our purpose.
**The Role**
In this role, you will handle various day-to-day database administration tasks, including the installation and configuration of SQL Servers, daily system health checks, database releases, backups, restores, performance monitoring and troubleshooting, as well as vulnerability investigation and remediation. You will also resolve moderately complex issues related to data and access while working on both BAU (Business as Usual) and project-related activities.
You are expected to have proficiency in T-SQL and PowerShell scripting for administrative and reporting tasks, as well as a solid understanding of report-building and data analytics using SQL Server Reporting Services (SSRS, Power BI) or other relevant reporting tools.
You will collaborate with cross-functional teams to gather requirements, optimise query performance, ensure data integrity and security, and provide actionable reports and visualisations. Throughout these interactions, you will leverage your strong verbal, written, and presentation skills to effectively communicate solutions, insights, and recommendations.
**Duties and Responsibilities**
- Build, configure, upgrade, and migrate SQL databases to ensure reliability and efficiency.
- Perform regular performance monitoring, troubleshooting, and tuning to maintain optimal database operations.
- Conduct backup/restore procedures and data integrity checks to safeguard critical information.
- Work closely with internal systems engineers and operational teams to understand database requirements or to resolve any arise issue.
- Communicate clearly and proactively with customers and end-users to gather feedback, manage expectations, and present technical information in an accessible manner.
- Monitor Microsoft SQL Server performance metrics, proactively identifying areas for improvement in efficiency and scalability.
- Investigate and resolve database-related incidents and issues, providing timely support to minimize downtime.
- Develop and optimise reports and visualisations using SSRS, Power BI, or other relevant reporting tools.
- Use T-SQL and PowerShell scripting to generate automated and on-demand reports, presenting findings to stakeholders in a clear and compelling way.
- Create and maintain comprehensive documentation for database configuration, maintenance procedures, and troubleshooting guides.
- Ensure documentation is up-to-date and accessible, promoting knowledge sharing across the organisation.
- Adhere to database security principles and best practices, including access controls and data encryption.
- Identify and remediate potential vulnerabilities, ensuring alignment with compliance and regulatory requirements.
- Perform after-hours maintenance work as necessary, with overtime provisions as outlined in the Enterprise Agreement.
**How to Apply**
Applicants are required to provide a summary (no more than **750**words) that outlines skills, knowledge, and experience and why you should be considered for this vacancy. You should take into consideration the position overview (including any detailed position specific requirements) when drafting your response. Where possible include specific relevant examples of your work.
The APS work level standards accommodate the diversity of roles across the APS and are structured to clearly differentiate between the work expected (i.e. responsibilities and duties) at each classification level.
In the eRecruit (the department's online recruitment system) you will also need to:
- upload a Curriculum Vitae
- provide contact details for 2 Referees.
**Eligibility**
**Don't meet all the role requirements?**
**Citizenship** - to be eligible for employment with the Department, you must be an Australian Citizen or, in limited circumstances, in the process of obtaining it.