Database Architect (DBA)

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

We are seeking an experienced Database Architect (DBA) to support a large-scale enterprise data modernization initiative across the Endur and SQMD platforms. This role will lead the design, migration, conversion, and optimization of critical database environments, including Oracle-to-AWS RDS migrations and Oracle-to-PostgreSQL transformations. The ideal candidate will bring deep expertise in database architecture, cloud migration strategies, performance tuning, high availability, and large-scale data conversions.

Duration: 53 Weeks

Employment Type: Full-Time

Primary Platforms: Endur & SQMD

Key Responsibilities

Endur Database Migration

• Lead the migration of Endur Oracle 19c databases to Amazon RDS for Oracle.
• Architect and execute migration strategies for approximately 3TB of data utilizing reload and Change Data Capture (CDC) methodologies.
• Design and maintain Oracle Data Guard solutions to support high availability and disaster recovery requirements.
• Validate data integrity, performance, and operational readiness throughout migration and cutover activities.
• Collaborate with application, infrastructure, and cloud teams to ensure successful deployment and transition.

SQMD Database Conversion

• Lead the conversion of SQMD Oracle databases to Amazon RDS PostgreSQL.
• Perform schema assessments and conversion planning.
• Execute schema transformation and database object migration.
• Analyze and remediate SQL, PL/SQL, stored procedures, functions, and application code impacted by platform conversion.
• Optimize PostgreSQL database performance, indexing, and query execution plans.

Architecture & Strategy

• Develop database architecture standards, migration roadmaps, and best practices.
• Design scalable, secure, and highly available cloud database solutions.
• Conduct performance analysis and capacity planning.
• Create migration runbooks, operational procedures, and technical documentation.
• Support testing, validation, and production cutover activities.

Required 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
• Change Data Capture (CDC)
• Backup and recovery strategies
• Performance tuning and database 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.

Preferred Qualifications

• Experience supporting Endur and/or commodity trading platforms.
• Experience with SQMD environments.
• AWS Certification(s).
• PostgreSQL administration and architecture expertise.
• Experience with database automation and DevOps practices.
• Familiarity with enterprise data integration and modernization programs.