PostgreSQL Database Administrator

About the role

The Infosys Cloud unit empowers enterprises with innovative cloud solutions that drive digital transformation and operational excellence. Specializing in advanced cloud technologies and AI-driven insights, we create scalable, secure, and resilient infrastructures. This role offers the opportunity to work with cutting-edge technologies, collaborate with industry experts, and contribute to transformative projects shaping the future of business.

Responsibilities

• 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 behavior, and support capacity planning to optimize 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, analyze 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 centralized repository of technical and procedural knowledge, leveraging insights from other projects to drive efficiency and retain organizational expertise.
• Administer, maintain, and optimize PostgreSQL databases across development, test, and production environments.
• Design, implement, and support PostgreSQL high availability, replication, and disaster recovery solutions using Patroni.
• Create detailed documentation including diagrams of database infrastructure.
• Learn relevant business processes and understand the data flow, criticality, and dependencies.

Requirements

• Bachelor’s degree or foreign equivalent from an accredited institution. Three years of progressive experience in the specialty may substitute for each year of education.
• This position may require relocation and/or travel to work/project location.
• Must be available to work exclusively for PST time zone and operate on rotating shift schedules to ensure 24/7/365 support coverage, including weekends and holidays.

Skills

• 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 optimization under heavy traffic.
• Working knowledge of SQL skills, including query optimization and execution-plan analysis (EXPLAIN / EXPLAIN ANALYZE).
• Experience with backup and recovery tools such as pgDump, pgRestore, and CommVault.
• Proficiency with Linux/Unix operating systems and shell scripting (Bash or similar).
• Good communication and analytical skills.
• Collaborative spirit and ability to handle complex incidents.
• Focused approach towards deployment management, system optimization, and process automation.
• Ability to work with cross-functional teams.

Preferred Skills

• Additional experience with SQL Server, MySQL, or MariaDB in mixed database environments.
• Experience with tools such as Qlik Attunity, SolarWinds DPA, and Delphix.
• PowerShell programming.
• Backup and restore tools such as EMC Networker.

Schedule

• Shift 1: 3 AM to 12 PM PST
• Shift 2: 11 AM to 8 PM PST
• Shift 3: 7 PM to 4 AM PST

Benefits

• Medical/Dental/Vision/Life Insurance
• Long-term/Short-term Disability
• Health and Dependent Care Reimbursement Accounts
• Insurance (Accident, Critical Illness, Hospital Indemnity, Legal)
• 401(k) plan and contributions dependent on salary level
• Paid holidays plus Paid Time Off