[LTA-DPO] SENIOR ENGINEER, ERP2 DEVELOPMENT

Public Service Division; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

Public Service Division seeks a Senior Database Administrator to lead Oracle 19c migrations to GCC on AWS/Azure, with end-to-end lifecycle management from installation to DR. You will design replication, perform upgrades, and ensure performance and security across cloud and on-prem environments.

The role requires 7+ years of Oracle DB experience, Linux administration, and scripting in Shell or Python to automate tasks. Collaboration with cloud, infrastructure, and application teams is essential.

Qualifications

• Bachelor's degree in Engineering or Computer Science.
• 7+ years of Oracle Database design, implementation and administration in enterprise environments.
• Hands-on experience with Oracle 19c administration, upgrades, patching and security.
• Proven experience migrating Oracle databases to cloud platforms (AWS/Azure GCC).
• Expertise in Oracle HA/DR tech: GoldenGate, Data Guard, RMAN, ZDM.
• Familiarity with Oracle AI Database technologies (26ai, APEX).
• Proficiency in Shell/Python scripting for automation.
• Strong collaboration across application, infra and cloud teams.

Responsibilities

• Lead Oracle DB migrations to GCC on AWS or Azure with minimal business disruption.
• Design and maintain replication between on-premises and cloud.
• Plan installations, configurations, upgrades, and lifecycle management for Oracle DB.
• Perform proactive DB administration: tuning, capacity planning, health monitoring.
• Implement and maintain backup, HA, and DR solutions.
• Apply patches and security updates per policy; ensure compliance.
• Collaborate with vendors and DevOps teams on deployments and migrations.
• Troubleshoot complex DB/infrastructure issues and document solutions.

Skills

Team player

Analytical thinking

Troubleshooting

Interpersonal skills

Education

Engineering or Computer Science degree

Tools

Oracle Database 19c

Oracle GoldenGate

Data Guard

RMAN

Zero Downtime Migration (ZDM)

Oracle AI Database 26ai

Oracle APEX

Shell scripting

Python scripting

Linux administration

AWS/Azure cloud platforms

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.