[LTA-DPO] SENIOR ENGINEER, ERP2 DEVELOPMENT

Land Transport Authority (LTA) Singapore; Singapore; On-site; SGD 120,000 - 160,000; Full time

Job summary

Land Transport Authority (LTA) Singapore seeks a Senior Database Administrator to lead Oracle 19c migrations to GCC on AWS/Azure and manage full lifecycle: install, configure, upgrade, patch, tune, backup, and DR planning.

You will work closely with vendors and cross-functional teams to ensure successful database migration, modernization, and operational support while evaluating AI database capabilities for future platforms.

Qualifications

• 7+ years of Oracle Database design, implementation and administration in enterprise environments.
• Strong hands-on experience with Oracle 19c including installation, configuration, upgrades, patching, performance tuning, backup/recovery and security.
• Experience migrating Oracle databases from on-premises to GCC on AWS/Azure.

Responsibilities

• Lead migration of Oracle DB 19c to GCC on AWS/Azure with minimal disruption.
• Design, implement, and maintain Oracle DB replication between on-premises and cloud.
• Plan installations, configurations, upgrades and lifecycle management.
• Perform proactive DB administration: tuning, capacity planning, health monitoring and maintenance.
• Develop HA/DR solutions and ensure compliance with security policies.
• Collaborate with DevOps, cloud, and applications teams on deployments and migrations.
• Troubleshoot complex DB/infrastructure issues and document procedures.

Skills

Oracle 19c

Cloud migration

SQL tuning

Scripting (Shell/Python)

Linux

Education

Engineering degree

Tools

Oracle GoldenGate

Data Guard

RMAN

Zero Downtime Migration

Job description

What the role is

We are looking for a Senior Database Administrator to join our team to support the migration, administration and modernization of platforms supporting enterprise applications. You will play a key role in database migration to Government Commercial Cloud (GCC) (on AWS or Azure).

The successful candidate will be responsible for the full database lifecycle, including installation, configuration, upgrades, patching, performance tuning, backup and recovery, high availability, disaster recovery and operational support. The role also involves evaluating and adopting the latest AI Database capabilities to support future platform modernization. The successful candidate will also work closely with existing vendors and internal stakeholders to ensure successful delivery of database migration, upgrade and operational support activities.

What you will be working on

• Lead the migration of Oracle Database 19c environments to Government Commercial Cloud (GCC) on AWS and Azure, ensuring minimal disruption to business operations.


• Design, implement and maintain database replication between on-premises and cloud environments.


• Plan and execute Oracle database installations, configuration, upgrades and database lifecycle management.


• Perform proactive database administration, including performance tuning, SQL optimization, capacity planning, health monitoring and preventive maintenance to ensure database availability, reliability and performance.


• Design, implement and maintain backup, recovery, High Availability (HA) and Disaster Recovery (DR) solutions.


• Apply database patches, security updates and configuration changes while ensuring compliance with organisational security policies and industry best practices.


• Collaborate with application, infrastructure, cloud and DevOps teams to support application deployments, system integration and cloud migration initiatives.


• Troubleshoot complex database and infrastructure issues, perform root cause analysis, automate operational tasks using scripting where appropriate, and maintain comprehensive technical documentation.


• Collaborate with existing vendors and cross-functional teams, including application, infrastructure and cloud teams, to deliver database migration, implementation, maintenance and operational support.

What we are looking for

• Knowledge in Engineering, Computer Science or equivalent degree.


• Minimum 7 years of experience in Oracle Database design, implementation and administration in enterprise environments.


• Strong hands-on experience administering Oracle Database 19c, including installation, configuration, upgrades, patching, performance tuning, backup & recovery and database security.


• Proven experience planning and executing Oracle database migrations from on-premises infrastructure to cloud platforms, preferably Government Commercial Cloud (GCC) on AWS or Azure.


• Strong hands-on experience with Oracle High Availability, Disaster Recovery and migration technologies, including Oracle GoldenGate, Data Guard, RMAN and Zero Downtime Migration (ZDM)


• Familiarity with Oracle AI Database technologies, including Oracle AI Database 26ai, Oracle APEX, Select AI and related database capabilities.


• Experience administering Oracle databases on Linux platforms and deploying database workloads to cloud environments (AWS and/or Azure).


• Proficiency in scripting and automation using Shell, Python or equivalent scripting languages to improve database administration and operational efficiency.


• Relevant Oracle Database, Oracle Cloud and cloud platform certifications are preferred.


• Team player with strong analytical, troubleshooting and interpersonal skills.

As part of the shortlisting process for the role, you may be required to complete a medical declaration and / or undergo further assessment.