**We're hiring!** At Cognizant we have an idóneo opportunity for you to be part of one of the largest companies in the digital sector worldwide. A Great Place To Work where we look for people who contribute new ideas, experiencing a dynamic and growing environment. At Cognizant we promote an inclusive culture, where we value different perspectives providing career growth and development opportunities. #WelcomeToCognizant! **Job Description: PostgreSQL Database Administrator** **About the Role** We are seeking an experienced **PostgreSQL Database Administrator** to support and maintain enterprise AWS database infrastructure. This role is primarily **support and advisory** in nature - working closely with application teams to troubleshoot issues, implementing changes, guide migrations, and ensure database stability. The ideal candidate brings deep PostgreSQL architecture knowledge, hands-on AWS experience, and strong operational discipline. **Key Responsibilities** + Administer and maintain **PostgreSQL** and **RDS PostgreSQL** instances across dev, test, QA, and production environments + **Support application teams** in troubleshooting database issues, replication failures, connectivity problems, and performance degradation + Assist app teams in resolving **AWS DMS** issues including task failures, CDC lag, table errors, and cutover coordination + Deploy and manage database infrastructure using **AWS CloudFormation** templates + Monitor database health, set up alarms, and analyze logs using **Amazon CloudWatch** and **CloudWatch Log Insights** + Audit database activity and support compliance reviews using **AWS CloudTrail** + Troubleshoot and resolve **logical replication** issues including lag, slot bloat, and subscription failures + Manage **roles, users, schemas, and privileges** across multiple databases and environments + Tune query performance using execution plans, auto_explain, parameter group optimization, and session management + Raise, track,



and resolve incidents and change requests through **ServiceNow** (ITSM) + Perform DBA operations on **Linux** environments including log analysis, file management, and Shell/Python based automation + Support **SDE/ArcGIS geodatabase** environments hosted on Aurora PostgreSQL + Maintain documentation and runbooks for database operations and incident resolution + Perform minor and major Aurora PostgreSQL version upgrades including pre-upgrade assessments, snapshot backups, parameter group validation, extension compatibility checks, and post-upgrade monitoring + Coordinate and document all upgrade activities through ServiceNow change requests with rollback plans and CAB approval **Required Skills** + Strong understanding of **PostgreSQL architecture** - WAL, MVCC, autovacuum, connection pooling, replication slots and partitioning + Hands-on experience with **AWS DMS** - troubleshooting task failures, CDC replication issues, and supporting app teams through migration challenges + Proficiency with **AWS CloudFormation** for infrastructure-as-code + Experience with **Amazon CloudWatch** - dashboards, metrics, log insights, and alarm configuration + Familiarity with **AWS CloudTrail** for auditing API activity and compliance + Solid knowledge of **PostgreSQL security** - roles, schemas, privileges, and access control + Experience with **ServiceNow** for incident management, change requests, and ITSM workflows + Comfortable working in **Linux** environments - log parsing, shell scripting, file operations, and CLI-based database administration + Ability to write **PL/pgSQL** , dynamic SQL,



and maintenance automation scripts **Good to Have** + Familiarity with **SDE/ArcGIS geodatabases** on PostgreSQL + Knowledge of **logical replication** setup (publications, subscriptions) + Experience working with **CyberArk Vault** **Soft Skills** + Strong communicator - able to guide and advise application teams clearly during incidents + Comfortable working within formal **change advisory (CAB)** processes + Self-driven and capable of managing multiple concurrent support requests independently **Why Cognizant?** _Improve your career in one of the largest and fastest growing IT services providers worldwide_ _Receive ongoing support and funding with training and development plans_ _Have a highly competitive benefits and salary package_ _Get the opportunity to work for leading global companies_ _We are committed to respecting human rights and build a better future by helping your minds and the environment_ _We invest in people and their wellbeing._ _We create conditions for everyone to thrive. We do not discriminate based on race, religion, color, sex, age, disability, nationality, sexual orientation, gender identity or expression, or for any other reason covered._ **_Igualdad de Empleo y Política de Acción Afirmativa:_** _Cognizant es un empleador que ofrece igualdad de oportunidades. Todos los solicitantes calificados recibirán consideración para el empleo sin distinción de sexo, identidad de género, orientación sexual, raza, color, religión, origen nacional, discapacidad, estado de veterano protegido, edad o cualquier otra característica protegida por la ley._ _At Cognizant we believe than our culture make us stronger!_ _Join us now!_ #BeCognizant #IntuitionEngineered Cognizant is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.

📌 Postgres SQL Database Administrator (Ciudad de México)
🏢 Cognizant
📍 Ciudad de México