AWS PostgreSQL Database Architect

Cognizant; Raleigh (NC); On-site; USD 81,000 - 142,000; Full time

Benefits offered by this job

Medical/Dental/Vision/Life Insurance

Paid holidays plus PTO

401(k) plan and contributions

Employee Stock Purchase Plan

Job summary

Cognizant has an opening for an AWS PostgreSQL Database Architect to lead design, implementation, and optimisation of enterprise database platforms on AWS in Raleigh, NC. The role focuses on PostgreSQL, RDS for PostgreSQL, Aurora PostgreSQL, cloud migrations, performance tuning, high availability, DR, and database security.

Work involves collaborating with application teams, cloud architects, DevOps, and stakeholders to deliver scalable, secure database solutions supporting mission-critical

Qualifications

• 10+ years in database architecture or enterprise data platforms.
• 5+ years PostgreSQL in large-scale production.
• Deep expertise with Amazon RDS for PostgreSQL & Amazon Aurora.
• Experience designing cloud-native DB solutions on AWS.
• Strong knowledge of performance tuning and indexing.
• IaC: Terraform, CloudFormation, or AWS CDK.
• Hands-on CI/CD and DevOps practices.
• Experience in financial services domain is a plus.

Responsibilities

• Design and implement cloud-native PostgreSQL architectures on AWS.
• Develop architecture blueprints, reference implementations, and docs.
• Collaborate with product owners, devs, and infrastructure teams.
• Define logical/physical data models ensuring data integrity and scalability.
• Review designs to optimise indexing, partitioning, replication.
• Architect high availability and disaster recovery on AWS.

Skills

PostgreSQL

AWS RDS

Aurora PostgreSQL

Cloud migration

Performance tuning

High availability

Disaster recovery

Database security

Tools

Terraform

CloudFormation

AWS CDK

CI/CD

Job description

We are seeking an experienced AWS PostgreSQL Database Architect to lead the design, implementation, optimisation, and modernisation of enterprise database platforms on AWS. The ideal candidate will have deep expertise in PostgreSQL, Amazon RDS for PostgreSQL, Amazon Aurora PostgreSQL, cloud migration strategies, performance tuning, high availability, disaster recovery, and database security.

The Architect will collaborate with application teams, cloud architects, DevOps engineers, and business stakeholders to design and deliver scalable, secure, and highly available database solutions supporting mission-critical business workloads, particularly within financial services and lending domains.

In this role, you will:

• Design and implement cloud-native database architectures using PostgreSQL, Amazon RDS for PostgreSQL, and Amazon Aurora PostgreSQL to support secure, scalable, and high-performance enterprise applications.
• Develop architecture blueprints, reference implementations, and detailed technical documentation covering system components, integration patterns, data flows, and non-functional requirements.
• Collaborate with product owners, business analysts, developers, and infrastructure teams to translate business requirements into solution architectures aligned with enterprise standards.
• Define and validate logical and physical data models, ensuring data integrity, reliability, scalability, and efficient reporting capabilities.
• Review application and database designs to optimise the use of PostgreSQL features, including indexing, partitioning, replication, and connection management.
• Architect highly available and disaster recovery solutions leveraging AWS-native services and best practices to meet business continuity requirements.

Work model

At Cognizant, we strive to provide flexibility wherever possible, and we are here to support a healthy work-life balance though 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 Raleigh NC. Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.

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.

Please note: A few of our roles may require in-person interviews at Cognizant offices or client locations, depending on project or client needs.

What you need to have to be considered

• 10+ years of experience in database architecture, database engineering, or enterprise data platform design.
• 5+ years of hands-on experience with PostgreSQL in large-scale production environments.
• Strong expertise with Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL.
• Proven experience designing and implementing cloud-native database solutions on AWS.
• Deep understanding of PostgreSQL performance tuning, indexing strategies, query optimisation, partitioning, replication, backup and recovery.
• Experience with AWS services including EC2, RDS, Aurora, VPC, IAM, CloudWatch, KMS, S3, Route 53, and AWS Backup.
• Strong knowledge of high availability, disaster recovery, failover architectures, and business continuity planning.
• Experience with Infrastructure as Code tools such as Terraform, CloudFormation, or AWS CDK.
• Hands-on experience with CI/CD pipelines, DevOps practices, and automated infrastructure deployment.

Salary and Other Compensation:

The annual salary for this position is between $ 81337 to $ 141500 depending on experience and other qualifications of the successful candidate. This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits:

Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits 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.