Database Architect(Oracle, PostgreSQL, AWS, Performance Tuning, Terraform)

Hirebridge LLC; Hyderabad; On-site; INR 1,620,000 - 1,980,000; Full time

Job summary

Hirebridge LLC seeks a Cloud Database Architect with deep Terraform and AWS database platform expertise. The role emphasizes building from ground up Terraform solutions for highly available, resilient database platforms on AWS, while leading migrations and upgrades with minimal business disruption.

Candidate will drive automation, optimization, and established standards for provisioning, backups, and lifecycle management, delivering scalable database architectures and robust DR plans.

Qualifications

• Ground-up Terraform-based database infrastructure design experience.
• Lead complex database migrations and upgrades with minimal business disruption.
• Drive performance optimization initiatives and ensure scalable, highly available AWS database platforms.

Responsibilities

• Design, develop, and maintain Terraform modules and deployment standards for database infrastructure.
• Troubleshoot Terraform state, drift, and deployment issues across AWS environments.
• Drive automation of provisioning, patching, upgrades, backups, and operational activities.
• Lead cloud migration, upgrade, and modernization initiatives.
• Evaluate and implement migration technologies such as Data Pump, RMAN, Data Guard, GoldenGate, and AWS DMS.
• Lead troubleshooting and resolution of complex database performance issues.
• Analyze execution plans, AWR/ASH reports, wait events, and tuning opportunities.
• Establish performance standards and best practices across database platforms.
• Design and validate high availability and disaster recovery solutions.
• Define backup, recovery, and business continuity standards.
• Provide technical leadership during major incidents and recovery events.

Skills

Terraform

AWS

Database architecture

Migration planning

Performance tuning

Automation

Disaster recovery

Tools

Data Pump

RMAN

Data Guard

GoldenGate

AWS DMS

Job description

We are seeking a Cloud Database Architect with deep database expertise, strong Infrastructure as Code experience, and hands-on AWS database platform knowledge. The ideal candidate will have proven experience designing Terraform solutions from the ground up rather than simply executing or maintaining existing pipelines, leading complex database migrations and upgrades, driving performance optimization initiatives, and architecting highly available and resilient database platforms on AWS. This role requires both strategic architecture skills and hands-on implementation experience

Key Outcomes (What Success Looks Like)

• Establish and drive Terraform standards for database infrastructure provisioning, enabling repeatable, secure, and auditable deployments across AWS environments.
• Establish Terraform standards and reusable infrastructure modules for database platforms.
• Deliver scalable, secure, and highly available database architectures on AWS.
• Lead database migration, upgrade, and modernization initiatives with minimal business disruption.
• Improve database performance and operational reliability through proactive tuning and automation.
• Drive automation and operational excellence across provisioning, upgrades, backup/recovery, and database lifecycle management.

Core Responsibilities

• Design, develop, and maintain Terraform modules and deployment standards for database infrastructure.
• Troubleshoot Terraform state, drift, and deployment issues across AWS environments.
• Drive automation of provisioning, patching, upgrades, backups, and operational activities.
• Lead cloud migration, upgrade, and modernization initiatives.
• Evaluate and implement appropriate migration technologies including Data Pump, RMAN, Data Guard, GoldenGate, and AWS DMS.
• Lead troubleshooting and resolution of complex database performance issues.
• Analyze execution plans, AWR/ASH reports, wait events, and tuning opportunities.
• Establish performance standards and best practices across database platforms.
• Design and validate high availability and disaster recovery solutions.
• Define backup, recovery, and business continuity standards.
• Provide technical leadership during major incidents and recovery events.