Database Administrator with AWS

Opensource; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

Opensource is seeking an experienced Database Administrator to manage Oracle, MySQL, PostgreSQL, and IBM DB2 databases across AWS cloud and on-prem environments. The role emphasizes Oracle RAC, Data Guard, ASM, RMAN backups, and high availability through DR strategies.

The ideal candidate will monitor performance, perform backups and recoveries, manage security and access, and support production deployments with a focus on reliability and compliance.

Qualifications

• Administration of Oracle 19c with RAC, Data Guard and ASM.
• Experience with RMAN backups and recovery strategies.
• Strong SQL tuning and performance optimization skills.

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 and troubleshooting.
• Monitor availability, performance, capacity and resource utilization.
• Perform backup, recovery, restore testing, and DR activities.
• Manage users, roles, privileges, authentication, and security controls.
• Perform performance tuning and SQL optimization.
• Support production deployments, maintenance activities, incidents, and changes.

Skills

Oracle 19c

Oracle RAC

Data Guard

RMAN backup

SQL tuning

AWS RDS

Oracle patching

DR planning

Security hardening

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