Database Administrator with AWS

RAPSYS TECHNOLOGIES PTE. LTD.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

RAPSYS Technologies Pte. Ltd. is seeking an experienced Database Administrator (DBA) with hands-on expertise across Oracle, MySQL, PostgreSQL, and IBM DB2. The role covers both AWS cloud and on-premises environments, with emphasis on high-availability, performance tuning, backup/recovery, and security.

The ideal candidate will manage Oracle RAC, Data Guard, ASM, AWS RDS/Aurora, DB2 on EC2, and ILMT compliance, delivering reliable database services and supporting production deployments.

Qualifications

• Experience with Oracle RAC, Data Guard, ASM, RMAN backup/recovery.
• Strong knowledge of AWS RDS/Aurora, and DB2 on EC2.
• Backup and DR planning across cloud and on-premises.
• Security controls and patching across multi-database environments.
• Experience tuning and optimizing SQL across Oracle, MySQL, PostgreSQL, and DB2.

Responsibilities

• Administer 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.
• Install, configure, upgrades, patching, maintenance, and troubleshooting.
• Monitor availability, performance, capacity and resources.
• Backup, recovery, restore testing, and disaster recovery activities.
• Manage users, roles, privileges, authentication, and security controls.
• Perform database performance and SQL tuning.
• Support production deployments, maintenance activities, incidents and change requests.

Skills

Oracle 19c

Oracle RAC

Data Guard

RMAN

SQL tuning

Patching

Security

MySQL Admin

AWS RDS

MySQL on EC2

Backup/Recovery

Replication

Performance tuning

Privileges

PostgreSQL Admin

Streaming replication

DB2 Admin on AWS EC2

ILMT Compliance

RDS for Oracle

RDS/Aurora

Job description

Job Description

We are looking for an experienced DatabaseAdministrator (DBA) with strong hands-on experience in Oracle, MySQL,PostgreSQL, and IBM DB2 databases across both AWS cloud and on-premises/EC2environments. The candidate should have strong expertise in Oracle RAC, DataGuard, 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

• Administerand support Oracle, MySQL, PostgreSQL, and IBM DB2 databases.
• Manage AWSRDS Oracle, RDS/Aurora MySQL, and RDS PostgreSQL environments.
• Manage DB2and MySQL databases hosted on AWS EC2.
• Performdatabase installation, configuration, upgrades, patching, maintenance, andtroubleshooting.
• Monitordatabase availability, performance, capacity, and resource utilization.
• Performdatabase backup, recovery, restore testing, and disaster recovery activities.
• Managedatabase users, roles, privileges, authentication, and security controls.
• Performdatabase performance and SQL tuning.
• Supportproduction deployments, maintenance activities, incidents, and change requests.

Qualifications

Oracle DBASkills

• OracleDatabase 19c administration.
• Oracle RAC,Data Guard, and ASM.
• RMAN backupand recovery.
• Oracleperformance and SQL tuning.
• Oraclepatching, Release Updates (RU), and upgrades.
• Data Guardswitchover/failover and DR activities.
• RAC and ASMtroubleshooting.
• Oraclesecurity, auditing, users, roles, and privileges.

MySQL Skills

• MySQL 5.7/8.0administration.
• AWSRDS/Aurora MySQL administration.
• MySQLadministration on AWS EC2.
• Backup andrecovery.
• Replicationand high availability.
• Performancemonitoring and SQL tuning.
• User andprivilege management.
• MySQL patching, upgrades, and vulnerability remediation.
• Troubleshooting connectivity, locking, replication, and performance issues.

PostgreSQL Skills

• PostgreSQL administration, preferably versions 17
• AWS RDSPostgreSQL 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 DB2database administration on AWS EC2/Linux.
• DB2installation, configuration, maintenance, and troubleshooting. - DB2 Fix Packup grades and security patching.
• DB2 Java/ JDK upgrades and compatibility management.
• DB2 backup, recovery, restore, and DR activities.
• DB2 HADR and high-availability configuration.
• TroubleshootingDB2 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 DB2software 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 DB2Fix 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 DB2on Amazon EC2
• AWS backup and restore.
• Cloud Watch monitoring and alerting.