Database Administrator - Cape Town
Salary Negotiable
Cape Town, Western Cape
Cape Town,
Western Cape
more than 14 days ago
16-01-2017 4:01:02 PM
13-02-2017 4:01:02 PM
Duties:
- 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
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