Spec: Database Administrator Oracle

Job description:

Business unit, Department, Reporting

Business Unit: Cloud Platform Solutions

Department: Data Management Services - Oracle

Reporting: Principal Business Consultant

Core Description

To provide a stable and secure production database environment which performs in alignment 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 and automate the 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 and implementing preventative actions as and when required.
• Continuously monitor performance, analyse trends and tune database for optimum performance and record and build a known error database (KEDB) for Problem Handling (R&D).
• Build and maintain a network of support structures e.g. vendors, employees, user groups etc. for consultation purposes.
• Continuously stay abreast with the latest release versions and ensure approval of new versions through a user’s acceptance testing (UAT) and quality assurance (QA) process; design and execute a release implementation plan; maintain the Definitive Software Library (DSL); and install, maintain and report license issues as and when they occur.
• Continuously monitor and report on space utilisation, execute trend analysis, alerts and escalation; monitor memory utilisation and Central Processing Unit (CPU) at all times.
• Devise monitoring methodology and processes, utilise the appropriate toolsets and report on the availability or uptime.
• Identify, propose and implement appropriate toolsets for an effective back-up strategy to ensure continuity of services and monitor the back-up strategy on a continuous basis. Validate a DR Plan for the data base(s) under the data centre management, consider the replication, snapshots or remote copy as applicable.

Core Functional Skills & Capabilities SAP Tools and Platforms Technology Consulting Customer Focus Software Development Life Cycle (SDLC) Database Management Core Behavioural Competencies Adhering to principles and values Coping with pressures & setbacks Deciding & Initiating Action Delivering Results & Meeting customer expectations Working with people Minimum Qualifications NQF 6: 3 year Degree/ Diploma/ National Diploma in Information Technology or Computer Science OR NQF 4: Grade 12 Additional Education -Preferred /Advantage Experience

• 5 To 7 years’ experience in the administration of Apps DBA Oracle databases including:
• Oracle E-Business Suite 12.2
• Oracle SOA Suite
• Oracle Weblogic
• 12, 19c Database administration incl. Real Application Clusters.
• Redhat Enterprise Linux 7+.

Certifications RedHat Oracle E-Business Suite 12.2m Oracle Weblogic Oracle SOA Suite 19c Database administration incl. Real Application Clusters Professional Memberships in Relevant Industry Level of Engagement & Span of Control

Level of engagement: Engagement will all levels within the organisation, internal and external to the business.

Span of control: 0

Special Requirements / Employment Condition Valid Drivers license Required to travel locally Ability to work staggered hours, shifts, overtime and respond to call-outs Workplace / Physical Requirements Hybrid Remote Worker Billable Revenue Generating