PostgresSQL DBA

Senior Talent Acquisition Specialist at Infosys 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. Short Description: Looking for PostgreSQL DBA Salary Range: 108,571 - 119,893 (Annual Gross) 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. 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 Strong Communication & Management skills and, expertise in Onsite/offshore and Client coordination. Strong attention to detail and outstanding analytical and Problem-solving skills. 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.” #J-18808-Ljbffr