Spec: Database Administrator MS/SQL (Fixed Term Contract) at BCX

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

• 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