Why this role stands out
Leverage your expertise in SQL Server and SSIS to deliver critical data solutions for a prominent Defence project, with opportunities to grow your skills within a reputable technology consultancy. This role is ideal for a mid-senior developer with strong communication skills and an active NV1 clearance, eager to contribute to client transformation. Apply to join a cohesive team and make a significant impact.
Quick overview
Job description
Select how often (in days) to receive an alert:
Location: Canberra, Australian Capital Territory, AU, 2600
What you'll be doingAtturrais looking for a highly skilled SQL Server & SSIS Database Developer for a permanent opportunity, towork within our Data & Integration Business, delivering to our Atturra clients in Federal Government for a Defence Project.
Atturra is seeking candidates who have a passion for innovative technology and driving customer transformation. This person must be able to communicate with a variety of different audiences and must have strong presentation skills. The ability to work in a cohesive team (Atturra and the client team) is important for this role.
This role is based in Canberra, and the successful candidate must be able to work full time on the Defence site in Russell, ACT. Additionally, holding an active AGSVA NV1 Clearance is a non-negotiable requirement for this role.
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, application-user attribution using SESSION_CONTEXT, metadata-driven database solutions, and repeatable deployment patterns
- Apply SQL database schema changes to code repositories in SQL Server Management Studio (SSMS) and maintain in Visual Studio Database Project and Repository in DevOps
- 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 SQL Server Integration Services (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 adding or removing data mappings for schema changes
- Apply remediation for any defects reported by the Test Manager
- Support investigations into any data issues reported by users or stakeholders.
- Onsite
- NV1 security clearance is mandatory
- Permanent full time
- 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 Microsoft SQL Server 2022, including stored procedures, triggers, post-dployment scripts, data fixes, and troubleshooting 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 skills, including writing post-update scripts and data fixes.
- Strong experience with SQL Server, including database schema management in SQL Server Management Studio (SSMS) - mandatory.
- SQL Server Integration Services (SSIS) - strong experience developing, deploying, and maintaining SSIS packages (mandatory).
- DevOps - experience managing code repositories and Build and Release pipelines.
- Ability to work independently and as part of a team.
- 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.
Atturra is one of the fastest growing ASX-listed advisory and IT solutions companies in Australia, giving you a strong foundation to fulfil your career ambitions.
We currently have 1300+ professionals working across Australia, New Zealand, Singapore, Hong Kong, and USA who are using innovation to lead the way.
Data & Integration business unit helps clients unlock the full potential of data by integrating systems and applications, enabling digital transformation through our comprehensive on-premises, hybrid, and cloud integration solutions. We specialise in Boomi, Smartsheet, and OpenText.
This is your chance to make an impact. Come and join our talented and creative team of change makers to redefine the future through technology.
What our people say: "We are working towards a very bright future." "It's a company with vision and a promising future." Why you'll love working here Culture of possibilityAt Atturra we embrace innovation within our teams, fostering an environment of possibility and growth. We believe in creating a supportive and welcoming culture, where everyone is encouraged to achieve success through collaboration, continuous learning, and smart work practices.
A strong set of company valuesOur culture is reflected by our employees who demonstrate camaraderie, innovation, dedication, respect and excellence in everything they do. These traits have become integral to the way we do business and are the values we strive for.
Valuable employee 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 our Employee Assistance Program
- Support for family and caring responsibilities, including paid parental leave
- Employee referral program, with monetary incentives offered
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.
We are proud to be recognised as a Veteran Friendly Employer under the Department of Veterans' Affairs Veteran Employment Commitment (VEC). Atturra is dedicated to supporting Australia's veteran community by enhancing recruitment, support, retention, and leadership opportunities. Our goal is to ensure veterans build meaningful and impactful careers with us.
What our people say: "Atturra has a great working environment and management are very supportive of their staff. We celebrate success and have fun while working hard."Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- XS
Senior Full-Stack Engineer - Python + CloudRecently posted
XPT Software Australia Pty Ltd · Sydney · Hybrid · Posted 18 Nov 2026 🇦🇺
MariaDBMongoDBOracle+7TechnologySalary not listed - LI
Senior Full-Stack Engineer - AI-Driven Cloud & DevOps LeaderRecently posted
Lifeblood · Melbourne · Hybrid · Posted 18 Nov 2026 🇦🇺
AWSAgileTechnologySalary not listed - LI
Senior Full Stack EngineerRecently posted
Lifeblood · Melbourne · Hybrid · Posted 18 Nov 2026 🇦🇺
SQLSpringSpring Boot+22TechnologyA$15.9k/yr - WS
Senior Full-Stack Engineer: Lead & Scale Web AppsRecently posted
WealthTech Solutions · Sydney · Hybrid · Posted 18 Nov 2026 🇦🇺
TechnologySalary not listed - KI
Senior Full-Stack Engineer - Remote, Own End-to-End ImpactRecently posted
Kismet · Melbourne · Remote · Posted 18 Nov 2026 🇦🇺
AWSReact NativeRemix+3TechnologySalary not listed - KI
Senior Software Engineer, Full Stack Remote Australia Melbourne preferredRecently posted
Kismet · Melbourne · Remote · Posted 18 Nov 2026 🇦🇺
AWSReact NativeRemix+3TechnologySalary not listed - SK
Senior Full-Stack Engineer - AI-Driven Mesh PlatformRecently posted
Skynettstudio · Melbourne · Hybrid · Posted 18 Nov 2026 🇦🇺
TechnologySalary not listed - CP
Senior Java Developer - Hybrid Canberra NV1Recently posted
CompuTracts Pty Ltd (Business Name: Connect One Recruitment) · Canberra, Australian Capital Territory · Hybrid · Posted 18 Nov 2026 🇦🇺
GrafanaJavaTechnologySalary not listed - FA
.NET Developer & React Developer (12 month FTC) - January StartRecently posted
FinXL AU · Sydney · Hybrid · Posted 18 Nov 2026 🇦🇺
GitHTMLCSS+10TechnologySalary not listed - BO
WordPress critical error Developer Needed for Jarrah Creative Arts DevelopmentRecently posted
BotDigit Inc. · Australia · Hybrid · Posted 18 Nov 2026 🇦🇺
GitRESTPostgreSQLTechnologySalary not listed - OR

AI-Driven Full-Stack Developer (JS/TS) - Field ServiceRecently posted
Oracle · Melbourne · Hybrid · Posted 18 Nov 2026 🇦🇺
OracleJavaScriptTypeScriptTechnologySalary not listed - XS
Java Developer-FullstackRecently posted
XPT Software Australia Pty Ltd · Sydney · On-site · Posted 18 Nov 2026 🇦🇺
MariaDBMongoDBOracle+10TechnologySalary not listed
