Business unit, Department, Reporting Business Unit Cloud Platform Solutions Department Enterprise Infrastructure Solutions Job grade OP2

 

Core Description

To assist with 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. Will work under the technical expertise and guidance of Database Administrators within the team.

Key Deliverables / Primary Functions Compile and maintain the integrity of a Configuration Management Data Basein alignment with BCX’s standards and using the BCX prescribed systems. Utilise the BCX ITSM 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. Contribute to monitoring methodology and processes, utilise the appropriate toolsets and report on the availability or uptime. Identify 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 Product KnowledgeProblem managementMicrosoft OfficeRelationship BuildingDatabase ManagementCore Behavioural Competencies Job MatchAnalysingCoping with pressures & setbacksFollowing instructions & proceduresPlanning & OrganisingWorking with peopleMinimum Qualifications NQF 4: Grade 12 National Diploma in Information TechnologyAdditional Education -Preferred /Advantage Experience

1 year experience in the administration of MS SQL Server databases.

Certifications Professional Memberships in Relevant Industry Level of Engagement & Span of Control Special Requirements / Employment Condition Workplace / Physical Requirements Full-time Client Based PositionBillable