Staff Database 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

What you will be working on

We are looking for a hands‑on database engineer to modernise a large-scale, business‑critical platform, migrating legacy Oracle databases to PostgreSQL while ensuring data integrity, minimal downtime, and reliable performance.

• 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.
• Optimise 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.

What we are looking for

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

Good to have: Experience in large-scale platform modernisation, transaction‑intensive systems, and AI‑assisted development workflows.

We regret to inform you that only shortlisted candidates will be notified / contacted.

EA Registration No.: R1434118 - Tan Lee Ying, Norean

iKas International (Asia) Pte Ltd

ROC No.: 200914065E | EA License No.: 16S8086