Senior SQL Database Administrator - 12409

Job No:  12409
Senior SQL Database Administrator
Cape Town
Rate: Dependent upon experience
12 month contract

Role Purpose:

Responsible for defining, maintaining, implementing and optimizing the architecture and processes of the product and platforms required to meet business goals and objectives.

Responsibilities and work outputs:
Operations:

  • General DBA tasks
  • Design and build for high availability; recoverability;
  • Develop database processes and solutions as it pertains to IT architecture
  • Performance tuning ; SQL; IO; CPU; Memory
  • Maintain required documentation.
  • Windows commands and scripting
  • After hours standby support
  • Service Excellence:
  • Proactively manage the environment to honour required service levels
  • Build and maintain healthy collaborative partnerships with relevant stakeholders

Competencies required:

  • Demonstrate the following skills:
  • Action Orientation
  • Attention to Detail
  • Communicate effectively (Verbal & Written)
  • Conflict handling
  • Client service orientation
  • Effective planning & Time management
  • Show innovative thinking
  • Able to:
  • Understand existing systems and technology
  • Understand business practices and approaches
  • Apply procedures, tools and methods
  • Design technical architecture
  • Work effectively in a team

Experience and Qualifications:

  • Minimum of 5 years relevant experience.
  • MS Certification in SQLServer or similar.
  • Excellent working knowledge of SQLServer
  • SQL performance tuning; Log Shipping; Backup/Recovery.
  • Good knowledge of SSAS; SSRS; SSIS.
  • Good knowledge of relational and document store databases.
  • Excellent working knowledge of Windows OS.
  • Good knowledge of storage sub-systems, identifying and resolving IO bottlenecks.
  • Experience with configuring monitoring & automation tools, like CheckMK; Nagios; Jenkins; TICK; ELK; Grafana.
  • Ability to support and liaise with business process owners to optimize their processes.
  • Must be able to work collaboratively with other areas to advocate good application development techniques.
  • Must possess a high degree of initiative, motivation, and problem-solving skills.
  • Experience with design of high availability & recoverability environments.

Product Specific Knowledge:

  • Advanced SQL Server database administration.
  • High Availability; Backup/Recovery; Performance Tuning.
  • SSAS; SSRS; SSIS.
  • Installation & configuration.
  • Automation / monitoring tools configuration.
  • Experience and Knowledge in PostgreSQL, Hadoop, MongoDB will be an added advantage.