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 diverse 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.

📌 Database Designer (Melbourne)
🏢 MTP Services
📍 Melbourne