Aurora Postgres Data Architect

Role & responsibilities

Immediate Hiring | Aurora PostgreSQL Data Architect

Job Title: Aurora PostgreSQL Data Architect

Experience: 8+ Years

Location:India

Notice Period: Immediate Joiners or Candidates Serving Notice Period (0-30 Days)

Preferred candidate profile

Job Summary

We are seeking an experienced Aurora PostgreSQL Data Architect to design, optimize, and manage enterprise-scale database solutions on AWS. The ideal candidate should possess deep expertise in Amazon Aurora PostgreSQL, database architecture, migration strategies, performance tuning, data modeling, and cloud-native database solutions.

Key Responsibilities

Design and implement scalable, highly available database architectures using Aurora PostgreSQL.

Lead database modernization and migration initiatives from Oracle, SQL Server, MySQL, or PostgreSQL to Aurora PostgreSQL.

Define data models, database standards, and governance frameworks.

Optimize database performance, security, backup, recovery, and disaster recovery strategies.

Architect high-availability and multi-region database solutions.

Collaborate with development, cloud, and infrastructure teams to deliver data-driven solutions.

Monitor database health and troubleshoot complex production issues.

Drive database best practices, automation, and capacity planning.

Required Skills

Strong experience with Amazon Aurora PostgreSQL and PostgreSQL Administration.

Expertise in Database Architecture and Data Modeling.

Hands-on experience with AWS services including:

Aurora PostgreSQL

RDS

DMS

EC2

S3

IAM

CloudWatch

Lambda

Experience in database migration and modernization projects.

Strong knowledge of SQL, PL/pgSQL, partitioning, indexing, and performance tuning.

Experience with backup, replication, failover, and disaster recovery strategies.

Understanding of cloud security and database governance.

Experience with Infrastructure as Code (Terraform/CloudFormation) is preferred.

Preferred Skills

AWS Solution Architecture experience

Data Warehousing & ETL Concepts

PostgreSQL Replication & High Availability

DevOps and CI/CD Integration

Agile Methodologies

Mandatory Requirements

10+ Years of IT Experience

Strong Aurora PostgreSQL Architecture Experience

AWS Cloud Expertise

Database Migration Experience

Immediate Joiners Preferred

Serving Notice Period Candidates Only (0-30 Days)

Perks and benefits