Database Administrator III - Brackenfell at Shoprite Group of Companies

Job Objectives    
To manage all DBMS installations and upgrades:

• Ensure a standard is applied to all installations.
• Keep track of new software versions and updates and plan upgrades.
• Raise awareness for END-OF-LIFE versions

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.

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. 
• Research, assess and implement new features where appropriate and  beneficial to solution.

To work with SECURITY team to manage access and compliance:

• Regularly review database and 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 DBMS software licenses for compliance as well opportunities to 
• reduce costs.

To research, assess and implement DBMS 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. 

Qualifications    

• Grade 12 
• Tertiary qualification related to IT 
• Relevant courses in database management 
• AWS Associate architect 
• Azure Fundamentals 

Experience    

• 5+ Years experience in managing MySQL and / or Postgres including databases larger than 1TB
• 2+ Years experience in NoSQL database management system - MONGODB or Cassandra.

Knowledge and Skills    

• General understanding of database management concepts
• Time Essential Desirable
• Strong proficiency in performance tuning.
• Strong proficiency in backup / restore techniques
• Strong proficiency in Linux operating system
• Familiarity with NoSQL DBMS such as MongoDB