Staff Database Engineer

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.

For more information you can contact Norean Tan at [email protected]

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