Job Description

Company based in Bree Street, Cape Town

Industry - Telecommunications

Permanent

Please forward your updated CV to Michelle - kindo.m@abcworldwide.com

Database MS Administrator

The Data Base Administrator's role is to design, install, administer, and optimize company data base servers Instances and related components to achieve high performance of the various business applications supported by tuning the data base (SQL Packages, SQL Functions, SQL Triggers as necessary. This includes ensuring the availability of Microsoft Data Bases, configuring all new implementations, and developing processes and procedures for ongoing management of the Data Base (instances) / Server environment.

KEY RESPONSIBILITIES

Responsibility

Core activities

Framework

Operational Management

Deploy and maintain pro-actively the introduced solution for managing data and application servers across the infrastructure estate.

Native MS SQL Solution

Microsoft Operations Manager

Microsoft SQL Server Enterprise Studio

Responsibility

Core activities

Framework

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

Responsibility

Core activities

Framework

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 Failover clustering, log shipping, replication, failover

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

Responsibility

Core activities

Framework

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 supportability

Tools like MS Visio. Kanban Board (Target Process), Sharepoint Wiki

Microsoft SQL Server Enterprise Studio

Responsibility

Core activities

Framework

Operational Management - End User Support

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

ITSM Helpdesk tickets, Team calls and meetings

Responsibility

Core activities

Framework

Change Management

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

ITSM Helpdesk tickets, Charm

Responsibility

Core activities

Framework

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

Responsibility

Core activities

Framework

Planning, Operational Management

Architecting, deployment and support of standalone and highly available data and application solutions across an array of critical business environments.

Microsoft SQL Server

Microsoft Operations Manager

Charm, ITSM

Responsibility

Core activities

Framework

Strategy & Planning

Risk and performance assessment of data and application solutions, including performance analysis, design architecture, server configurations and DR strategies.

Microsoft SQL Server Enterprise Studio

Responsibility

Core activities

Framework

Operational Management

Remediation and performance optimization of data and applications servers - performance tuning, query, index, CPU, RAM, and disk subsystem IO optimisation

Microsoft SQL Server

Microsoft Operations Manager

Charm, ITSM

Responsibility

Core activities

Framework

Operational Management

Ensuring SQL Server supportability across data solutions and performing remediation assessments

Microsoft SQL Server

Microsoft Operations Manager

Charm, ITSM

Responsibility

Core activities

Framework

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

KPI's

Complexity

Deliver profession support to the business

Reduction in outages related to data bases

Delivery of an Ardagh Change Management Methodology

Key Business contacts (internal):

Key Business Contacts (external):

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

AKA Brip Careers Worldwide