Database Administrator with AWS

OPENSOURCE TECHNOLOGIES PTE. LTD.; Singapore; On-site; SGD 120,000 - 170,000; Full time

Job summary

OPENSOURCE TECHNOLOGIES PTE. LTD. is seeking an experienced Database Administrator to manage Oracle, MySQL, PostgreSQL, and IBM DB2 across AWS cloud and on‑prem environments.

The role requires hands‑on expertise in RAC, Data Guard, ASM, RMAN, and performance tuning, with responsibilities spanning installation, upgrades, backup, security, and DR planning. Candidates should be proficient in AWS RDS/Aurora, DB2 on EC2, and ILMT/licensing compliance, and capable of supporting production deployments

Qualifications

• Experience administering Oracle, MySQL, PostgreSQL and IBM DB2 across AWS and on‑prem environments.
• Hands‑on with Oracle RAC, Data Guard, ASM and RMAN backup/recovery.
• Experience with AWS RDS/Aurora and DB2 on AWS EC2 and in‑house.
• Strong performance tuning, patching/upgrades, security, and high‑availability solutions.

Responsibilities

• Administer and support Oracle, MySQL, PostgreSQL, and IBM DB2 databases.
• Manage AWS RDS Oracle, RDS/Aurora MySQL, and RDS PostgreSQL environments.
• Manage DB2 and MySQL databases hosted on AWS EC2.
• Perform installation, configuration, upgrades, patching, maintenance and troubleshooting.

Skills

Oracle 19c

Oracle RAC

Oracle Data Guard

ASM

RMAN

Oracle security/auditing

MySQL 5.7/8.0

AWS RDS/Aurora MySQL

PostgreSQL administration

DB2 administration

IBM ILMT

HADR

Java/JDK upgrades

Performance tuning

Job description

Job Description

We are looking for an experienced Database Administrator (DBA) with strong hands‑on experience in Oracle, MySQL, PostgreSQL, and IBM DB2 databases across both AWS cloud and on‑premises/EC2 environments. The candidate should have strong expertise in Oracle RAC, Data Guard, ASM, AWS RDS/Aurora, DB2 administration, Fix Pack and Java upgrades, ILMT compliance, database performance tuning, backup/recovery, security, patching, and high‑availability/DR solutions.

Key Responsibilities

• Administer and support Oracle, MySQL, PostgreSQL, and IBM DB2 databases.
• Manage AWS RDS Oracle, RDS/Aurora MySQL, and RDS PostgreSQL environments.
• Manage DB2 and MySQL databases hosted on AWS EC2.
• Perform database installation, configuration, upgrades, patching, maintenance, and troubleshooting.
• Monitor database availability, performance, capacity, and resource utilization.
• Perform database backup, recovery, restore testing, and disaster recovery activities.
• Manage database users, roles, privileges, authentication, and security controls.
• Perform database performance and SQL tuning.
• Support production deployments, maintenance activities, incidents, and change requests.

Qualifications

Oracle DBA Skills

• Oracle Database 19c administration.
• Oracle RAC, Data Guard, and ASM.
• RMAN backup and recovery.
• Oracle performance and SQL tuning.
• Oracle patching, Release Updates (RU), and upgrades.
• Data Guard switchover/failover and DR activities.
• RAC and ASM troubleshooting.
• Oracle security, auditing, users, roles, and privileges.

MySQL Skills

• MySQL 5.7/8.0 administration.
• AWS RDS/Aurora MySQL administration.
• MySQL administration on AWS EC2.
• Backup and recovery.
• Replication and high availability.
• Performance monitoring and SQL tuning.
• User and privilege management.
• MySQL patching, upgrades, and vulnerability remediation.
• Troubleshooting connectivity, locking, replication, and performance issues.

PostgreSQL Skills

• PostgreSQL administration, preferably versions 17
• AWS RDS PostgreSQL administration.
• Backup and recovery using pg_dump/pg_restore and physical backups.
• Streaming replication and high availability.
• PostgreSQL performance and SQL tuning.
• PostgreSQL patching and major‑version upgrades.
• User, role, and privilege management.

IBM DB2 Skills

• IBM DB2 database administration on AWS EC2/Linux.
• DB2 installation, configuration, maintenance, and troubleshooting. - DB2 Fix Pack upgrades and security patching.
• DB2 Java/JDK upgrades and compatibility management.
• DB2 backup, recovery, restore, and DR activities.
• DB2 HADR and high‑availability configuration.
• Troubleshooting DB2 database and application connectivity issues.
• Review IBM security advisories and perform vulnerability remediation.

IBM ILMT & License Compliance

• Manage and support IBM License Metric Tool (ILMT) requirements.
• Monitor DB2 software inventory and license usage.
• Maintain IBM licensing and compliance documentation.
• Support ILMT audits and provide required compliance evidence.
• Coordinate with infrastructure/licensing teams for IBM software compliance. - Ensure DB2 Fix Pack and Java/JDK versions meet organizational security and compliance requirements.

AWS / Cloud Skills

• Hands‑on administration of: - Amazon RDS for Oracle
• Amazon RDS/Aurora MySQL
• Amazon RDS PostgreSQL
• MySQL and DB2 on Amazon EC2
• AWS backup and restore.
• CloudWatch monitoring and alerting.
• AWS security and database monitoring.
• AWS KMS, Secrets Manager, and IAM concepts.
• Database migration and cloud modernization experience.
• Understanding of AWS high availability, Multi‑AZ, backup, and DR architecture.

Security & Compliance

• Database vulnerability assessment and remediation.
• Security patching and database version upgrades.
• Database auditing and logging.
• Password and privileged account management.
• Support security compliance and audit requirements.
• Review vendor security advisories for Oracle, MySQL, PostgreSQL, DB2, and Java.
• Maintain evidence for security, backup, patching, and compliance activities.

Security Clearance

Due to project requirement Need Cat 2 Clearance