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.

More Jobs at IDP Education

System Administrator

Gurugram, Haryana

Experience: Not specified

Salary: Not disclosed

Invigilator - Testing

Mumbai, Maharashtra

Experience: Not specified

Salary: Not disclosed

DBA Analyst

Chennai

5.0 - 5.0 yrs

Salary: Not disclosed

System Administrator

Gurgaon

Experience: Not specified

INR 4 - 5 Lacs

Software Developer

Gurgaon

3.0 - 3.0 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

IDP Education

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

DBA Analyst