Synopsis
We are excited to announce a permanent position for a MS SQL Database Administrator for our client in Cape Town. You will be responsible for managing, maintaining and supporting the Microsoft SQL Server environment within the IS / IT environment and the business by leveraging your skills in SQL scripting, data architecture methodologies and best-practices, as well as big-data to provide accurate datasets to a multitude of systems and applications, assisting our stakeholders with decision-making.

Qualification and Experience
Grade 12
MCSA: SQL Server 2012/2014 or later
MCTS, MCITP certification (advantageous)
Minimum of 5 years’ experience administering Microsoft SQL Servers and databases; SQL scripting; big-data and business intelligence applications such as Qlik and IBM COGNOS.
Experience with backups, restores, and recovery models.
Experience with Performance Tuning and Optimization (PTO) using native monitoring and tooling.
Knowledge of High Availability (HA) and Disaster Recovery configurations and options for SQL Server
Demonstrable understanding of relational database systems; scripting / coding languages
Proficiency in MS SQL Server 2014 or later
Ability to translate business requirements into functional system specifications, processes, and procedures.
Experience working with Kerridge Commercial Systems ERP. (advantageous)
Experience working with Windows Server, Active Directory, and Azure (advantageous)
Experience with scripting languages such as C#, C++, Java (advantageous).

Roles and Responsibilities
SQL Servers and Database management: Manage and maintain SQL Server/s and database/s within development and production environments.
Configure and optimize database servers: Responsible for configuring and optimizing database servers and related processes to ensure high availability, performance, and on-going operations of the SQL environment.
Patch maintenance: Perform scheduled maintenance and routine patching and upgrades from time-to-time.
Process refinement: Automate and refine processes, track issues, and document environment configurations and changes.
Monitor relevant environments: Contribute to the maturation of proactive monitoring of the relevant environments to prevent issues from occurring in future.
Report writing – Responsible for reporting on SQL scripting, SSIS, SSRS.
Facilitating with 3rd parties: Facilitating resolution of bugs and issues identified in SQL scripting, SSIS, SSRS applications and environments with 3rd parties.
Data modelling: Ensure development and implementation efforts meeting integration and performance expectations.
Customer Service: Provide support for critical production systems and end-of-day processing.