Database Developer - SQL Server & SSIS

Atturra; Canberra; On-site; AUD 120,000 - 160,000; Full time

Benefits offered by this job

Benefits program

Wellbeing platform

Mentorship

Study assistance

Parental leave

EAP

Referral program

Job summary

Atturra is seeking a highly skilled SQL Server & SSIS Database Developer for a permanent role in our Data & Integration team, delivering solutions to federal government clients on a Defence Project. The position is based in Canberra (Russell, ACT) with full-time on-site presence and NV1 clearance required.

You will develop and support SQL Server 2022, SSIS packages, and Azure DevOps pipelines, manage ETL processes, and contribute to multi-environment deployments across ALM stages.

Qualifications

• Focus on SQL Server 2022, SSIS, and T-SQL development.
• Experience with Azure DevOps repositories, build and release pipelines.
• Ability to support ETL processes and post-deployment scripts.
• Experience with database triggers, stored procedures, and data workflows.
• Familiarity with SSMS, Visual Studio Database Project, and DevOps repos.
• Experience with Airflow and PySpark is advantageous.
• Ability to work on-site in Canberra with NV1 clearance.

Responsibilities

• Develop and support Microsoft SQL Server 2022, T-SQL, SSIS, and Azure DevOps pipelines.
• Maintain, troubleshoot, and support ETL processes and deployments across environments.
• Develop and maintain triggers, stored procedures, and data-processing workflows.
• Apply schema changes to code repositories and maintain in DevOps.
• Deploy database changes across six ALM environments for applications and reporting.
• Manage data mappings and ETL changes in DevOps, SSIS, and mapping updates.
• Deploy SSIS changes to the SSIS Host and configure in the platform scheduler.
• Create and deploy post-update scripts for higher ALM environments.
• Maintain Airflow and PySpark jobs in ETL packages and manage Iceberg schemas.

Skills

T-SQL development

SQL Server 2022

SSIS development

Azure DevOps

Data pipelines

Independent work

Tools

SSMS

Visual Studio

Azure DevOps

Apache Airflow

PySpark

Iceberg schemas

Job description

What You’ll Be Doing

Atturra is looking for a highly skilled SQL Server & SSIS Database Developer for a permanent opportunity in our Data & Integration Business, delivering solutions to federal government clients on a Defence Project. The role is based in Canberra (Russell, ACT) and requires a full‑time presence on the Defence site. An active AGSVA NV1 clearance is mandatory.

Responsibilities

• Develop and support Microsoft SQL Server 2022, T‑SQL, SQL Server Integration Services (SSIS), SQL database projects, and Azure DevOps repositories and deployment pipelines.
• Maintain, troubleshoot, and support ETL processes, SSIS package deployments, SQL database changes, and post‑deployment scripts across application and reporting environments.
• Develop and maintain database triggers, stored procedures, data‑processing workflows, audit logging, and application‑user attribution using SESSION_CONTEXT.
• Apply SQL database schema changes to code repositories in SQL Server Management Studio (SSMS) and maintain in Visual Studio Database Project and DevOps repository.
• Use DevOps Build and Release pipelines to deploy database schema changes to six Application Life‑cycle Management (ALM) environments for Application and Reporting (Application Development, Application Test, Application Production, Reporting Development, Reporting Test, Reporting Production).
• Apply changes to Visual Studio SSIS Project and Repository in DevOps, adding or removing data mappings for schema changes to ETL data flows.
• Deploy SSIS package changes to the SSIS Host in the platform and configure in the custom platform scheduler.
• Create and deploy SQL post‑update scripts to update data in higher ALM environments, including Production, for data update requests, data fixes, and similar changes.
• Maintain Apache Airflow and PySpark jobs in ETL packages that move data between application databases and medallion zones in the reporting platform, applying Apache Iceberg schema changes and data mapping updates.
• Apply remediation for any defects reported by the Test Manager.
• Support investigations into any data issues reported by users or stakeholders.

Working Conditions

• Canberra location.
• Onsite.
• NV1 security clearance is mandatory.
• Permanent full‑time.

Key Capabilities

• Focus on client needs and effective communication skills.
• Current NV1 security clearance (mandatory).
• Based in Canberra with the ability to work on‑site.
• Strong T‑SQL development skills using SQL Server 2022, including stored procedures, triggers, post‑deployment scripts, data fixes, and troubleshooting of database‑related issues.
• Experience supporting SQL database projects and repeatable deployments through Azure DevOps repositories, build pipelines, release pipelines, and environment‑specific deployment processes.
• Solid SQL scripting skills, including writing post‑update scripts and data fixes.
• Strong experience with SQL Server, including database schema management in SQL Server Management Studio (SSMS).
• Strong experience developing, deploying, and maintaining SSIS packages.
• DevOps experience managing code repositories and Build and Release pipelines.
• Ability to work independently and as part of a team.

Desirable Skills

• Experience with Apache Airflow and PySpark for ETL workloads.
• Experience with Apache Iceberg schemas and medallion architecture.
• Experience working across multiple ALM environments and custom schedulers.

Benefits

• Employee benefits, recognition, and wellbeing platform.
• Career growth via succession planning, internal promotions, and mentorship opportunities.
• Ongoing investment in professional development through industry and technology certifications, and study assistance.
• Mental health support through Employee Assistance Program.
• Support for family and caring responsibilities, including paid parental leave.
• Employee referral program, with monetary incentives offered.

Diversity, Equity, and Inclusion

At Atturra, we are committed to addressing the digital skills gap and championing diversity, equity, and inclusion. We welcome applications from individuals of all backgrounds—including Veterans, Aboriginal and Torres Strait Islander people, people with disability, members of the LGBTQI+ community, culturally diverse individuals, and other underrepresented groups. As a Veteran Friendly Employer under the Department of Veterans’ Affairs, we support the veteran community through recruitment, support, retention, and leadership opportunities.