Aurora Postgres Data Architect

Tata Consultancy Services; India; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

Tata Consultancy Services is seeking an experienced Aurora PostgreSQL Data Architect to design, optimize, and manage enterprise-scale database solutions on AWS. The role demands deep expertise in Aurora PostgreSQL, data modeling, migration strategies, and cloud-native database governance.

The candidate will lead modernization efforts, architect scalable multi-region solutions, and collaborate with development and cloud teams to ensure resilient data platforms. Immediate joiners preferred.

Qualifications

• 10+ years IT experience with database architectures.
• Expertise in Aurora PostgreSQL and PostgreSQL administration.
• Experience in cloud migrations and modernization projects.
• Strong SQL, PL/pgSQL, indexing, and performance tuning.
• Knowledge of backup, replication, DR strategies.
• Understanding of cloud security and governance.
• Familiarity with IaC tools like Terraform or CloudFormation.

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.

Skills

Aurora PostgreSQL Administration

Database Architecture

Data Modeling

SQL & PL/pgSQL

Performance Tuning

Backup & DR

Cloud Security

Migration & Modernization

IaC & Cloud Governance

AWS Services Knowledge

Tools

Aurora PostgreSQL

RDS

DMS

EC2

S3

IAM

CloudWatch

Lambda

Terraform

CloudFormation

Job description

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)