Spec: Database Administrator MS/SQL - Fixed Term Contract

BCXP; Centurion; On-site; ZAR 700,000 - 900,000; Full time

Job summary

BCXP is seeking a Database Administrator focused on MS SQL for a fixed-term contract in Centurion, Gauteng. You will manage SQL Server environments, implement AlwaysOn, TDE, and performance tuning, and work with Azure data services and DevOps tooling.

The role requires up to 7 years of experience with SQL databases, strong operational skills, and the ability to respond to incidents and optimize database reliability in a production environment.

Qualifications

• 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

Responsibilities

• Be able to perform SQL Server Database Administrator tasks.
• Provide AlwaysON clusters support on Microsoft SQL Database.
• TDE Encryption implementation and management.
• Performance tuning on queries and databases.
• Support and maintain Azure SQL Server Managed Instances.
• Utilise Azure DevOps and Terraform for deployments and automation.
• Basic scripting in Python or PowerShell for automation.
• Proactive monitoring of MSSQL Database and incident response.

Skills

SQL Server DBA

AlwaysOn clusters

TDE Encryption

Performance tuning

Azure data tech

Azure SQL Managed Instances

Azure DevOps

Terraform

Python

PowerShell

Proactive monitoring

Education

NQF 6: 3 year Degree/ Diploma/ National Diploma in IT or CS

NQF 4: Grade 12

Tools

Azure DevOps

Terraform

PowerShell

Job description

Spec: Database Administrator MS/SQL - Fixed Term Contract

Department: Data Management Services - Oracle

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
• Customer Focus
• Software Development Life Cycle (SDLC)
• Database Management

Core Behavioural Competencies

• Adhering to principles and values
• Coping with pressures & setbacks
• Deciding & Initiating Action
• Working with people

Minimum Qualifications

• NQF 6: 3 year Degree/ Diploma/ National Diploma in Information Technology or Computer Science
• OR NQF 4: Grade 12

Experience

• 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

Python and or PowerShell (experience advantageous)

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)