Spec : Database Administrator Oracle Ebs

Bcxp; Gauteng; On-site; ZAR 600,000 - 800,000; Full time

Job summary

A leading company in Data Management Services seeks a skilled DBA to manage Oracle databases effectively. This role includes ensuring database integrity, monitoring performance, and implementing disaster recovery plans. Ideal candidates will hold a relevant qualification and have significant experience with Oracle technologies.

Qualifications

• 5 to 7 years' experience in administering Oracle databases.
• Experience with Oracle E-Business Suite 12.2, SOA Suite, and Weblogic.
• Valid driver's license and willingness to travel locally.

Responsibilities

• Monitor performance and analyze trends for optimal database performance.
• Compile and maintain the integrity of the Configuration Management Database.
• Identify, propose, and implement effective backup strategies.

Skills

Database Management

Software Development Life Cycle (SDLC)

Customer Focus

SAP Tools and Platforms

Education

NQF 6: 3-year Degree/Diploma/National Diploma in IT or Computer Science

NQF 4: Grade 12

Tools

Oracle E-Business Suite 12.2

Oracle Weblogic

Oracle SOA Suite

Red Hat Enterprise Linux 7+

Job description

Department : Data Management Services - Oracle Reporting

Core Description

To provide a stable and secure production database environment that aligns with predefined standards and is recoverable in case of hardware failure or disaster situations.

Solving complex problems to deliver real business value across a wide range of data solutions.

Develop best practices and drive improvements in data engineering across the business, automating daily actions.

Key Deliverables / Primary Functions

• Compile and maintain the integrity of a Configuration Management Data Base in alignment with BCX's standards and using the BCX prescribed systems.
• Utilise the BCX Remedy system for request, incident, and problem handling, rectifying issues, and implementing preventative actions as needed.
• Continuously monitor performance, analyze trends, tune databases for optimal performance, and build a known error database (KEDB) for problem handling (R&D).
• Build and maintain support structures for consultation purposes.
• Stay updated with the latest release versions, ensure approval through user acceptance testing (UAT) and quality assurance (QA), design and execute release plans, maintain the Definitive Software Library (DSL), and manage license issues.
• Monitor space utilization, execute trend analysis, alerts, and escalations; monitor memory and CPU usage.
• Devise monitoring methodologies, utilize appropriate tools, and report on system availability or uptime.
• Identify, propose, and implement effective backup strategies to ensure service continuity and monitor these strategies regularly.
• Validate a disaster recovery (DR) plan for databases under management, considering replication, snapshots, or remote copies as applicable.

Core Functional Skills & Capabilities

• SAP Tools and Platforms
• Customer Focus
• Software Development Life Cycle (SDLC)
• Database Management

Core Behavioural Competencies

• Adhering to principles and values
• Coping with pressures & setbacks
• Deciding & initiating action
• Working with people

Minimum Qualifications

• NQF 6: 3-year Degree/Diploma/National Diploma in IT or Computer Science
• OR NQF 4: Grade 12

Experience

5 to 7 years' experience in administering Apps DBA Oracle databases, including Oracle E-Business Suite 12.2, Oracle SOA Suite, Oracle Weblogic, and Red Hat Enterprise Linux 7+.

Certifications

• RedHat
• Oracle E-Business Suite 12.2
• Oracle Weblogic
• Oracle SOA Suite

Special Requirements / Employment Conditions

• Valid driver's license
• Willingness to travel locally
• Ability to work staggered hours, shifts, overtime, and respond to call-outs