Job Description
Company: Cognizant
Location: Charlotte, NC
Workplace Type: On-site
Employment Type: Full-time
About the Role
As a Senior PostgreSQL DBA, you will be responsible for the administration, performance, availability, security, and operational support of enterprise PostgreSQL environments across Production, UAT, and Development. You will play a key role in designing and maintaining high availability and disaster recovery solutions for mission-critical applications.
What You’ll Do / Key Responsibilities
- Administer and support PostgreSQL databases, ensuring availability, reliability, and capacity planning.
- Design, implement, and maintain backup, recovery, and disaster recovery solutions to meet RPO/RTO targets.
- Design and support high-availability PostgreSQL architectures, including streaming and logical replication.
- Analyze and resolve database performance issues through query optimization, indexing, partitioning, and execution plan analysis.
- Tune PostgreSQL configuration parameters, memory utilization, I/O performance, and autovacuum settings.
- Implement database security standards, user access controls, role management, and compliance requirements.
- Develop automation solutions using Bash, Python, Shell scripting, and PostgreSQL utilities.
- Support database upgrades, migrations, releases, and deployment activities.
Requirements & Qualifications
- 8+ years of experience supporting enterprise PostgreSQL environments.
- Strong expertise with PostgreSQL 14, 15, 16, and 17.
- Extensive experience with streaming replication and logical replication and high availability architecture.
- Proven experience with PostgreSQL performance tuning, query optimization, indexing, and partitioning.
- Linux (RHEL) administration experience.
- Proficiency in Bash, Shell, and Python scripting.
- Hands-on experience with monitoring and observability tools and supporting ITIL-based operational processes (Incident, Change, Problem Management).
Preferred / Bonus Qualifications (if applicable)
- Experience planning and executing PostgreSQL version upgrades.
- Experience supporting cloud migration initiatives and hybrid database environments (AWS, Azure).
- Experience defining database standards, governance controls, and operational best practices.
Benefits & Perks (if applicable)
- Opportunity to work in a collaborative Cloud Infrastructure and Security team.
- Support for a healthy work-life balance through wellbeing programs.
[Work model at Cognizant emphasizes flexibility where possible, but this specific role requires 5 days a week on-site in Charlotte, NC.]