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

Vertafore Career Center; Hyderabad; On-site; INR 3,000,000 - 6,000,000; Full time

Job summary

Vertafore Career Center seeks a Cloud Database Architect with deep database expertise, strong Infrastructure as Code experience, and hands-on AWS database platform knowledge. The ideal candidate will design Terraform solutions from the ground up, lead complex migrations, and drive performance optimization to deliver highly available database platforms on AWS.

This role requires both strategic architecture skills and hands-on implementation experience, with a focus on automation, reliability, and

Qualifications

• Hands-on experience with Terraform for database infra provisioning.
• Experience leading database migrations and upgrades.
• Strong AWS database platform knowledge.
• Proven ability to optimize performance and ensure reliability.

Responsibilities

• Design, develop, and maintain Terraform modules for database infrastructure.
• Troubleshoot Terraform state, drift, and deployment issues across AWS environments.
• Drive automation of provisioning, patching, upgrades, backups, and operations.
• Lead cloud migration, upgrade, and modernization initiatives."
• Evaluate and implement migration technologies including Data Pump, RMAN, Data Guard, GoldenGate, and AWS DMS.
• Lead troubleshooting and resolution of complex database performance issues.

Skills

Terraform

AWS

Database architecture

Infrastructure as Code

Automation

Migration

Tools

GoldenGate

RMAN

AWS DMS

Data Pump

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.