Hybrid Data Platform Engineer: Snowflake, AWS & DBA

ELMO Software; Sydney; On-site; AUD 120,000 - 180,000; Full time

Benefits offered by this job

Hybrid work set up

Paid Parental leave

Birthday leave

Inhouse Learning and Development

ELMO Social and Diversity clubs

Wellbeing initiatives

Mental Health/EAP programs

Flare Benefits

Job summary

ELMO Software Pty Ltd is seeking a hands-on Database Administrator/Engineer to own production databases and the broader data platform. You will tune slow queries, manage AWS RDS MySQL and SQL Server, and safeguard security and reliability across the data stack.

This role blends core DBA duties with data engineering: Snowflake pipelines, dbt models, Python automation and AI-enabled tooling, delivering impact on customer outcomes and product performance.

Qualifications

• Strong DBA experience across AWS RDS with MySQL/SQL Server; Aurora PostgreSQL valued.
• Proven performance tuning, indexing, upgrades and backup/recovery.
• Production support via ticket queues with SLAs.
• Snowflake and dbt in production environments.
• Daily practical Python and SQL skills.
• IaC using Terraform or CloudFormation.
• AI tooling such as Claude Code or MCP-enabled agents.
• ISO27001 awareness when handling sensitive data.

Responsibilities

• Administer and support MySQL and SQL Server across AWS RDS; monitor health, capacity and upgrades.
• Own the database ticket queue and resolve issues within SLAs.
• Maintain dashboards and alerts for reliable production operations.
• Diagnose slow queries, locking/contention, indexing and execution‑plan issues.
• Plan and perform upgrades for MySQL and SQL Server; manage related tooling.
• Maintain strong security controls, access management, data masking and row‑level security.
• Use AI agents to accelerate investigation, root‑cause analysis and monitoring.
• Build Snowflake pipelines and dbt models; automate data loading with Python and SQL.
• Review AI-generated SQL and pipeline code for correctness and security.

Skills

AWS RDS DBA

Query optimisation

SQL proficiency

Snowflake & dbt

Python

Infrastructure as code

AI tooling

ISO27001 awareness

Tools

Snowflake

dbt

Python

Airflow

Terraform

CloudFormation

Kafka

GitHub Copilot

Job description

ELMO Software Pty Ltd is seeking a hands-on Database Administrator/Engineer to own production databases and the broader data platform. You will tune slow queries, manage AWS RDS MySQL and SQL Server, and safeguard security and reliability across the data stack.

This role blends core DBA duties with data engineering: Snowflake pipelines, dbt models, Python automation and AI-enabled tooling, delivering impact on customer outcomes and product performance.