Database Administrator (DBA)

KEY PERFORMANCE AREAS

General

• Design and document database architecture

• Design Data Warehousing and Business Intelligence platform

• Build database scheme, tables, procedures and permissions

• Develop database utilities and automated reporting

• Create shell scripts for task automation

• Create, test and execute data management languages

• Analyse, consolidate and tune database for optimal efficiency

• Analyse and sustain capacity and performance requirements

• Monitor systems and platforms for availability

• Restore and recover corrupted databases

• Install and test corrupted databases

• Install and test upgrades and patches

• Implement security and encryption

• Evaluate and recommend new databases technologies storage, archiving, backup and recovery procedures are functioning correctly

• Establish need for users and monitor access and security

• Assist database architect where required

• Ensure that DB systems are functioning correctly and meeting the company’s clients requests and needs 

 
COMPETENCIES

Qualifications

• Matric

• MCDBA or MCITP (Microsoft qualification)

Specific Skills (Technical):

• Minimum 2-years SQL Database administration in a highly pressurized environment

• Extensive use of Standard Query Language

• SQL, T-SQL, , MSSQL (2000, 2005, 2008 R2,2014)

• SSIS, SSRS and Analysis Services experience

• Programming knowledge / Project Management / Resource Management / Network Knowledge / OS Admin Knowledge advantageous 

The successful applicant must:

• Be available for 24hr Standby when required

• Eager to learn

• Have a high attention to detail

• Be able to work independently as well as be a team player

• Be result and deadline driven

• Work well under pressure

• Have excellent communication and interpersonal skills, both oral and written

• Be able to take ownership of problems and co-ordinate to resolution

• Be able to prioritise tasks and manage multiple tasks