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

Vertafore; Hyderabad; On-site; INR 1,800,000 - 3,000,000; Full time

Benefits offered by this job

Medical, vision & dental plans

Life, AD&D and disability insurance

Pension Plan with employer match

Parental Leave

Job summary

Vertafore seeks a Cloud Database Architect to design scalable, highly available database platforms on AWS and lead migrations and modernization efforts. You will establish Terraform standards for database provisioning, build reusable modules, and drive automation across provisioning, backups, and upgrades.

Strong performance tuning and DR expertise are required. The role combines strategic architecture with hands-on implementation, requiring 15+ years in database domains and 2+ years of

Qualifications

• 15+ years in Database Administration, Engineering, or Architecture with Oracle or PostgreSQL expertise.
• 2+ years hands-on Terraform experience, from scratch.
• Strong Terraform providers, state management, remote backends, drift detection, CI/CD integration.
• 2+ years hands-on AWS experience supporting database workloads on RDS, RDS Custom, and EC2.
• 5+ years hands-on database performance tuning experience (execution plans, SQL tuning, AWR/ASH).
• End-to-end database architecture, migration, modernization, and cloud transformation experience.
• Experience designing High Availability and Disaster Recovery solutions.
• Experience leading large-scale database upgrades and migration initiatives.
• Excellent communication and stakeholder management skills.

Responsibilities

• Design, develop, and maintain Terraform modules for database infrastructure.
• Troubleshoot Terraform state, drift, and deployment issues across AWS environments.
• Automate provisioning, patching, upgrades, backups, and operations.
• Lead cloud migrations, upgrades, and modernization initiatives.
• Evaluate migrations technologies like Data Pump, RMAN, Data Guard, GoldenGate, AWS DMS.
• Lead troubleshooting of complex database performance issues.
• Analyze execution plans, AWR/ASH, 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

Database architecture

Oracle

PostgreSQL

Terraform

AWS

Performance tuning

Tools

Terraform

AWS

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.

Required Qualifications

• 15+ years of experience in Database Administration, Engineering, or Architecture with strong expertise in Oracle or PostgreSQL databases.
• 2+ years of hands-on Terraform experience, including designing and building Terraform modules and configurations from scratch.
• Strong understanding of Terraform providers, state management, remote backends, drift detection, workspaces, and CI/CD integration.
• 2+ years of hands‑on AWS experience supporting database workloads on Amazon RDS, RDS Custom, and EC2.
• 5+ years of hands‑on database performance tuning experience, including execution plan analysis, SQL tuning, AWR, ASH, SQL Profiles, and root cause analysis.
• Strong end‑to‑end database architecture, migration, modernization, and cloud transformation experience.
• Experience designing and implementing High Availability and Disaster Recovery solutions.
• Experience leading large‑scale database upgrades and migration initiatives.
• Excellent communication and stakeholder management skills.

Preferred

• AWS & Database certifications

Why Vertafore is the place for you:

*Canada Only

• The opportunity to work in a space where modern technology meets a stable and vital industry
• Medical, vision & dental plans
• Life, AD&D
• Short Term and Long Term Disability
• Pension Plan & Employer Match
• Maternity, Paternity and Parental Leave
• Employee and Family Assistance Program (EFAP)
• Education Assistance
• Additional programs - Employee Referral and Internal Recognition

Why Vertafore is the place for you:

*US Only

• The opportunity to work in a space where modern technology meets a stable and vital industry
• We have a Flexible First work environment! Our North America team members use our offices for collaboration, community and team-building, with members asked to sometimes come into an office and/or travel depending on job responsibilities. Other times, our teams work from home or a similar environment.
• Medical, vision & dental plans
  • PPO & high-deductible options
• Health Savings Account & Flexible Spending Accounts Options:
  • Health Care FSA
  • Dental & Vision FSA
  • Dependent Care FSA
  • Commuter FSA
• Life, AD&D (Basic & Supplemental), and Disability
• 401(k) Retirement Savings Plain & Employer Match
• Supplemental Plans - Pet insurance, Hospital Indemnity, and Accident Insurance
• Parental Leave & Adoption Assistance
• Employee Assistance Program (EAP)
• Education & Legal Assistance
• Additional programs - Tuition Reimbursement, Employee Referral, Internal Recognition, and Wellness
• Commuter Benefits (Denver)

The selected candidate must be legally authorized to work in the United States.

The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all the job responsibilities, duties, skill, or working conditions. In addition, this document does not create an employment contract, implied or otherwise, other than an "at will" relationship.

Vertafore strongly supports equal employment opportunity for all applicants regardless of race, color, religion, sex, gender identity, pregnancy, national origin, ancestry, citizenship, age, marital status, physical disability, mental disability, medical condition, sexual orientation, genetic information, or any other characteristic protected by state or federal law.

The Professional Services (PS) and Customer Success (CX) bonus plans are a quarterly monetary bonus plan based upon individual and practice performance against specific business metrics. Eligibility is determined by several factors including: start date, good standing in the company, and actives status at time of payout.

The Vertafore Incentive Plan (VIP) is an annual monetary bonus for eligible employees based on both individual and company performance. Eligibility is determined by several factors including: start date, good standing in the company, and actives status at time of payout.

Commission plans are tailored to each sales role but common components include quota, MBO's and ABPMs. Salespeople receive their formal compensation plan within 30 days of hire.

Vertafore is a drug free workplace and conducts preemployment drug and background screenings.

We do not accept resumes from agencies, headhunters or other suppliers who have not signed a formal agreement with us.

We want to make sure our recruiting process is accessible for everyone. if you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact [e-mail]

Just a note, this contact information is for accommodation requests only.