PostgreSQL Database Administrator

Infosys; Arizona; On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Medical Insurance

401(k) plan

Paid holidays

Job summary

Infosys is seeking an experienced PostgreSQL DBA to administer and optimize databases across development, test, and production environments. The role focuses on high availability (Patroni), backups, and performance tuning, with responsibility for documentation and cross-team collaboration.

Applicants should be prepared to work exclusively in PST time zone and participate in rotating shifts to ensure 24/7/365 coverage, including weekends.

Qualifications

• Experience as a PostgreSQL DBA in production environments.
• Knowledge of PostgreSQL internals (MVCC, WAL, query planner).
• Experience with backup and recovery tools (pgDump/pgRestore).
• Ability to craft scalable, cost-effective infrastructure designs.

Responsibilities

• Administer, maintain, and optimize PostgreSQL databases across development, test, and production environments.
• Design, implement, and support PostgreSQL high availability, replication, and disaster recovery using Patroni.
• Tune performance, conduct backups, and perform recovery as needed under heavy load.
• Develop and maintain documentation for database infrastructure and processes.
• Collaborate with onsite/offshore teams to ensure 24/7 support coverage.

Skills

PostgreSQL DBA

Linux/Unix

Bash scripting

SQL

Performance tuning

Backups & recovery

High availability

Monitoring/observability

Education

Bachelor’s degree or foreign equivalent

Tools

Patroni

pgDump/pgRestore

CoommVault

Delphix

Qlik Attunity

SolarWinds DPA

PowerShell

Job description

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 organizations 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.

In the assigned Job Role of Infrastructure Consultant 2, your Area Of Responsibility will be as below:

• 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
• Co-ordinate 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

Your contribution to the team:

• 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 optimization opportunities
• Focused approach towards deployment management, system optimization, and process automation initiatives including sector specific focus
• The ability to work with cross-functional teams

Required Skill and Experience

• 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.
• 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 such as: pgDump, pgRestore and tool CoommVault 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 must be available to work exclusively for PST time zone and be prepared to operate on rotating shift schedules to ensure 24/7/365 support coverage which includes weekends and holidays.
• Shift timings:
• Shift 1: 3 AM to 12 PM PST
• Shift 2: 11 AM to 8 PM PST
• Shift 3: 7 PM to 4 AM PST

Preferred Skill and Experience

• Additional experience with SQL Server, MySQL, or MariaDB in mixed database environments is good to have.
• Worked on tools such as: Qlik Attunity, SolarWinds DPA and Delphix is a plus.
• Experience with backup and recovery such as: pgDump, pgRestore and tool CoommVault is good to have.
• PowerShell programming is a bonus.
• Backup and restore tools such as: EMC Networker, CommVault is an added advantage.
• Good Communication and Analytical skills

Additional Required Qualifications

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• This position may require relocation and/or travel to work/project location.
• Candidates authorized to work for any employer in the United States without employer-based visa sponsorship are welcome to apply. Infosys is unable to provide immigration sponsorship for this role now or in the future.

EEO/About Us

Benefits

Along with competitive pay, as a full-time Infosys employee you are also eligible for the following 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

About Us
Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 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.

EEO
Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.