Database Designer
Summary
Designs, builds, and maintains enterprise PostgreSQL databases on AWS RDS/Aurora, covering the full delivery lifecycle from schema design and query optimization through to backups, disaster recovery, and DevOps automation. Works in Agile teams alongside application, DevOps, and architecture staff for an IT services provider serving Federal Government agencies.
About The Role
We are seeking an experienced IT Database Designer to join the team in our Enterprise Solutions and Technology business area. Working within the Agile delivery model, the role collaborates 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, supporting applications, built on AWS Aurora/PostgreSQL across AWS environments.
The role builds team capability through coaching, training, and feedback as well as modelling and encouraging others to adopt an agile approach. It advocates a culture of continuous improvement. Managing key stakeholder relationships, you’ll collaborate to resolve issues and deliver quality outcomes.
Essential Experience
Has excellent analytical and communication skills to assist in negotiating, resolving issues, and tailoring reports to a varied audience, including senior executives
Understands change management principles and supports others through the change
Has extensive experience in AWS RDS Aurora:
Design and implement PostgreSQL database schemas, indexes, and other artefacts to support business-critical applications and ensure optimal data organization
Develop and optimize PostgreSQL queries, functions, and triggers to ensure maximum database performance, data integrity, and efficient query execution
Collaborate with software engineering teams to integrate database solutions seamlessly with AWS application architecture, APIs, and microservices for optimal system performance
Monitor database performance metrics and implement proactive optimization strategies to prevent bottlenecks, ensure scalability, and maintain consistent response times
Establish and maintain comprehensive backup, recovery, and disaster management protocols to protect mission-critical data assets and ensure business continuity
Work closely with DevOps teams to implement automated deployment pipelines, database migration strategies, and infrastructure-as-code practices for reliable deployments
Conduct thorough code reviews and provide technical mentorship to peers while establishing best practices and maintaining coding standards
Research and evaluate emerging PostgreSQL features, extensions, and optimization techniques to continuously improve system capabilities, efficiency, and innovation potential
WHO WE ARE
Kirra Services is a leading provider of IT services and recruitment personnel, headquartered in Canberra, ACT. Award-winning winners of the Seek SARA 2025 Small Recruitment Company of the Year, we partner closely with a range of Federal Government agencies and are continuously seeking talented professionals to join our growing team.
Kirra Services is proudly SupplyNation Certified and majority Indigenous-owned. We are committed to creating opportunities for all Australians and strongly encourage Aboriginal and Torres Strait Islander candidates to apply for all roles.