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

Job description:

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. 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.

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