Technical Specialist, SQL DatabasesFull-time PermanentCloses: 10 July 2024Classification: Information Technology Officer Class 2Salary: $97,182 - $110,708 plus superannuationPosition No: 53700Directorate: ACT Health Advertised (Gazettal date): 26 June 2024Contact Officer: Glenn Loughton onGlenn Loughton or02 5124 2379 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.Note: A Merit Pool will be established from this selection process and will be used to fill vacancies over the next 12 months. Selection may be based on application and referee reports only.How to Apply: Please submit a written application of no more than three pages, responding to the required Selection Criteria in the Position Description, a curriculum vitae, and contact details of at least two referees, one of which has a good understanding of your technical skills.Applications should be submitted via the Apply Now Button Below.
#J-18808-Ljbffr
