SQL DB Admin & Data Analyst (NV1) - Melbourne/Ballarat

Xpt Software Australia Pty; Port Macquarie; On-site; AUD 90,000 - 120,000; Full time

Job summary

Xpt Software Australia Pty is seeking a Database Administrator / Data Analyst to manage and maintain databases across legacy and modern environments (SQL 2014 & 2019). You will monitor data integration, remediate failures, and ensure data quality for migration and reporting. This full-time role requires strong SQL skills and incident management experience.

The position involves executing data exports for audits and collaborating with government stakeholders on data quality initiatives.

Qualifications

• Experience with Microsoft SQL Server (2014/2019).
• Proficient in SSIS and SSRS for integration and reporting.
• Strong SQL scripting for analysis and reporting.
• Understanding of incident and problem management in a multi-vendor environment.

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 migration.
• Execute scripts and application data exports to support audits approximately twice per year.
• Assist in data quality profiling and remediation work as directed by the Lead DBA or stakeholders.

Skills

SQL Server

SSIS

SSRS

SQL scripting

Incident management

Job description

Xpt Software Australia Pty is seeking a Database Administrator / Data Analyst to manage and maintain databases across legacy and modern environments (SQL 2014 & 2019). You will monitor data integration, remediate failures, and ensure data quality for migration and reporting. This full-time role requires strong SQL skills and incident management experience.

The position involves executing data exports for audits and collaborating with government stakeholders on data quality initiatives.