Job description

About the role As a Senior PostgreSQL DBA, you will make an impact by being responsible for the administration, performance, availability, security, and operational support of enterprise PostgreSQL environments. You will play a key role in designing and maintaining high availability and disaster recovery solutions, optimizing database performance, automating operational processes, and ensuring the reliability of mission-critical applications across Production, UAT, and Development environments. You will be a valued member of the Cloud Infrastructure and Security team working collaboratively with the Senior Manager. In this role, you will • Administer and support PostgreSQL databases across Production, UAT, and Development environments. • Ensure database availability, reliability, capacity planning, and operational stability. • Design, implement, and maintain backup, recovery, and disaster recovery solutions to meet business continuity objectives. • Perform backup validations, recovery testing, and disaster recovery drills while maintaining RPO and RTO targets. • Design and support high-availability PostgreSQL architectures, including streaming and logical replication. • Monitor replication health and execute failover and switchover activities when required. • 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. • Monitor and troubleshoot lock contention, blocking sessions, and database wait events. • Implement database security standards, user access controls, role management, and compliance requirements. • Resolve incidents, perform root cause analysis, and support problem and change management processes. • Develop automation solutions using Bash, Python, Shell scripting, and PostgreSQL utilities. • Implement monitoring, alerting, observability, and proactive health-check solutions. • Support database upgrades, migrations, releases, and deployment activities. • Create and maintain operational documentation, runbooks, recovery procedures, and technical standards. • Drive continuous improvement initiatives focused on automation, modernization, operational excellence, and database governance. Work model At Cognizant, we strive to provide flexibility wherever possible, and we are here to support a healthy work-life balance through our various wellbeing programs. Based on this role’s business requirements, this is an onsite position requiring 5 days a week in a client or Cognizant office in Charlotte, NC. The working arrangements for this role are accurate as of the date of posting. This may change based on the project you’re engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations. What you need to have to be considered • 8+ years of experience supporting enterprise PostgreSQL environments. • Strong expertise with PostgreSQL 14, 15, 16, and 17. • Hands-on experience with PostgreSQL backup, recovery, and disaster recovery planning. • Extensive experience with streaming replication and logical replication. • Strong knowledge of high availability and disaster recovery architecture. • Proven experience with PostgreSQL performance tuning, query optimization, indexing, and partitioning. • Linux (RHEL) administration experience. • Proficiency in Bash, Shell, and Python scripting. • Experience with database security, access management, and compliance controls. • Hands-on experience with monitoring and observability tools. • Experience supporting ITIL-based operational processes, including Incident, Change, and Problem Management. • Experience working with ServiceNow or similar ITSM platforms. These will help you stand out • Experience planning and executing PostgreSQL version upgrades. • Experience supporting cloud migration initiatives and hybrid database environments. • Knowledge of AWS, Azure, or other cloud database platforms. • Experience conducting application compatibility and upgrade assessments. • Experience defining database standards, governance controls, and operational best practices. • Strong troubleshooting skills supporting complex production environments. • Experience driving automation and database modernization initiatives. • PostgreSQL, Linux, Cloud, or ITIL certifications. We're excited to meet people who share our mission and can make an impact in a variety of ways. Don't hesitate to apply, even if you only meet the minimum requirements listed. Think about your transferable experiences and unique skills that make you stand out. Additional employment information Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law. Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview. Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, state or local laws. Applicants for US based positions must be currently authorized to work for any employer in the United States. The company is unable to provide employment-based immigration sponsorship for US based positions. If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email CareersNA2@cognizant.com for roles based in the Americas or CareersIndia2@cognizant.com for roles based in India. About Cognizant: Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, bridging the gap between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, drive tangible outcomes and keep global enterprises ahead in a fast-changing world. See how at cognizant.ai or @cognizant.

Requirements

Must-haves

In this role, you will
Administer and support PostgreSQL databases across Production, UAT, and Development environments.
Ensure database availability, reliability, capacity planning, and operational stability.
Design, implement, and maintain backup, recovery, and disaster recovery solutions to meet business continuity objectives.
Perform backup validations, recovery testing, and disaster recovery drills while maintaining RPO and RTO targets.
Design and support high-availability PostgreSQL architectures, including streaming and logical replication.
Monitor replication health and execute failover and switchover activities when required.
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.
Monitor and troubleshoot lock contention, blocking sessions, and database wait events.
Implement database security standards, user access controls, role management, and compliance requirements.
Resolve incidents, perform root cause analysis, and support problem and change management processes.
Develop automation solutions using Bash, Python, Shell scripting, and PostgreSQL utilities.
Implement monitoring, alerting, observability, and proactive health-check solutions.
Support database upgrades, migrations, releases, and deployment activities.
Create and maintain operational documentation, runbooks, recovery procedures, and technical standards.
Drive continuous improvement initiatives focused on automation, modernization, operational excellence, and database governance.
What you need to have to be considered
8+ years of experience supporting enterprise PostgreSQL environments.
Strong expertise with PostgreSQL 14, 15, 16, and 17.
Hands-on experience with PostgreSQL backup, recovery, and disaster recovery planning.
Extensive experience with streaming replication and logical replication.
Strong knowledge of high availability and disaster recovery architecture.
Proven experience with PostgreSQL performance tuning, query optimization, indexing, and partitioning.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

pythonrestawsazureai

Platform: cognizant
Effort: medium