Spec: Database Administrator Ms/Sql - Fixed Term Contract

Bcxp; South Africa; Hybrid; ZAR 520,000 - 700,000; Full time

Job summary

Bcxp is seeking an experienced SQL Server Database Administrator to maintain a stable, secure production environment and optimize performance across Microsoft SQL databases. You will support AlwaysON clusters, implement TDE encryption, and work with Azure SQL Managed Instances.

Ideal candidates have hands-on experience with Azure Data Technologies, DevOps tooling (Azure DevOps, Terraform), and scripting in Python or PowerShell. Hybrid remote work is available with local travel as needed.

Qualifications

• Up to 7 years experience in the administration of Microsoft SQL databases.
• Experience in SQL Server Database Administration, AlwaysON clusters, TDE Encryption, and Performance Tuning.
• Experience in Azure Data Technologies, Azure SQL Server Managed Instances, Azure Data Factory, and DevOps (Azure DevOps and Terraform); Python or PowerShell.

Responsibilities

• Perform SQL Server DBA tasks and maintain stable, secure production databases.
• Provide AlwaysON clusters support and manage TDE Encryption.
• Tune performance and monitor MSSQL instances; proactive issue detection and resolution.

Skills

SQL Server

AlwaysON

TDE Encryption

Performance Tuning

Azure Data Technologies

Azure SQL Managed Instances

DevOps

Terraform

Python

PowerShell

SQL Monitoring

Education

Degree/Diploma in IT or CS

Grade 12 (NQF4)

Tools

Azure DevOps

Terraform

SSMS

Azure SQL Database

Azure SQL Managed Instances

PowerShell

Python

Job description

Business unit, Department, Reporting

Business Unit: Cloud Platform Solutions

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

Additional Education -Preferred /Advantage

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)

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