Spec: Database Administrator MS/SQL

Apply now »

Date: 22 Jan 2025

Location: Centurion, Gauteng, ZA

Company: BCXP

Business unit, Department, Reporting

Business Unit: Cloud Platform Solutions

Department: Data Management Services - Oracle

Reporting: Manager Service Delivery

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

Be able to perform SQL Server Database Administrator tasks 
Provide AlwaysON clusters support on Microsoft SQL Database 
TDE Encryption 
Performance Tuning on queries and database on the Microsoft SQL database
Have Experience in Azure Data Technologies 
Be able to support and maintain Azure SQL Server Managed Instances 
Have Good Knowledge in DevOps i.e. Azure Devops and Terraform 
Have basic knowledge Knowledge in Python or PowerShell
Be able to perform proactive monitoring of the MSSQL Database
Proactive event identification, verification, tracking and notification to DB uptime and reliability 
Minimize turnaround time to critical incidents 
24/7 standby facility has not been included, as this is an optional facility to ensure our resources are always available for after-hours calls 
Handling of Severity 1 Incidents 

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

  1. To 7 years’ experience in the administration of Microsoft SQL databases
  • Experience in SQL Server Database Administration, AlwaysON clusters, TDE Encryption , Performance Tuning
  • Experience in Azure Data Technologies, Azure SQL Server Managed Instances, Azure Data Factory, DevOps i.e. Azure Devops and Terraform, Python or PowerShell

Certifications

Azure Certification
Python and or PowerShell (experience advantageous)

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
Ability to work co-operatively with other people (Team Member)

Workplace / Physical Requirements

Hybrid Remote Worker
Billable
Revenue Generating