Senior Cloud DB Architect: Oracle to PostgreSQL & RDS Migrations

GKP Solutions, Inc.; Philippines; On-site; PHP 900,000 - 1,300,000; Full time

Job summary

GKP Solutions, Inc. is seeking an experienced Database Architect (DBA) to lead enterprise data modernization across Endur and SQMD platforms.

You will design and migrate Oracle environments to AWS RDS and convert to PostgreSQL, ensuring high availability and performance. Responsibilities include driving large-scale migrations, tuning, and crafting runbooks, with collaboration across application, infrastructure, and cloud teams.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 8+ years of database administration and architecture experience.
• Deep expertise with Oracle Database 19c administration and architecture.
• Hands-on experience with Amazon RDS for Oracle.
• Experience leading large-scale database migrations involving multi-terabyte environments.
• Strong knowledge of Oracle Data Guard, CDC, backups and recovery, performance tuning, and optimization.
• Experience converting Oracle databases to PostgreSQL.
• Strong SQL and PL/SQL development and remediation experience.
• Experience with AWS cloud services and database migration tools.
• Excellent troubleshooting, communication, and stakeholder management skills.

Responsibilities

• Lead Endur Oracle 19c migration to Amazon RDS for Oracle, including design and execution of migration strategies for multi-terabyte data.
• Architect and implement Oracle Data Guard for high availability and disaster recovery.
• Validate data integrity and performance during migration and cutover activities.
• Collaborate with application, infrastructure, and cloud teams to ensure successful deployment and transition.
• Lead SQMD Oracle-to-PostgreSQL conversions including schema transformation and object migration.
• Optimize PostgreSQL performance, indexing, and query plans.
• Develop migration runbooks, procedures, and technical documentation.

Skills

Oracle 19c

RDS for Oracle

PostgreSQL

Cloud migrations

Data Guard

CDC

Performance tuning

SQL/PLSQL

Education

BSc Computer Science

Tools

Oracle 19c

Amazon RDS

AWS services

Job description

GKP Solutions, Inc. is seeking an experienced Database Architect (DBA) to lead enterprise data modernization across Endur and SQMD platforms.

You will design and migrate Oracle environments to AWS RDS and convert to PostgreSQL, ensuring high availability and performance. Responsibilities include driving large-scale migrations, tuning, and crafting runbooks, with collaboration across application, infrastructure, and cloud teams.