Database Architect (DBA) - Oracle & PostgreSQL

GKP Solutions, Inc.; Indonesia; On-site; IDR 300,000,000 - 600,000,000; Full time

Job summary

GKP Solutions, Inc. seeks an experienced Database Architect (DBA) to lead design, migration, and optimization across Endur and SQMD platforms, including Oracle-to-AWS RDS migrations and Oracle-to-PostgreSQL transformations.

You will drive migration strategies for multi-terabyte databases, ensure high availability with Data Guard, and collaborate with cloud, application, and infrastructure teams to deliver production-ready solutions.

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.
• 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, and backup/recovery strategies.
• Proven SQL/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 migrations to Amazon RDS for Oracle.
• Architect and execute migration strategies for multi-terabyte data.
• Design and maintain Oracle Data Guard for HA/DR.
• Validate data integrity and performance during migration and cutover.
• Collaborate with application, infrastructure, and cloud teams for deployment.

Skills

Oracle 19c administration

AWS RDS for Oracle

Oracle Data Guard

CDC & data migration

SQL/PLSQL development

Cloud migration strategy

Performance tuning

High availability

Stakeholder management

Endur/SQMD platform experience

Education

Bachelor's degree in Computer Science or related field

Tools

Amazon RDS for Oracle

Oracle 19c

PostgreSQL

AWS Cloud 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.