DBA Analyst
IDP Education Ltd
Date: 2 weeks ago
City: Chennai, Tamil Nadu
Contract type: Full time
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
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.
- 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.
See more jobs in Chennai, Tamil Nadu