Job
Description
About IDP Education: 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 worlds 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 aninnovative agile digital culturethen come and join us as we undergo our digital revolution. Position 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. Responsibilities & Duties: 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 Skills & Qualifications: 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.
