- Islandwide (Singapore) Singapore
Lokasi Kerja
Penerangan Kerja
Tanggungjawab
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.
Peringatan Penting
Jangan pernah kongsikan maklumat bank atau kad kredit anda semasa memohon pekerjaan. Elakkan membuat sebarang pembayaran atau mengisi survey yang tidak berkaitan. Jika ada yang mencurigakan, sila laporkan iklan pekerjaan ini segera.