Database Administrator with AWS at OpenSource Technologies

Open Source Technologies, Inc.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

Open Source Technologies, Inc. is seeking an experienced Database Administrator (DBA) to manage Oracle, MySQL, PostgreSQL and IBM DB2 databases across AWS cloud and on-premises/EC2 environments. The role covers installation, upgrades, patching, and DR planning, with emphasis on performance tuning and security.

You will administer multi-database systems, monitor health, perform backups and recoveries, and support deployments and incident management in a full-time on-site setting.

Qualifications

• Experience administering Oracle, MySQL, PostgreSQL and IBM DB2 databases across AWS and on-premises/EC2.
• Manage AWS RDS Oracle, RDS/Aurora MySQL, and RDS PostgreSQL environments.
• Perform installation, configuration, upgrades, patching, maintenance and troubleshooting.

Responsibilities

• Administer and support Oracle, MySQL, PostgreSQL and IBM DB2 databases.
• Monitor availability, performance, capacity, and resource utilization.
• Perform backup, recovery, restore testing, and disaster recovery activities.
• Manage users, roles, privileges, authentication, and security controls.
• Support production deployments, maintenance activities, incidents, and change requests.

Skills

Oracle DBA

MySQL DBA

PostgreSQL DBA

DB2 DBA

AWS Cloud DBA

Tools

RMAN

Oracle RAC

Data Guard

ASM

pg_dump/pg_restore

AWS RDS/Aurora

EC2 DB2/MySQL

CloudWatch

KMS/Secrets Manager

Job description

This Full time on site position offers great opportunities for career growth.

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.

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