Database Adminstrator - Support Office - IS & T

Western Cape
Salary: Market Related
Job Type: Permanent
Sectors: IT
Reference: 4032906001

Apply before Jan 15 2025 | 28 Days left

Apply

External Application

Vacancy Details

Employer: The Building Company

Introduction:

The purpose of this role is to manage, maintain, and support 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.

Description:

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

Requirements:

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)

Apply

107 people have viewed this job.