- Design and optimise enterprise databases supporting business-critical applications
- Work with AWS Aurora PostgreSQL across enterprise cloud environments
- Collaborate with skilled application, DevOps and architecture teams
- Drive database performance, scalability, resilience and reliability
- Shape database engineering standards and continuous improvement practices
- Mentor colleagues and contribute to technical capability development
About the Role
Working within an Agile delivery environment, this role designs, builds and maintains enterprise databases using AWS Aurora PostgreSQL. Collaborating with application, DevOps and architecture teams, you will optimise database performance, automate deployments, strengthen data resilience and support critical registry applications.
Key Responsibilities
- Design and implement PostgreSQL schemas, indexes and database artefacts
- Develop and optimise SQL queries,
functions and triggers for performance and data integrity
- Monitor database performance and implement proactive optimisation strategies
- Establish backup, recovery and disaster recovery procedures
- Implement automated database deployments, migration strategies and Infrastructure as Code
- Conduct code reviews, mentor colleagues and promote database engineering best practices
Skills & Experience
- Extensive hands-on experience with AWS RDS Aurora PostgreSQL
- Solid expertise in PostgreSQL database design, SQL development and query optimisation
- Experience with database performance monitoring, scalability and troubleshooting
- Knowledge of database backup, recovery, high availability and disaster recovery
- Experience with CI/CD pipelines, database migrations and Infrastructure as Code
- Excellent analytical, communication, stakeholder management and technical leadership skills
Australian Citizenship & Existing Negative Vetting1 security clearance is a mandatory requirement for this position.