31 jul
|
Cognizant
|
Ciudad de México
31 jul
Cognizant
Ciudad de México
We’re hiring!At Cognizant we have an ideal 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 AdministratorAbout the RoleWe 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 adecuado candidate brings deep PostgreSQL architecture knowledge, hands-on AWS experience, and strong operational discipline.Key ResponsibilitiesAdminister and maintain PostgreSQL and RDS PostgreSQL instances across dev, test, QA, and production environmentsSupport application teams in troubleshooting database issues, replication failures, connectivity problems, and performance degradationAssist app teams in resolving AWS DMS issues including task failures, CDC lag, table errors, and cutover coordinationDeploy and manage database infrastructure using AWS CloudFormation templatesMonitor database health, set up alarms, and analyze logs using Amazon CloudWatch and CloudWatch Log InsightsAudit database activity and support compliance reviews using AWS CloudTrailTroubleshoot and resolve logical replication issues including lag, slot bloat, and subscription failuresManage roles, users, schemas, and privileges across multiple databases and environmentsTune query performance using execution plans, auto_explain, parameter group optimization,
and session managementRaise, 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 automationSupport SDE/ArcGIS geodatabase environments hosted on Aurora PostgreSQLMaintain documentation and runbooks for database operations and incident resolutionPerform minor and major Aurora PostgreSQL version upgrades including pre-upgrade assessments, snapshot backups, parameter group validation, extension compatibility checks, and post-upgrade monitoringCoordinate and document all upgrade activities through ServiceNow change requests with rollback plans and CAB approvalRequired SkillsStrong understanding of PostgreSQL architecture — WAL, MVCC, autovacuum, connection pooling, replication slots and partitioningHands‑on experience with AWS DMS — troubleshooting task failures, CDC replication issues, and supporting app teams through migration challengesProficiency with AWS CloudFormation for infrastructure-as-codeExperience with Amazon CloudWatch — dashboards, metrics, log insights, and alarm configurationFamiliarity with AWS CloudTrail for auditing API activity and complianceSolid knowledge of PostgreSQL security — roles, schemas, privileges, and access controlExperience with ServiceNow for incident management, change requests, and ITSM workflowsComfortable working in Linux environments — log parsing,
shell scripting, file operations, and CLI-based database administrationAbility to write PL/pgSQL, dynamic SQL, and maintenance automation scriptsGood to HaveFamiliarity with SDE/ArcGIS geodatabases on PostgreSQLKnowledge of logical replication setup (publications, subscriptions)Experience working with CyberArk VaultSoft SkillsStrong communicator — able to guide and advise application teams clearly during incidentsComfortable working within formal change advisory (CAB) processesSelf-driven and capable of managing multiple concurrent support requests independentlyWhy Cognizant?Improve your career in one of the largest and fastest growing IT services providers worldwideReceive ongoing support and funding with training and development plansHave a highly competitive benefits and salary packageGet the opportunity to work for leading global companiesWe are committed to respecting human rights and build a better future by helping your minds and the environmentWe 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!#BeCognizant #IntuitionEngineered#J-18808-Ljbffr
📌 Postgres Sql Database Administrator (Ciudad de México)
🏢 Cognizant
📍 Ciudad de México