Latest Jobs at The Shoprite Group of Companies

Job Objectives    
1. To research, evaluate and recommend DBMS products

• Evaluate and compare strengths and weaknesses of DBMS products
• Produce documentation to be used in solution architecture decision making
• Rank ease of setup and management effort required for each product
• Rank monitoring and alerting capabilities for each product

2. 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.

3. 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 HIGH AVAILABILITY architecture.

4. To ensure information security and regulatory compliance:

• Ensuring system security meets regulatory compliance.
• Manage server security remediation activities which will include conducting vulnerability scans, patching and implementing DBMS specific features.
• Will work very closely with SECURITY and APPLICATION teams.

Qualifications    

• Grade 12
• IT-related qualification
• Industry Certification Desirable

Experience    

• 5+ years managing MySQL databases
• Experience in administering one or more DBMS such as MySQL, PostgreSQL, DB2 and MongoDB. (Expert level in one of these is essential.)
• AWS and AZURE cloud platforms experience

Knowledge and Skills    

• 4+ Years General understanding of database management concepts.
• 4+ Years Proficiency with installing, configuring, administering, using and benchmarking DBMS solutions.
• 3+ Years Basic familiarity with Linux operating system
• 2+ Years Some experience engineering and/or administering NoSQL infrastructure
• 2+ Years Proficiency with one or more Apache Software Foundation Big Data & Database projects such as Cassandra, Hadoop, Hbase, MongoDB
• 4+ Years Knowledgeable in designing, developing & amp; documenting use cases.
• 2+ Years Proficiency with some of the common developer tool sets such as Java, XML,JSON, REST, Shell, Perl and etc.