Shoprite Group: Database Administrator (x3 Posts)

Shoprite Group is looking for an experienced SQL SERVER database administrator who will be responsible for ensuring the performance, availability, and security of SQL SERVER instances.

Closing date: 18 July 2024

Location: Western Cape

Job Objectives

• To manage all SQL SERVER 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( log shipping,mirroring, availability groups ).
• Research , assess and implement new features in SQL SERVER where appropriate and beneficial to solution.

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

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

Qualifications

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

Experience

• Experience managing SQL
• SERVER databases, including databases larger than 1TB
• Experience in SQL SERVER versions 2014-2019
• Experience with cloud database deployments in Azure and /or AWS
• Experience with data encryption using SQL SERVER

Knowledge and Skills

• General understanding of database management concepts.
• General understanding of database management concepts in cloud platform – AZURE and/or AWS.

• Strong proficiency in SQL SERVER database administration – backups, restores, installation , patching and monitoring error logs.
• SQL SERVER query performance tuning.
• SQL SERVER transparent data encryption.
• Experience configuring SQL SERVER

• ALWAYSON AVAILABILITY groups and DATABASE MIRRORING.
• Writing STORE PROCEDURES.
• MIgration of SQLSERVER from ON-PREM to AZURE/AWS

Shoprite Group is looking for an experienced SQL SERVER database administrator who will be responsible for ensuring the performance, availability, and security of SQL SERVER instances. Closing date: 18 July 2024 Location: Western Cape Job Objectives To manage all SQL SERVER installations and upgrades: Ensure a standard is applied to all installations. Keep track of …

Opportunities for the young and unemployed youth in South Africa