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 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)
高知特(Cognizant)（纳斯达克代码：CTSH）作为一家AI Builder和相关技术服务提供商，致力于通过打造全栈AI解决方案，帮助企业将人工智能投资转化为实际价值。公司凭借深厚的行业经验、流程优化和工程技术专长，将企业独特的业务场景融入科技系统，赋能组织释放人才潜能，推动切实成果，并帮助全球企业在瞬息万变的环境中保持领先。如需了解更多详情，敬请访问 cognizant.ai 或关注@cognizant。
补充雇佣信息
薪酬信息截至本职位发布之日为准。Cognizant 保留在适用法律允许的范围内随时修改该信息的权利。
申请人可能需要通过现场面试或视频会议的方式参加面试。此外，候选人在每次面试时可能需要出示其当前所在州或政府签发的有效身份证件。
Cognizant 是一家提供平等就业机会的雇主。在招聘过程中，您的申请和候选资格不会因种族、肤色、性别、宗教、信仰、性取向、性别认同、国籍、残疾、遗传信息、怀孕、退伍军人身份或任何其他受联邦、州或地方法律保护的特征而受到影响。
