Technical Specialist, Sql Databases | Full-Time Permanent

Details: The Technical Specialist, SQL Databases reports to the Lead Technical Specialist, SQL Databases and will be part of the team that is responsible for maintenance of application databases.
Technical Specialist, SQL Databases will ensure optimal database performance by analysing database issues and monitoring database performance following defined ITSM processes including Incident and Problem analysis and management with technical issues.
Technical Specialist, SQL Databases will also be responsible maintenance of the ETL Consoles that are used for nightly data transfer from the operational databases.
The Technical Specialist, SQL Databases also works with the broader technical team, Epic and third-party vendors to support environment set up and configuration, proactive monitoring, and maintenance.
The Technical Specialist, SQL Databases is responsible for:Performing traditional SQL DBA activities for underlying SQL RDBMS systems.
Makes recommendations to enhance storage and data protection strategies for very large databases.Scheduling and monitoring the recurring system processes.Assist with installing, configuring, maintaining, and upgrading the ETL console, cubes, and web servers in accordance with the ACT Health change and release management policies and processes.Collaborating with other Technical Specialists, Epic and other third-party providers to ensure proactive support and responsive issue resolution.Assist with installing and maintaining the administrative and monitoring tools necessary for high levels of availability and performance of the system databases and ETL consoles.Undertaking other duties appropriate to this level of classification that contribute to the Division.We are committed to creating an inclusive environment where people with diverse thoughts, lived experience, and perspectives can thrive and contribute their unique talents to the ACTPS and ACT community.
We encourage Aboriginal and Torres Strait Islander people, people with disability, people with culturally and linguistically diverse backgrounds, veterans, younger and older workers, and people with diverse genders, sexes and sexualities to apply.
Eligibility/ Other Requirements: Highly DesirableCertification on and experience in Microsoft Windows server administration.Working knowledge of Microsoft SQL Server, Windows Server and Internet Information on Services {IIS).Certification in Microsoft SQL Server.Working knowledge of virtualisation on platforms, Windows and Unix operating systems.