Database Administration(L5) Citizens With Nv1

Xpt Software Australia Pty; City of Launceston; Presencial; AUD 90 000 - 140 000; Tempo integral

Resumo da oferta

Xpt Software Australia Pty is seeking a Database Administrator / Data Analyst to provide routine database administration and data management support for maintenance analysis and reporting tools. You'll ensure database availability, perform backups, and monitor data integration between source systems and the data lake environment.

The role requires hands-on experience with SQL Server 2014/2019, SSIS and SSRS, strong SQL scripting skills, and an understanding of incident and problem management in

Qualificações

• Experience in Microsoft SQL Server administration (2014/2019), including SSIS and SSRS.
• Proficiency in SQL scripting for data analysis and reporting.
• Understanding of Incident and Problem Management in a secure, multi-vendor environment.

Responsabilidades

• Manage and maintain system databases for legacy and modern environments (SQL 2014 and 2019).
• Monitor data integration success and remediate failures between source systems using SQL transactional replication.
• Maintain data structure and quality within the application suite, ensuring data is ready for future migration.
• Execute scripts and application data exports to support third-party and national compliance audits approximately twice per year.
• Assist in data quality profiling and remediation work as directed by the Lead DBA or government stakeholders.

Conhecimentos

SQL Server Admin

SSIS

SSRS

SQL scripting

Data quality

Incident & Problem Mgmt

Ferramentas

SQL Server 2014/2019

Descrição da oferta de emprego

The Database Administrator / Data Analyst provides routine database administration and data management support for the client's maintenance analysis and reporting tools. Key accountabilities include maintaining database availability, performing routine backups, and monitoring data integration success between source systems and the data lake environment.

Key Responsibilities

• Manage and maintain system databases for legacy and modern environments (SQL 2014 and 2019).
• Monitor data integration success and remediate failures between source systems using SQL transactional replication.
• Maintain data structure and quality within the application suite, ensuring data is ready for future migration.
• Execute scripts and application data exports to support third-party and national compliance audits approximately twice per year.
• Assist in data quality profiling and remediation work as directed by the Lead DBA or government stakeholders.

Required Skills and Expertise

• Experience in Microsoft SQL Server administration (2014/2019) including SSIS and SSRS.
• Proficiency in SQL scripting for data analysis and reporting.
• Understanding of Incident and Problem Management within a secure, multi-vendor environment.

Mandatory Requirements

• Active AGSVA NV1 Clearance (Required for privileged access to production databases).
• Must be able to work full-time in Melbourne (Laverton) or in Ballarat or in Canberra.

Database Administration(L5) Citizens with NV1 Launceston, TAS, AU