- Location
- MY Ipoh, Malaysia
- Workplace
- Remote, Hybrid
- Type
- Full-time
- Department
- IT
- Source
- Workday
Description
- Multi-Generation Database Support: Administer, patch, and support modern Oracle infrastructure (19c/23c) while reliably supporting historical legacy database versions (e.g., 11g, 12c).
- On-Premises SAN Storage Management: Map, configure, and tune database layouts using Oracle Automatic Storage Management (ASM) built directly upon underlying physical SAN storage arrays.
- Hybrid Environment Operations: Monitor health, optimize performance, and manage configurations across physical host bare-metal/virtual servers, AWS EC2 instances, and Amazon RDS Custom deployments.
- Legacy-to-Cloud Migrations: Execute safe cross-platform data migration schemes via Oracle Data Pump, Transportable Tablespaces, and AWS Database Migration Service (DMS).
- Disaster Recovery & Backup: Design, run, and audit comprehensive backup frameworks using Oracle RMAN coupled with physical storage media and cloud-native AWS Snapshot lifecycle schemas.
- Automated Performance Tuning: Diagnose operational blocks, run AWR/ADDM reports, optimize slow PL/SQL blocks, and write systemic shell automations using Bash, SQL, and PL/SQL scripts.
- Security Implementation: Roll out quarterly Oracle Critical Patch Updates (CPUs) on RHEL environments and ensure access mappings strictly align with cloud AWS IAM structural rules.
- Red Hat Enterprise Linux Administration: Maintain, optimize, and troubleshoot Oracle environments hosted natively on enterprise Red Hat Enterprise Linux (RHEL) configurations.
Required Technical Skills & Qualifications
- Database Expertise: Strong architecture familiarity spanning both traditional single-instance legacy systems and multi-tenant Container (CDB) / Pluggable (PDB) database paradigms.
- Cloud Proficiency: Practical operational experience using AWS ecosystem products, specifically EC2 compute clusters, S3 buckets, EBS storage volumes, VPC architecture, and IAM structures.
- Professional Experience: 3 to 5 years of active, hands-on production enterprise database management experience.
- Educational Framework: Bachelor’s degree in Computer Science, Information Technology, Computer Engineering, or an equivalent technical field of study.
- Operating Systems: Deep technical comfort working inside Red Hat Enterprise Linux (RHEL) server environments, including package updates, user configuration, and shell standard operations.
Skills
AWSLinuxSQLOracle