Connecting...

W1sizmyilcivc3j2l3d3dy9vbgl2zxivy3vycmvudc9wdwjsawmvchjvzhvjdglvbi9wzw9wbgvzb2x2zwqvaw1hz2vzl2jhbm5lci1kzwzhdwx0lwe0n2e3ndcxzmfiyzk3mzkwnzywytaxyzazmjc1nzi0otfizjg0yzdiztcxyjlhmzbjyme4ztnlztg0owm0odcuanbnil0swyjwiiwidgh1bwiilciyntywedqwmcmixv0

Microsoft DBA

Microsoft DBA

Job Title: Microsoft DBA
Location: Western Cape
Industry:
Salary: 360000.00
Reference: JN -092016-6697
Job Published: January 18, 2017 08:10

Job Description

Job Title: 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