Junior Database Administrator (OceanBase & Oracle)

Salary: RM 6,500 – RM 8,500 per month

1. Job Summary

We are seeking a motivated Junior Database Administrator (OceanBase & Oracle) to join our Database Administration team. The role will primarily support the daily administration, monitoring, maintenance, basic performance analysis, backup operations, and troubleshooting of OceanBase databases, while assisting with existing Oracle Database operations.

Our initial OceanBase infrastructure consists of 10 on-premises deployments using a 2F1A (Two Full Replicas + Arbitration) high-availability architecture with Continuous Data Protection (CDP), and 1 cloud-based deployment. The platform is expected to continue expanding as business requirements grow.

The candidate will work closely with experienced DBAs to maintain availability, performance, and operational stability in business-critical production environments, while developing practical expertise in distributed databases, high availability, and recovery.

2. Key Responsibilities

OceanBase Database Administration

• Assist in daily administration, configuration, and maintenance of OceanBase database environments.

• Perform routine health checks, cluster status monitoring, and operational maintenance.

• Assist with cluster, tenant, resource pool, resource unit, user, and privilege management.

• Monitor resource utilization, storage capacity, database sessions, and cluster availability.

• Support installations, configuration changes, upgrades, and cluster expansion under senior DBA guidance.

• Maintain operational procedures, change records, and technical documentation.

Performance Monitoring & Basic Tuning

• Monitor SQL performance and identify slow queries or abnormal workloads.

• Assist with execution plan analysis, index review, and basic SQL tuning.

• Monitor CPU, memory, storage I/O, connections, and transaction activity.

• Identify and escalate potential performance issues, and help implement approved improvements.

• Participate in benchmarking, load testing, and database capacity monitoring.

Backup, Recovery & High Availability

• Monitor scheduled backups, backup jobs, and completion status.

• Assist with OceanBase CDP monitoring, backup verification, and recovery testing.

• Carry out routine backup and recovery tasks in accordance with documented procedures.

• Check high-availability health, replica status, and database availability.

• Participate in restore tests and disaster recovery exercises under senior DBA supervision.

• Promptly escalate backup failures, replica abnormalities, or availability issues.

Oracle Database Support

• Assist with Oracle Database daily administration, health checks, and monitoring.

• Support user administration, tablespace monitoring, and routine maintenance.

• Assist with Oracle SQL tuning, issue investigation, and performance monitoring.

• Support Oracle-to-OceanBase migration, SQL compatibility tests, and data validation.

• Develop knowledge of Oracle architecture, backup/recovery, and high-availability practices.

Production Support & Automation

• Support 24×7 production database operations according to the team’s support arrangements.

• Respond to monitoring alerts, investigate initial symptoms, and escalate complex incidents.

• Assist with planned maintenance, controlled production changes, and system upgrades.

• Develop or maintain basic Shell/Python scripts for monitoring and routine administration.

• Prepare database health-check reports, incident records, and operational documentation.

3. Required Qualifications & Experience

• Diploma or Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.

• 1–3 years of database administration or database technical support experience.

• Basic understanding of OceanBase architecture, administration, or distributed database concepts.

• Familiarity with Oracle Database administration and SQL fundamentals.

• Knowledge of SQL, indexes, execution plans, and basic performance troubleshooting.

• Basic understanding of database backup, recovery, replication, and high availability.

• Working knowledge of Linux, preferably Oracle Linux or Red Hat Enterprise Linux.

• Basic Shell scripting skills and willingness to learn automation.

• Strong attention to detail, troubleshooting ability, and willingness to support production operations.

4. Preferred Qualifications

• Practical OceanBase experience in development, testing, or production environments.

• Familiarity with OceanBase 2F1A, CDP, ODM, OCP, or ODP/OBProxy.

• Experience using OceanBase Oracle compatibility mode.

• Basic knowledge of Oracle RMAN, ASM, Data Guard, or GoldenGate.

• Familiarity with database monitoring, SQL performance analysis, or automation tools.

• Exposure to high-availability or high-transaction-volume database environments.

5. Key Competencies

• Willingness to learn and build deeper OceanBase and Oracle DBA expertise.

• Sound judgment, careful adherence to operating procedures, and commitment to data integrity.

• Good teamwork, communication, and issue escalation skills.

• Proactive, responsible, and able to complete assigned tasks with appropriate supervision.

• Flexibility to participate in scheduled production support and maintenance activities.

6. Position Expectations

The successful candidate will progressively develop practical skills in OceanBase administration, SQL performance analysis, backup and recovery, and production troubleshooting. As the OceanBase platform grows, the candidate will assist with new deployments, automation, operational improvements, and infrastructure maintenance.