Database Administrator Ii

5 months ago


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 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
Determine best use cases for each product
Conduct system performance testing for each product

Assist Development Teams in designing and optimising systems:
Liaise closely with development teams gathering their requirements.
Review database designs and make recommendations to address shortcomings.
Perform proactive monitoring and feedback to developers, highlighting queries and processes that can be improved upon.

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.

To carry out database administration tasks
Perform daily health checks for databases and resolve any issues identified
Check OS and Database logs.
Ensure database backups are scheduled and completing successfully
Verify backups are valid by testing restore process regularly.
Monitor databases so that capacity constraints can be mitigated by timeous provisioning of resources.
Close incidents within SLA
Execute database changes according to change management process
Assist developers with any database issues
Do regular disaster recovery trials.
Profile server resource usage, optimise and tweak as necessary
Resolve incidents.
Automate maintenance tasks through appropriate scripting language.
Grant permission to servers and databases in conjunction with standards as per SECURITY team.
Implement DBMS with HIGH AVAILABILITY architecture.

**Qualifications**:
Grade 12
Degree/Diploma Information Systems/Technology
Industry Certification: AWS Associate Architect and / or AZURE FUNDAMENTALS

**Experience**:
Experience in administering one or more DBMS such as MySQL, PostgreSQL, DB2 and MongoDB.
Experience working with services in AWS and AZURE cloud platforms
Proficient with some of the common developer tool sets such as Java, XML, JSON, REST, Shell, Perl and Python.

**Knowledge and Skills**:
General understanding of database management concepts
Proficient with installing, configuring, administering, using and benchmarking DBMS such as MySQL, PostgreSQL, DB2 or MongoDB.
Basic familiarity with Linux operating system
Some experience engineering and/or administering NoSQL infrastructure
Proficient with one or more Apache Software Foundation Big Data & Database projects such as Cassandra, Hadoop, HBase, MongoDB
Proficient with some of the common developer tool sets such as Java, XML, JSON, REST, Shell, Perl

**Applicant Feedback Policy**:



  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the SAP Access Administrator II is to provide efficient system administrative support, ensuring accurate and timely SAP Access provisioning of relevant systems and tools to the Shoprite Group store and distribution center users. This includes monitoring and evaluating business requests, executing system roles...


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

  • Administrator

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

  • Programmer Ii

    5 months ago


    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of this role is to competently write, modify, refactor, debug, troubleshoot and test new or existing systems of medium to high complexity and scale, ensuring that the code functions reliably and optimally according to Shoprite programming standards. The role works alongside the Programming team and requires specialised...

  • Senior Administrator

    3 weeks 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!...

  • Solutions Architect Ii

    7 months ago


    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: As a recognized data engineering authority the Solution Architect collaborates in data engineering standards & controls and creates the data engineering architecture for the target environments to deliver data pipelines into the bigger Business Intelligence environments. The solution architect will collaborate closely with the data,...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: To design, build, test and maintain authorisation roles to meet business requirements To execute the agreed SAP Access Control principles and processesas designed. To analyse and solve risks related to SAP authorisation To design future authorisation concepts for Shoprite **Job Objectives**: To design, build, test and maintain...


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

  • Credit Controller

    5 months ago


    Brackenfell, South Africa PikUniq Full time

    **About the Company**:Manufacturer **About the role**:Looking for an experienced Credit Controller with 5 years plus ongoing maintenance of Debtor’s accounts, Opening of Accounts, and Timeous collection of Overdue Accounts/Order Releasing. Ad hoc administration duties as well. This is an EE Position ONLY - Full debtors’ function - multiple branches (one...

  • Admin Assistant

    1 week 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...


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


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: As a Salary Accounts Officer: Medical Aid Team, you are responsible for accurately accounting for, reconciling and preparing medical aid payroll-related accounts. The role participates in various aspects of the end-to-end payroll accounts cycle at various times, including but not limited to reconciling payroll-related general ledger...

  • Programmer Iii

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


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: As a Finance Payroll Accounts Supervisor for the Medical Aid Team, you are responsible for all RSA Medical Aid products, accounting, payments, and reconciliations. This role is essential in the Medical Aid process, which includes payroll, the Medical Aid Principal Officer, and third-party product providers to ensure employees receive...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Security Operations Lead role is to safeguard the organisation's information assets and efficiently handle any security incidents to mitigate their impact. This includes analysing and planning for remediation of discovered vulnerabilities, facilitating, tracking, and mitigation of vulnerability findings together...


  • Brackenfell, South Africa Shoprite Group Full time

    Closing Date - 2024/09/24 - Reference Number - SHO240917-3 - Job Title - Salaries Recon Supervisor - Job Type - Permanent - Location - Country - South Africa - Location - Province - Western Cape - Location - Town or City - Brackenfell, Cape Town - Purpose of the Job As a Finance Payroll Accounts Supervisor for the Medical Aid Team, you are responsible for...


  • Brackenfell, South Africa Shoprite Group Full time

    Closing Date - 2024/09/23 - Reference Number - SHO240909-5 - Job Title - Security Operations Lead - Job Type - Permanent - Location - Country - South Africa - Location - Province - Western Cape - Location - Town or City - Brackenfell, Cape Town - Purpose of the Job The purpose of the Security Operations Lead role is to safeguard the organisation's...


  • Brackenfell, South Africa Ribbens Office National Full time

    Job Summary: The Interior Consultant Showroom Assistant provides support and assistance to interior consultants in a showroom setting. The assistant plays a vital role in creating a positive customer experience by providing excellent customer service, maintaining the showroom's appearance, and assisting customers with product selection and inquiries. This...