Junior OceanBase & Oracle DBA - Growth in Distributed DBs

EWS Software Sdn Bhd; Kuala Lumpur; Vor Ort; MYR 36.000 - 70.000; Vollzeit

Zusammenfassung

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

Qualifikationen

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

Aufgaben

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

Kenntnisse

OceanBase knowledge

Oracle DB administration

SQL tuning basics

Shell scripting

Linux proficiency

Monitoring & troubleshooting

Production support

Ausbildung

Diploma in CS/IT

Bachelor's degree in CS/IT or related field

Tools

Oracle RMAN

OBProxy / OceanBase tooling

Jobbeschreibung

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