JD for PostgreSQL DBA – SA Level (L3 Resource)

Mandatory skills (please enter all mandatory skills customer will look for)

This position is responsible for the maintenance and security of Oracle and Postgresql development, testing, and production database environments. The DBA plans back-up and recoveries, disaster recoveries, and maintenance of the data schema. The DBA works closely with other teams, so components of the system integrate accurately with the data framework

· Clear understanding of oracle Database Architecture

· Clear understanding of Postgresql, Database administration

· Experience in export-import, RMAN

· Experience in Hot and cold Backup and restoration

· Experience in Database patching, Database upgrade, Database Migration

· Experience in performance tuning

· Knowledge of SQL

· Ability to do capacity planning and DB configuration for high performance

· Good in Linux/unix command

· Excellent communication Skills written & verbal

· Open for 24/7 shifts

· Goldengate knowledge is added advantage

· Any other DB (MSSQL/MYSQL) knowledge is added advantage

· Any Scripting knowledge (shell/python/powershell) is added advantage

· Any cloud knowledge (AWS/Azure/GCP) is added advantage

· Install, upgrade, migrate PostgreSQL rdbms, database, cluster

· Strong knowledge in Database architecture

· Expertise in database high availability and disaster recovery solutions

· Strong knowledge on replication setup

· Database troubleshooting and expertise in proactive and reactive database performance optimization

· Expertise in Database Backup and Recovery

· Design/ Redesign the physical architecture to meet client’s requirement to provide optimum performances

· Manage the minor and major upgrades

· Resolve difficult/complex incidents affecting the operation/availability of high-profile production databases and handle the escalations.

· Working knowledge on AWS cloud (RDS)

· Manage the complete Release Cycle from database perspective.

· Involve in Automation and new ideas to make the process optimization to meet the unit and customer goals.

· Participate in the planning, preparation, and execution of, regular and other mission critical activities.

· Knowledge of ITIL process to cater process like Incident management, problem management, change management and release management.

· Identify and maintain Performance metric of databases, operation Lesson learned and RCA reporting and assist in development plan from them.

· Plan and implement medium to high-risk changes on high profile production PostgreSQL databases

· Analyze and assess the impact and risk of low to medium risk changes on high profile production databases

· Motivated to keep learning new technologies.

· Documenting all the production changes and standard operation

The Cognizant community:
We are a high caliber team who appreciate and support one another. Our people uphold an energetic, collaborative and inclusive workplace where everyone can thrive.

Cognizant is a global community with more than 300,000 associates around the world. We don’t just dream of a better way – we make it happen. We take care of our people, clients, company, communities and climate by doing what’s right. We foster an innovative environment where you can build the career path that’s right for you.

About us:
Cognizant is one of the world's leading professional services companies, transforming clients' business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant (a member of the NASDAQ-100 and one of Forbes World’s Best Employers 2024) is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com

Our commitment to diversity and inclusion:
Cognizant is an equal opportunity employer that embraces diversity, champions equity and values inclusion. We are dedicated to nurturing a community where everyone feels heard, accepted and welcome. 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 protected characteristic as outlined by federal, state or local laws.

Disclaimer: 
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.