Database Administrator Iii

4 weeks ago


Brackenfell, South Africa Shoprite Group Full time

**Purpose of the Job**:
We are looking for an experienced SQL SERVER database administrator who 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.

**Job Objectives**:
To manage SQL SERVER installations and upgrades.
To assist Development Teams in designing and optimising systems.
To carry out database administration tasks.
To work with SECURITY team to manage access and compliance.
To research, assess and implement SQL SERVER variations in AWS / AZURE.

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( logshipping,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 - Years (5+)
Experience in SQL SERVER versions 2014-2019 - Years (3+)
Experience with Azure SQL;Azure SQL Managed Instances - Years (2+)
Experience with data encryption using SQL SERVER

**Knowledge and Skills**:
General understanding of database management concepts - Years (5+)
Strong proficiency in SQL SERVER database administration - backups, restores, installation, patching and monitoring error logs - Years (5+)
SQL SERVER query performance tuning - Years (5+)
SQL SERVER transparent data encryption - Years (1+)
Experience configuring SQL SERVER ALWAYSON AVAILABILITY groups and DATABASE MIRRORING - Years (2+)
Writing STORE PROCEDURES - Years (5+)
MIgration of SQLSERVER from ON-PREM to AZURE/AWS - Years( 2+)

**Applicant Feedback Policy**:



  • Brackenfell, South Africa Shoprite Group Full time

    Closing Date- 2024/12/26- Reference Number- SHO241212-3- Job Title- Database Administrator III- Job Type- Permanent- Location - Country- South Africa- Location - Province- Western Cape- Location - Town or City- Brackenfell, Cape Town- Purpose of the JobWe are looking for an experienced SQL SERVER database administrator who will be responsible for ensuring...

  • Database Administrator

    15 hours ago


    Brackenfell, South Africa Disruptive IT Full time

    To work with software vendor for knowledge transfer Engage with software vendor to get a detailed understanding of how the data / database needs to be managed. Produce documentation so that other DBAs are able to provide support of the system. Understand how data access/auditing is done. Understand how data backup / recovery is implemented. To carry out...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Database Administration Apprentice is to assist the database administration team in managing and maintaining the system databases. This role works closely with the database administration team to ensure the integrity, security, and efficient operation of databases. This role collaborates within the team and other...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: To research, evaluate and recommend relevant DBMS products. To assist Development Teams in designing and optimising systems. To ensure information security and regulatory compliance. To carry out database administration tasks. **Job Objectives**: To research, evaluate and recommend DBMS products: Evaluate and compare strengths and...

  • Programmer Iii

    7 months ago


    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: To implement and maintain SDLC for IT System DevOPS. To administer Bitbucket access for versioning control Perform peer reviews for signoff of all technical designs Perform peer reviews for deployment of all code Assist team leads and architects with solution design To assist and guide the team members in technical designs Be involved...

  • Administrator

    7 months ago


    Brackenfell, South Africa The Joblink Full time

    Contact person for this position: Cathrine Hendricks Our client is seeking a mature office Administrator to join their team. **DUTIES** - General Office Administration. - Processing and capturing orders - Corresponding with suppliers for pro-forma invoices, tax invoices and delivery notes. - Administrative tasks as allocated by managers - Payroll and...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Data Administrator role is to provide operational and administrative support to the Data Management function through the execution of data inputting on various systems with the aim of providing business units with accurate information that facilitates decision-making. The role forms part of a centralized...

  • Senior Administrator

    3 months ago


    Brackenfell, South Africa Provisionisr Full time

    **SENIOR ADMINISTARTOR**: **JOB DESCRIPTION**: A senior administrator is responsible for the day-to-day operations of a company, and their role is critical to effective business management. **Our team at PROVISION ISR is seeking a senior administrator to join our dynamic team this person has to be Tech savvy, has strong numerical knowledge and a go getter!...


  • Brackenfell, South Africa House of Supreme Full time

    **Office Administrator** **Our Company in Brackenfell is seeking an Office Administrator for the Branch.** **You will be the face of the Branch and need to have a bubbly personality and a go getter attitude.** **Requirements**: - Grade 12 / Matric - Valid Drivers License and reliable transport - Office administration Experience - Strong organizational...


  • Brackenfell, South Africa Ouhout Meubels Full time

    We are looking for a detail-oriented and proactive **Operations Administrator** to join our dynamic team and help streamline daily operations, improve efficiency, and ensure seamless business processes. **Duties**: - Manage and coordinate operational processes to ensure efficiency and quality of service. - Assist in the preparation of reports, documents,...


  • Brackenfell, South Africa Southtrade Full time

    70 year old import company seeks to employ an Internal Sales Administrator. **Responsibilities include**: - Preparing and submitting of quotations/tenders both written and electronically - Monitor tender pages daily - Maintaining accurate records and databases of quotations/tenders - Ensuring that tenders are fully compliant with the tender requirements...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Data Administration Team lead role is to provide operational and administrative support to the Data Management function through the execution of data processing operations including executing data inputting on various systems, prioritisation of business requests, resolving complex data scenarios and providing...


  • Brackenfell, South Africa BCXP Full time

    Business unit, Department, Reporting **Business Unit**: CPS **Department**: Field Services Core Description The provide administrative support during the execution of IT projects. This includes the scheduling of meetings, maintenance of databases, monitoring project progress and general project administration Key Deliverables / Primary Functions Assisting in...


  • Brackenfell, South Africa Edge Personnel (Pty) Ltd Full time

    An established, dynamic and well-developed company based in Brackenfell, has an opportunity available for an experienced individual that specializes in tender administration. Great opportunity to join this fast-paced team with your excellent communication skills in both English and Afrikaans and add value to the smooth running of all of their tender...

  • Solution Architect Iii

    6 months ago


    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: **Job Objectives**: Provide input into the SAP Technology Strategy and future operational / capital plans around technology solutions and ensure suitable governance around the definition and management of technology to ensure these strategies and plans are implemented. Develop and maintain SAP Technology strategies, standards and...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: Responsible for the coordination of the software and hardware involved with running the computer networks and infrastructure with the aim of ensuring the system can handle all networking tasks while meeting security requirements. This includes performing updates, improvements, installations, and maintenance of networks, servers, and...

  • Analyst Programmer

    7 days ago


    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: **Job Objectives**: **Qualifications**: 3 year Degree/Diploma - Essential Degree/Diploma in Information Technology - Desirable** Experience**: Essential: 8 years Analysing and programming experience Desirable: Experience in the required tasks in a retail environment** Knowledge and Skills**: Essential: Systems Analysis Data Analysis...

  • Admin Assistant

    2 months ago


    Brackenfell, South Africa Synergy Advisory Group Full time

    **Job Summary**: **Key Responsibilities**: - **Administrative Support**: - Perform all admin tasks delegated by the Client Relationship Manager and Compliance Officer. - Serve as the point of contact for client inquiries, providing timely and professional responses. - Manage and organize client files, ensuring all documents are accurately filed and...

  • Programmer I

    15 hours ago


    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: **Job Objectives**: - Perform day-to-day troubleshooting & support of integration systems - Development of integration requirements to support business and internal projects - Configure integration data flow - Troubleshooting and identifying root causes - Collaborate with the Integration Support team to smoothly transition new flows...


  • Brackenfell, South Africa Synergy Advisory Group Full time

    **Job Summary**: **Key Responsibilities**: - **Administrative Support**: - Perform all admin tasks delegated by the Client Relationship Manager and Compliance Officer. - Serve as the point of contact for client inquiries, providing timely and professional responses. - Manage and organize client files, ensuring all documents are accurately filed and...