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

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.