PostgresSQL DBA

About Us:

Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 56 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.

Visit

to see how Infosys (NYSE: INFY) can help your enterprise navigate your next.

Short Description:
Looking for PostgreSQL DBA

Salary Range:
108, ,893 (Annual Gross)

Please Note: The above salary range is only indicative and maybe subject to suitable enhancements, based on internal company processes

Location:
Sydney, Australia

Roles and Responsibilities:

• Expertise in RDBMS S/W installation, database server builds, applying patches, upgrading, configuring, trouble shooting of PostgreSQL.
• Expertise in Disaster Recovery plans by configuring Streaming Replication, Logical Replication, and utilizing backup and restore tools like pg Backrest or Barman.
• Implementing High Availability in PostgreSQL using tools like Patroni, repmgr, or Pacemaker with Streaming Replication.
• Expertise knowledge in database encryption methods for PostgreSQL.
• Expertise in database Back Up, Restore, Recovery, Updating statistics (VACUUM ANALYZE), Rebuilding and Reorganizing indexes (REINDEX, CLUSTER), Replication (Streaming and Logical), Foreign Data Wrappers, and routine maintenance tasks.
• Monitoring Instances, Configuring and Enabling alerts using tools like Prometheus, Grafana, Datadog, or other PostgreSQL monitoring solutions.
• Experience in query optimization and performance tuning. Experience in using EXPLAIN ANALYZE, pg\_stat\_statements, and system monitoring tools.
• Experience in Python, Bash, or other scripting languages to automate day-to-day activities and troubleshoot/enhance existing scripts.
• Monitoring/Troubleshooting Streaming Replication and Logical Replication setups.
• Respond to and troubleshoot database-related problems reported by customers.
• Automate routine database administration tasks.
• Preparing Knowledge articles and sharing with the team on day-to-day activities.

Skill / Competencies / Experience:

ESSENTIAL

• Tertiary Qualification in IT / Computer Science / related discipline

PREFERRED

• Providing 24X7 Support and maintenance to all the Database Instances of OLTP/OLAP.

ADDITIONAL

1. Strong Communication & Management skills and, expertise in Onsite/offshore and Client coordination.
2. Excellent customer interfacing skills.
3. Strong attention to detail and outstanding analytical and Problem-solving skills.

Infosys ANZ : Check out why you should join Infosys

At Infosys, we recognize that everyone has individual requirements. If you are a person with disability, illness, or injury and require adjustments to the recruitment and selection process, please contact our Recruitment team for adjustment either via the following email or call Alternatively, you can include your preferred method of communication in email, and someone will be in touch.

Please note in order to protect the interest of all parties involved in the recruitment process, Infosys does not accept any unsolicited resumes from third-party vendors. In the absence of a signed agreement, any submission will be deemed as non-binding and Infosys explicitly reserves the right to pursue and hire the submitted profile. All recruitment activity must be coordinated through the Talent Acquisition department.

"All aspects of employment at Infosys are based on merit, competence and performance. We are committed to embracing diversity and creating an inclusive environment for all employees. Infosys is proud to be an equal opportunity employer."