PostgreSQL Database Administrator

Overview

The Infosys Cloud unit is dedicated to empowering enterprises with innovative cloud solutions that drive digital transformation and operational excellence. We specialize in leveraging advanced cloud technologies and AI‑driven insights to create scalable, secure, and resilient infrastructures. Our solutions enable organisations to achieve agility, efficiency, and sustainable growth in a hyperconnected world. Join us to be part of a pioneering team at the forefront of cloud and AI innovation.

You'll have the opportunity to work with cutting‑edge technologies, collaborate with industry experts, and contribute to transformative projects that shape the future of business. We are committed to fostering a culture of continuous learning and growth, ensuring that our team members thrive in a dynamic and supportive environment. If you're passionate about cloud and AI, and eager to make a significant impact, the Infosys Cloud unit is the perfect place for you to grow and excel.

• Collaborate with internal and client teams to resolve complex incidents, conduct root cause analyses, and document findings with preventive recommendations
• Participate in evaluation of client IT infrastructure, prepare actionable assessment reports, and support due diligence to document infrastructure maturity and improvement opportunities
• Contribute to the design of scalable, cost‑effective IT infrastructure solutions, review reusable components, and develop technical documentation for deployed systems
• Align release schedules and environment readiness, execute deployments as per protocols, perform post‑deployment testing, and manage version control to track changes
• Coordinate maintenance schedules, emergency fixes, and technology upgrades while ensuring uninterrupted integration into existing systems and processes
• Facilitate performance data analysis across systems, coordinate insights on system behaviour, and support capacity planning to optimise performance
• Conduct security checks, recovery drills, and compliance audits, implement security measures, and coordinate continuity plans to maintain adherence to standards
• Gather feedback to identify automation opportunities, analyse existing infrastructure processes, and propose enhancements for efficiency gains
• Act as liaison with onsite, offshore, and vendor teams to document project requirements, ensuring effective collaboration
• Develop a centralised repository of technical and procedural knowledge, leveraging insights from other projects to drive efficiency and retain organisational expertise

• A collaborative spirit and excellent communication skills.
• Ability to handle complex incidents and implement resolutions
• A knack for conducting IT infrastructure assessment and identifying key optimisation opportunities
• Focused approach towards deployment management, system optimisation, and process automation initiatives including sector‑specific focus
• The ability to work with cross‑functional teams

• Administer, maintain, and optimise PostgreSQL databases across development, test, and production environments.
• Design, implement, and support PostgreSQL high availability, replication and disaster recovery solutions using Patroni.
• Experienced with PostgreSQL performance tuning, backup and recovery, replication, and security.
• Hands‑on experience as a PostgreSQL DBA, with working knowledge of Postgres internals (MVCC, WAL, query planner, locking, buffer management) and operational best practices.
• Proven track record managing PostgreSQL in production environments, including incident response, root cause analysis, and performance optimisation under heavy traffic.
• Working knowledge of SQL skills, including query optimisation and execution‑plan analysis (EXPLAIN / EXPLAIN ANALYZE).
• Experience with backup and recovery such as: pgDump, pg Restore and tool Coomm Vault is good to have.
• Proficiency with Linux/Unix operating systems and shell scripting (Bash or similar).
• Create detailed documentation including diagrams of database infrastructure.
• Learn relevant business processes and understand the data flow, criticality and dependencies.
• Candidate…