Database Designer

Paxus Australia Pty Ltd.; City of Brisbane; On-site; AUD 120,000 - 150,000; Full time

Job summary

Paxus Australia Pty Ltd. is seeking a highly skilled Database Designer to support national government registry applications. You will design, optimize, and maintain databases on AWS Aurora and PostgreSQL, ensuring security, efficiency, and resilience of essential platforms.

In an Agile environment, you will collaborate with application, DevOps, and architecture teams, mentor peers, and drive continuous improvement across enterprise data services for millions of Australians.

Qualifications

• Proven experience designing PostgreSQL schemas, indexes, and artefacts.
• Strong SQL skills for query, function, and trigger optimization.
• Hands-on with AWS RDS Aurora and PostgreSQL in cloud environments.
• Ability to collaborate with software engineering teams on database solutions.

Responsibilities

• Design, optimize, and maintain enterprise databases on AWS Aurora and PostgreSQL.
• Collaborate with application, DevOps, and architecture teams in an Agile setting.
• Mentor peers and support organisational growth while ensuring data integrity.

Skills

PostgreSQL design

Query optimization

AWS RDS Aurora

Collaboration with engineering

Performance monitoring

Backup & disaster recovery

IaC & migrations

Stakeholder management

Education

Bachelor's degree in Information Technology or Computer Science

Job description

Join a dynamic team dedicated to delivering critical national systems and be part of Australia's leading enterprise solutions. We are seeking a highly skilled Database Designer to play a vital role in supporting the Department's registry applications. This is an exceptional opportunity to work in a fast-paced environment where your expertise will ensure the security, efficiency, and resilience of essential government platforms.

As a key member of the team, you will collaborate with talented application, DevOps, and architecture professionals in an Agile setting. Your work will directly influence the design, optimisation, and maintenance of enterprise databases built on AWS Aurora and PostgreSQL, empowering national systems that impact millions of Australians. Passionate about continuous improvement and professional development, you will also have the chance to mentor peers and support organisational growth.

Required Skills

• Proven experience designing and implementing PostgreSQL database schemas, indexes, and artefacts.
• Strong proficiency in developing and optimising queries, functions, and triggers to ensure peak database performance.
• In-depth knowledge of AWS RDS Aurora and PostgreSQL within cloud environments.
• Ability to collaborate effectively with software engineering teams to integrate database solutions.
• Skills in monitoring database performance, implementing optimisation strategies, and maintaining data integrity.
• Experience establishing backup, recovery, and disaster management protocols.
• Familiarity with automated deployment pipelines, migration strategies, and infrastructure-as-code practices.
• Excellent analytical, communication, and stakeholder management skills.

Nice to Have Skills

• Experience working within an Agile environment.
• Knowledge of emerging PostgreSQL features, extensions, and optimisation techniques.
• Experience with code review processes and technical mentorship.
• Understanding of change management principles and supporting organisational change initiatives.

Preferred Education and Experience

• Relevant tertiary qualifications in Information Technology, Computer Science, or related fields.
• Minimum of 3-5 years of experience in database design, optimisation, and management, particularly within cloud environments.
• Prior experience supporting enterprise-scale applications in government or large organisations is highly desirable.

Other Requirements

• Must hold NV1 security clearance.
• Ability to work in Melbourne CBD, Brisbane CBD, or Wollongong.
• Flexibility to support project timelines and deliverables within a stipulated timeframe.

Don't miss your chance to contribute to vital government systems that serve the Australian community.