JUNIOR DBA (AA/EE) CAPE TOWN IN SOUTH AFRICA

Candidates must currently be Cape Town based. Responsibilities 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 Monitor access and security Assist database architect where required Ensure that DB systems are functioning correctly and meeting the company’s clients needs Qualifications, Experience & Skills Matric MCDBA or MCITP (Microsoft qualification) 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 Advantageous: - Programming knowledge - Project Management - Resource Management - Network Knowledge - OS Admin Knowledge Other Requirements 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 and manage multiple tasks Be available for 24hr Standby (should it be required)