Ops Spec: Database Administrator - Western Cape

Job description:

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. To provide technical expertise and guidance to Junior Database Administrators.

Key Deliverables / Primary Functions

• Compile and maintain the integrity of a Configuration Management Data Base in alignment with BCXs 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 users 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 & Knowledge Customer Management DBMS Management ICT Knowledge Risk Management Core Behavioural Competencies Job Match Culture Match Applying expertise & Technology Delivering Results & Meeting customer expectations Following instructions & procedures Working with people Minimum Qualifications NQF 6: 3 year Degree/ Diploma/ National Diploma OR NQF 4: Grade 12

Experience 3 years experience

SQL Server Database Administration experience

AWS or Azure cloud experience/certification, 1+ years, advantageouS

OR

Grade 12 & 5 years experience

SQL Server Database Administration experience

AWS or Azure cloud experience/certification, 1+ years, advantageous

Special Requirements / Employment Condition Drivers Licence and Reliable Vehicle - both required Workplace / Physical Requirements Hybrid Remote Worker