Aurora Postgres Data Architect (Also Open For Gurgaon)

Tata Consultancy Services; India; On-site; INR 1,800,000 - 3,600,000; Full time

Job summary

Tata Consultancy Services in India seeks an experienced database architect to design and implement scalable, resilient database solutions using Aurora PostgreSQL.

You will define data architecture standards, lead modeling efforts, optimize performance and indexing, ensure security and governance, and mentor DB engineers while driving automation and cost efficiency.

Responsibilities

• Design and architect scalable and resilient database solutions.
• Define data architecture standards, models, and governance frameworks.
• Lead database design activities including data modeling (conceptual, logical, physical); optimize performance and indexing.
• Implement high availability, replication, backup, and disaster recovery; design data migration strategies (on-prem to cloud).
• Ensure data security, encryption, compliance, and access control; collaborate with development teams on schema design.
• Monitor and optimize performance, costs, and capacity; implement automation for provisioning and operations.
• Provide technical leadership and mentor DB engineers.

Job description

Role & responsibilities

• Design and architect highly scalable and resilient database solutions using Aurora PostgreSQL.
• Define data architecture standards, models, and governance frameworks.
  
• Lead database design activities including data modeling (conceptual, logical, physical)
  Optimize database performance, query tuning, and indexing strategies.
• Implement high availability, replication, backup, and disaster recovery mechanisms. Design and manage data migration strategies (on-prem to cloud or cross-platform).
  
• Ensure data security, encryption, compliance, and access control. Work with development teams to define best practices for database interaction and schema design.
  
• Monitor and optimize database performance, cost, and capacity planning Implement automation for database provisioning and operations.
• Provide technical leadership and mentor DB engineers.