Junior Database Administrator (OceanBase & Oracle)

EWS Software Sdn Bhd; Kuala Lumpur; On-site; MYR 36,000 - 70,000; Full time

Job summary

EWS Software Sdn Bhd in Kuala Lumpur is seeking a Junior Database Administrator to support OceanBase and Oracle databases, including daily administration, monitoring, maintenance, and basic performance analysis. The role will work closely with senior DBAs to ensure availability and reliability in production environments.

The position focuses on learning distributed databases, high availability, and recovery, with opportunities to develop practical expertise while assisting with backups, recovery

Qualifications

• Diploma/Bachelor's in CS/IT or related field, or equivalent.
• 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.
• Basic Shell scripting skills and willingness to learn automation.
• Strong attention to detail, troubleshooting ability, and willingness to support production operations.

Responsibilities

• Assist in daily OceanBase DB admin, config, and maintenance.
• 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, DB sessions, and cluster availability.
• Support installations, configuration changes, upgrades, and cluster expansion under senior DBA guidance.
• Maintain operational procedures, change records, and technical documentation.
• 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 elevate potential performance issues, and help implement improvements.
• Participate in benchmarking, load testing, and database capacity monitoring.
• 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 per procedures.
• Check high-availability health, replica status, and DB availability.
• Participate in restore tests and disaster recovery exercises under supervision.
• Promptly elevate backup failures, replica abnormalities, or availability issues.
• Assist with Oracle DB 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.
• Support 24x7 production database operations according to team’s arrangements.
• Respond to monitoring alerts, investigate symptoms, and elevate incidents.
• Assist with planned maintenance, 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.

Skills

OceanBase knowledge

Oracle DB administration

SQL tuning basics

Shell scripting

Linux proficiency

Monitoring & troubleshooting

Production support

Education

Diploma in CS/IT

Bachelor's degree in CS/IT or related field

Tools

Oracle RMAN

OBProxy / OceanBase tooling

Job description

Junior Database Administrator (OceanBase & Oracle)

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 elevate 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 elevate 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 elevate 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.
• 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.