PostgresSQL DBA

About the group:

Cognizant’s Cloud, Infrastructure, and Security Services Practice (CIS), is all about accepting digital transformation by driving core modernization holistically across layers. We help customers transform infrastructure and workplace to meet the constantly evolving needs of the digital era. Our broad approach delivers key results for our customers by achieving cloud driven modernization and workplace and operational transformation to own the business in a secure environment.

This is a remote opportunity within the US. Candidate must be currently living in the US and must have valid work authorization. We are unable to offer any visa sponsorship.

·The salary range for this role will be between $70,000 and $92,000 depending on skills and experience of the candidate.

Applications will be accepted until 10/10/2025.

Role Title PostgresSQL DBA

Key Responsibilities:

• Install, configure, and maintain PostgreSQL database clusters in production and non-production environments.
• Design and implement high availability (HA) and failover solutions using Patroni and etcd/Consul.
• Perform regular vacuuming and reindexing to maintain database health and performance.
• Develop and manage backup and recovery strategies using tools like pgBackRest, Barman, or native PostgreSQL utilities.
• Monitor database performance and tune queries, indexes, and configurations for optimal throughput and latency.
• Implement and manage Kerberos-based authentication and other security best practices.
• Automate routine DBA tasks using scripting (Bash, Python, etc.).
• Collaborate with development and infrastructure teams to support application requirements.
• Troubleshoot database-related issues and provide 24x7 support for critical incidents.
• Maintain documentation for database architecture, procedures, and standards.

Required Skills & Qualifications:

• 8+ years of experience as a PostgreSQL DBA in production environments.
• Strong hands-on experience with Patroni HA, PostgreSQL streaming replication, and failover mechanisms.
• Deep understanding of PostgreSQL internals, autovacuum, and transaction management.
• Proficiency in backup and recovery tools and strategies.
• Experience with performance tuning, query optimization, and indexing strategies.
• Familiarity with Kerberos authentication and integration with PostgreSQL.
• Strong Linux/Unix administration skills.
• Scripting experience (Bash, Python, or similar).
• Excellent problem-solving and communication skills.

Preferred Qualifications:

• Experience with cloud-based PostgreSQL (e.g., AWS RDS, Azure Database for PostgreSQL).
• Familiarity with containerized environments (Docker, Kubernetes).
• Exposure to monitoring tools like Prometheus, Grafana, or pg_stat_statements.
• PostgreSQL certification is a plus.

Benefits:

Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

Medical/Dental/Vision/Life Insurance. Paid holidays plus Paid Time Off. 401(k) plan and contributions. Long-term/Short-term Disability. Paid Parental Leave. Employee Stock Purchase Plan. Eligible for Cognizant’s discretionary annual incentive program, based on performance and subject to the terms of Cognizant’s applicable plans.