Database Designer

MTP Services; City of Melbourne; On-site; AUD 120,000 - 160,000; Full time

Job summary

MTP Services in Melbourne is seeking an experienced IT Database Designer to join their team. Working in an Agile delivery model, you will collaborate with Application, DevOps and Architecture teams to support the full database lifecycle—from design and build through to release and maintenance—focusing on enterprise databases and AWS Aurora/PostgreSQL across AWS environments.

You will contribute to building team capability through coaching and feedback, promote Agile practices, and help optimise

Qualifications

• Experience with AWS RDS Aurora and PostgreSQL database design.
• Ability to develop and optimise PostgreSQL queries, functions and triggers.
• Experience delivering in an Agile environment and collaborating with DevOps.
• Ability to monitor performance and implement proactive optimisation.

Responsibilities

• Collaborate with Application, DevOps and Architecture teams to support the full database delivery lifecycle.
• Deliver and support enterprise databases and platforms with emphasis on AWS Aurora/PostgreSQL across AWS environments.
• Coach and train team members, promoting Agile practices and continuous improvement.
• Design and implement PostgreSQL schemas, indexes and database artefacts to support business-critical applications.

Skills

AWS RDS Aurora

PostgreSQL

Database design

Query optimisation

Performance tuning

Agile

DevOps collaboration

Code reviews

Mentoring

Infrastructure-as-code

Migration strategies

Communication skills

Analytical skills

Job description

Role Description

Our client is seeking an experienced IT Database Designer to join their team. Working within an Agile delivery model, the successful candidate will collaborate closely with Application, DevOps and Architecture teams to support the full midrange database delivery lifecycle, from design and build through to release and maintenance.

The role focuses on delivering and supporting enterprise databases and platforms, with a particular emphasis on AWS Aurora/PostgreSQL across AWS environments.

The successful candidate will also contribute to building team capability through coaching, training and feedback, while modelling and encouraging Agile ways of working and advocating a culture of continuous improvement.

Key Responsibilities and Requirements

The ideal candidate will demonstrate:

• Excellent analytical and communication skills to assist in negotiating, resolving issues and tailoring reports to varied audiences, including senior executives.


• An understanding of change management principles and the ability to support others through change.


• Extensive experience working with AWS RDS Aurora.


• Experience designing and implementing PostgreSQL database schemas, indexes and other database artefacts to support business-critical applications and ensure optimal data organisation.


• Ability to develop and optimise PostgreSQL queries, functions and triggers to maximise database performance, maintain data integrity and ensure efficient query execution.


• Experience collaborating with software engineering teams to integrate database solutions with AWS application architecture, APIs and microservices for optimal system performance.


• Ability to monitor database performance metrics and implement proactive optimisation strategies to prevent bottlenecks, ensure scalability and maintain consistent response times.


• Experience establishing and maintaining comprehensive backup, recovery and disaster management protocols to protect mission-critical data assets and ensure business continuity.


• Experience working closely with DevOps teams to implement automated deployment pipelines, database migration strategies and infrastructure-as-code practices for reliable deployments.


• Ability to conduct thorough code reviews, provide technical mentorship to peers, establish best practices and maintain coding standards.


• Experience researching and evaluating emerging PostgreSQL features, extensions and optimisation techniques to continuously improve system capabilities, efficiency and innovation potential.