Job Description

We are looking for a Microsoft SQL Server DBA with 4/5 years minimum experience to join our team. As a SQL Server DBA, you will be responsible for/but not limited to implementing, configuration, maintenance, and performance optimisation of critical Microsoft SQL Server RDBMS systems.

Structure, Grade & Reporting

Job grade/level S6
Business Unit Digital Platform Solutions
Business Unit Digital EXA
Position reports to Manager: Delivery
Span of Control 0
Level of Engagement Client, Employees and Line Manager

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.
The role includes installing, configuring, maintaining, supporting, and optimizing all new and existing software that is used to host applications and static content for the two core enterprise business to consumer and business to business web portals all running on a Virtual platform.

Key Deliverables / Primary Functions

• Conduct high level database administration and related tasks on multiple RDBMS platforms with emphasis on Oracle 11g, i.e. manage what it does vs how it does it.
• Interface with various specialist groups - Operating system support, Network support, Data Centre network Security Support and core database administrators to support the platform
• Provide architecture and platform support to the First- and Second-layer application support team
• In conjunction with a team of diverse skills that keep the enterprise portal landscape system running 24/7 and optimised for the client current workload on current and yet to be defined future technologies
• 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 methodologies 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.
• 24/7 Standby on a rotational basis.

Functional Skills

• Best Practice in Database Administration; ITIL & Quality Management Principles; Microsoft Office Suite; Remedy System Operation. Oracle Database product licensing knowledge desirable.
• Solid knowledge of Database concepts and exposure to at Least one of the following Database Technologies - Oracle, Postgress, MySQL, Mongo DB, SQL-Server, Berkley.
• Exposure to Web Servers e.g. Oracle Http Server, Nginx, Apache and HTTPD including the Install thereof.
• Exposure to DevOps methodology and tools (Jenkins, Git, Nexus, Sonarqube, Docker, Podman)
• Install, Configuration, Connection setups and tuning.
• Change Control

Behavioural Competencies

1. Job Match Rating

2. Delivering Results

3. Meeting customer expectations

4. Decision Making

5. Handling Pressure

6. Communication and Impact

Qualifications

NQF 6: 3 year Degree/ Diploma/ National Diploma in IT/Business/Commerce

OR NQF 4 (Grade 12)

Experience

3 years experience in the administration of databases.

Alternatively, 5+ years experience in administration of MS SQL Server databases.
MS SQL, AWS or Azure cloud experience/certification, 1+ years, advantageous.

Certifications / Professional Registration

OCP (Oracle Certification)

Weblogic

RDBMS/ Cloud

DevOps/ Development methodology

Special Requirements/ Employment Condition

Valid Drivers license

Work Characteristics

Billable

WFA /Office Based

We are looking for a Microsoft SQL Server DBA with 4/5 years minimum experience to join our team. As a SQL Server DBA, you will be responsible for/but not limited to implementing, configuration, maintenance, and performance optimisation of critical Microsoft SQL Server RDBMS systems.

BCXP