Database Ms Administrator

Database MS Administrator

**KEY RESPONSIBILITIES**

Operational Management

Native MS SQL Solution

Microsoft Operations Manager

Microsoft SQL Server Enterprise Studio

Capacity Management

Backups, disk and database capacity management, server and database instance configurations, event and server logs analysis

Microsoft SQL Server

Microsoft SQL Server Enterprise Studio

Microsoft Operations Manager

Operational Management

Proactive and reactive administration and maintenance of the group SQL server Infrastructure

Application of patches, backups and verification and backup restores, high availability solutions - Fail-over clustering, log shipping, replication, fail-over

availability groups.

Agent job failures, events and logs, CPU, RAM and Disk IO issues

Microsoft SQL Server

Microsoft SQL Server Enterprise Studio

Microsoft Operations Manager

Strategy & Planning

Consolidation and migration of server and database instances across an array of environments within the estate to reduce licensing and administrative overhead

and reduce business risk by maintaining support-ability

Tools like MS Visio. Kanban Board (Target Process), Share-point Wiki

Microsoft SQL Server Enterprise Studio

Operational Management - End User Support

Pickup tickets and user requests and report abnormal situations/concerns about systems

ITSM Helpdesk tickets, Team calls and meetings

Change Management

Support development teams in code review, manage change and deploy code across the sever estate.

ITSM Help-desk tickets, Charm

Planning

Consultation in specifying, gathering requirements and designing of data solutions

Microsoft SQL Server

Microsoft SQL Server Enterprise Studio

Microsoft Operations Manager

Charm, ITSM

**Responsibility**

**Core activities**

**Framework**

Operational Management

Change Management

Deploy and configure new server and database instances or consolidate unto an existing standalone or highly available environment.

Microsoft SQL Server

Microsoft SQL Server Enterprise Studio

Microsoft Operations Manager

Charm, ITSM

Planning, Operational Management

Microsoft SQL Server

Microsoft Operations Manager

Charm, ITSM

Strategy & Planning

Microsoft SQL Server Enterprise Studio

Operational Management

Microsoft SQL Server

Microsoft Operations Manager

Charm, ITSM

Operational Management

Ensuring SQL Server support-ability across data solutions and performing remediation assessments

Microsoft SQL Server

Microsoft Operations Manager

Charm, ITSM

Operational Management

Implementing and documenting a framework for DR testing. Performing regular DR scenarios to ensure SLA’s remain viable.

Microsoft SQL Server

Microsoft Operations Manager

Charm, ITSM

Deliver profession support to the business

Reduction in outages related to data bases

Delivery of an Ardagh Change Management Methodology

Application Solution Team

Business functional managers, including Group

Key and End-users in the various business functions

Various Functions

Suppliers or customers impacted by change

**Decision making authority**:
Free to decide the best way to fulfill demands from internal customers and development style.

New tools, external developments and off the shelf software to be agreed with manager.

**Education & Training**:
Microsoft SQL Server administration

Microsoft Visual Studio 2017 (or newer) and how to work with Team Foundation Server

Measure Performance of Software (i.e. using Redgate SQL tools, MS Visual Studio, )

ITSM Help-desk

Share-point Wikipedia system

Kanban and Scrum (i.e. use of Target Process)

**Experience**:
At least five years’ equivalent work experience in a data base administration position responsible for managing Database environments.

Professional development skills in MS SQL (Packages, Functions, Triggers)

Experience with MS Data Base performance tuning and monitoring tools.

Proven knowledge of systems development life cycle methodologies

**Competencies**:
Work with international teams and different skills as a team player

Ability to conduct research into data base issues and db products as required.

Ability to present ideas in business-friendly and user-friendly language.

Highly self motivated and directed, with keen attention to detail.

Proven analytical and problem-solving abilities.

Ability to effectively prioritize tasks in a high-pressure environment

**Job Type**: Permanent

**Salary**: R46,000.00 - R48,000.00 per month

Ability to commute/relocate:

- Cape Town, Western Cape: Reliably commute or planning to relocate before starting work (required)