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 optimising 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
To uphold and promote the company values and culture
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
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 (advantegeous)