Provide day-to-day database administration support, primarily for Oracle databases on Google Cloud and on-premise systems.
Monitor, maintain, and troubleshoot database performance issues, including SQL tuning, indexing, and optimization.
Support incident, problem, and change management of database-related issues in collaboration with technical teams.
Plan and execute database backups, recovery, patching, upgrades, and lifecycle management.
Develop and maintain documentation for database procedures, configurations, and troubleshooting steps.
Conduct proactive monitoring to ensure high availability and optimal performance.
Implement and maintain Oracle Data Guard for disaster recovery and high availability.
Perform capacity planning, system performance analysis, and resource monitoring.
Participate in on-call rotations to ensure 24/7 support for critical incidents.
Provide mentorship and guidance to other database administrators.
Basic scripting/programming tasks using Unix shell, Python, or PHP as required.
Qualifications & Skills:
Essential:
Minimum 5 years of experience in Oracle database administration (large company experience preferred).
Hands-on experience with Oracle 19c or 23c, including installation, configuration, patching, backup/recovery (RMAN), and monitoring.
Strong knowledge of Oracle HA solutions (Data Guard, RAC) and ASM filesystem management.
Performance tuning and troubleshooting skills, including SQL optimization.
Experience with database security, TDE encryption, and TLS network encryption concepts.
Basic PL/SQL programming (procedures, functions, packages).
Familiarity with Unix/Linux systems, shell scripting, Python, or PHP.
Preferred:
Experience with additional databases (PostgreSQL, MS-SQL, Redis Cache).
Knowledge of Oracle APEX and Oracle 23c features.
Understanding of IT security and software methodologies.
Interest in learning new technologies and proactive problem-solving.
Job Type: Full-time
Pay: RM4,500.00 - RM8,000.00 per month
Benefits:
Health insurance
Maternity leave
Opportunities for promotion
Professional development
Work Location: In person
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.