Staff Database Engineer

Your tasks

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.

Requirements

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

How to apply

For more information you can contact Norean Tan at norean.tan@sanderson-ikas.sg

Other

iKas International (Asia) Pte Ltd ROC No.: 200914065E | EA License No.: 16S8086