IDP Education Limited
Being the global leader in international education services, for more than 50 years IDP has been the pioneer in this sector, specializing in combining human expertise with leading technology to help people reach their global ambitions. Operating in more than 50 countries around the world, IDP values and celebrates diversity, fostering a safe and inclusive workplace.
IDP Education Ltd is the proud co-owner of IELTS (International English Language Testing System), the world’s most popular high stakes English language proficiency test.
To learn more about us and our various service lines, please visit https://www.careers.idp.com/what-we-do
If you share our passion in helping people to pursue their dreams through education and thrive in an innovative agile digital culture then come and join us as we undergo our digital revolution.
About IDP
IDP is the global leader in international education services, delivering global success to students, test takers and our partners, through trusted human relationships, digital technology and customer research. An Australian-listed company, we operate in more than 50 countries around the world.
Our team is comprised of over 7,000 people of various nationalities, ages and cultural backgrounds. Proudly customer-first, our expert people are powered by global technology. Together, we offer unmatched services, helping local dreams become realities, all over the world.
Learn more at www.careers.idp.com
Role purpose
We are looking for an experienced PostgreSQL DBA with overall experience of 5 years and at least 3 years of relevant experience, including managing PostgreSQL databases in a cloud environment, preferably AWS. As a PostgreSQL DBA, you will be responsible for the full lifecycle management of our database infrastructure on AWS. This role involves designing, developing, enhancing, and monitoring all production and non-production databases within our technical architecture.
You will play a key role in ensuring database reliability, performance optimization, and scalability while collaborating with cross-functional teams to support critical business applications. A strong understanding of PostgreSQL architecture, high availability solutions, and database performance tuning is essential. Experience with observability tools like Splunk is a plus.
Key Accountabilities
- Design, deploy, and maintain PostgreSQL databases in AWS, ensuring high availability, scalability, and security.
- Monitor and manage production and non-production databases for performance, reliability, and uptime.
- Optimize database queries, indexing strategies, and schema designs to improve performance.
- Perform database maintenance tasks such as VACUUM, REINDEXING, and ARCHIVING to enhance database efficiency.
- Lead efforts in automating database monitoring, maintenance, and deployments.
- Implement and manage backup, recovery, and disaster recovery strategies.
- Conduct developer SQL code reviews to ensure query optimization and best practices before production release.
- Performing database migrations from one environment to another
- Develop and maintain scripts using Python, Shell scripting for database automation and administrative tasks.
- Utilize observability tools like Splunk, AWS CloudWatch to monitor database health and performance.
- Collaborate with cross-functional teams including developers, CloudOps, DevOps and leadership to support database operations.
Required Experience
- Minimum 5 years of experience as a Database Administrator (DBA).
- At least 3 years of hands-on experience managing PostgreSQL databases in AWS.
- Strong understanding of PostgreSQL database architecture, high availability, and replication strategies.
- Experience with AWS Aurora RDS and related AWS services.
- Hands-on experience in database performance tuning and query optimization.
- Experience in database backup, recovery, and disaster recovery planning.
- Strong knowledge of SQL, indexing strategies, and query execution plans.
- Experience in scripting and automation using Python, Shell scripting.
- Experience with observability tools like Splunk, AWS CloudWatch is an added advantage.
- Strong problem-solving and troubleshooting skills.
- Excellent communication and collaboration skills.
IDP Education’s ongoing success comes from our highly committed and caring employees around the globe. We encourage teamwork in order to leverage our people's diverse talents and expertise through effective collaboration and cooperation throughout our business.
We strive to provide a working environment where people are encouraged to excel, be creative and seek new ways to solve problems, take initiative, generate opportunities and be accountable for their actions.
We believe in developing dynamic, inclusive work places that encourage and celebrate cultural differences and views, and provide opportunities for personal, professional and career development all around the world. We respect diversity in our people: their ideas, work styles and perspectives as well as offering flexibility to ensure employees enjoy a satisfying balance of work and personal life.