Database Administrator III

Categories Database Administrator
Salary Market Related
Location Western Cape
Job Information

Job Spec

Our Client in Cape Town requires a Database Administrator III  for a permanent role. The successful candidate will be responsible for ensuring the performance, availability, and security of SQL SERVER instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentations and specifications as required. The SQL SERVER instances will be hosted in our datacenter as well as in AWS/Microsoft cloud platforms.

Qualifications

Essential:

  • Grade 12
  • Tertiary qualification – IT related

Advantageous

  • Relevant courses in database management
  • AWS Associate architect
  • Azure Fundamentals

Experience

  • 5+ years Experience managing SQL SERVER databases, including databases larger than 1TB
  • 3+ years Experience in SQL SERVER versions 2008-2016

Highly advantageous:

  • 3+ years Any experience in using one or more of the Relational Database Management Systems such as MySQL , DB2 and PostgreSQL
  • 1+ year Any experience in NoSQL database management system – MONGODB or Cassandra

Responsibilities

  1. To manage all SQL SERVER installations and upgrades
  • Ensure a standard is applied to all installations
  • Keep track of new software versions and plan upgrades
  • Raise awareness for END-OF-LIFE versions
  1. To assist Development Teams in designing and optimising systems
  • Review database designs and make recommendations to address shortcomings
  • Perform proactive monitoring and feedback to developers, highlighting queries that can be improved
  1. To carry out basic database administrative tasks
  • Check OS and Database logs
  • Do backups and restores as requested
  • Do regular disaster recovery trials
  • Profile server resource usage, optimise and tweak as necessary
  • Resolve incidents
  • Automate maintenance tasks through appropriate scripting language
  • Monitor capacity to prevent unplanned outages
  • Grant permission to servers and databases in conjunction with standards as per SECURITY team
  • Design and implement HIGH AVAILABILITY architecture (log-shipping, mirroring, availability groups)
  • Research, assess and implement new features in SQL SERVER where appropriate and beneficial to solution
  1. To work with SECURITY team to manage access and compliance
  • Regularly review database and SQL instance permissions to make sure appropriate access is in place
  • Regularly review AD groups to make sure membership is still valid
  • Provide output to internal and external auditors as requested
  • Implement encryption and data masking options where required
  • Grant permission to servers and databases in conjunction with standards as per SECURITY team
  • Review SQL SERVER licenses for compliance as well opportunities to reduce costs
  1. To research, assess and implement SQL SERVER variations in AWS/AZURE
  • Investigate Database As A Service(DBaaS) and Platform As A Service(Paas) options in Azure and AWS cloud offerings
  • Research Infrastructure As A Service(IaaS) offerings Azure and AWS
  • Plan database migrations from ON-PREM to cloud for identified systems

Knowledge and Skills

  • 5+ years general understanding of database management concepts
  • 5+ years Strong proficiency in SQL SERVER database management, including Reporting Services

Highly advantageous:

  • 2+ years Solid proficiency in Linux operating system
  • 5+ years Good understanding of InnoDB and MyISAM storage engines
  • 1+ year Familiarity with NoSQL DBMS such as MongoDB

If you have not heard from us after 2 weeks, please consider your application unsuccessful.

Apply Now »