Senior Oracle-to-Postgres Data Migration Engineer

IKAS INTERNATIONAL (ASIA) PTE. LTD.; Singapore; On-site; SGD 180,000 - 240,000; Full time

Job summary

IKAS International (Asia) Pte Ltd is seeking a hands‑on Database Engineer to modernise a large‑scale platform by migrating legacy Oracle databases to PostgreSQL while ensuring data integrity, minimal downtime, and reliable performance.

You will lead end‑to‑end data migration, reverse‑engineering legacy logic, optimize queries and configurations, and ensure disaster recovery and high availability. The role requires deep Oracle expertise and strong PostgreSQL experience in production environments.

Qualifications

• 10+ years hands‑on database engineering, DBA, or data engineering in production environments.
• Strong Oracle expertise and PostgreSQL experience, ideally Oracle‑to‑PostgreSQL migrations.
• Proven experience with large‑scale data migration, reconciliation, and production cutovers.
• Strong SQL, query tuning, performance optimization, and database troubleshooting skills.
• Experience with replication and CDC tools such as Oracle GoldenGate or AWS DMS.
• Experience with AWS RDS, Aurora, backup/recovery, high availability, and disaster recovery.
• Scripting proficiency in Python, Bash, or similar.
• Knowledge of database security, access controls, encryption, and data masking.

Responsibilities

• Lead end‑to‑end data migration, including ETL, reconciliation, cutover, and rollback planning.
• Reverse‑engineer undocumented business logic from legacy schemas, stored procedures, and triggers.
• Optimize SQL queries, indexing, partitioning, and database configurations for high‑volume workloads.
• Manage database reliability, backup and recovery, replication, high availability, and disaster recovery.
• Establish standards for schema changes, database security, monitoring, and operational best practices.
• Build automation and validation tools using Python, Bash, or similar scripting languages.
• Work with application teams to resolve database issues and improve system performance.

Skills

Oracle expertise

PostgreSQL experience

Data migration

SQL performance tuning

Python scripting

Bash scripting

AWS RDS / Aurora

CDC tools (GoldenGate / AWS DMS)

Backup & disaster recovery

Security & data masking

Tools

Oracle GoldenGate

AWS DMS

PostgreSQL tooling

SQL monitoring tools

Job description

IKAS International (Asia) Pte Ltd is seeking a hands‑on Database Engineer to modernise a large‑scale platform by migrating legacy Oracle databases to PostgreSQL while ensuring data integrity, minimal downtime, and reliable performance.

You will lead end‑to‑end data migration, reverse‑engineering legacy logic, optimize queries and configurations, and ensure disaster recovery and high availability. The role requires deep Oracle expertise and strong PostgreSQL experience in production environments.