Sql Dba - Cape Town
Salary Negotiable
Cape Town, Western Cape
Cape Town,
Western Cape
more than 14 days ago
26-09-2016 4:00:06 PM
24-10-2016 4:00:06 PM
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