Database Administrator Ii

3 weeks ago

Brackenfell, South Africa Shoprite Group Full time

Closing Date
2023/06/30
- Reference Number
SHO230623-4
- Job Title
Database Administrator II
- Job Type
Permanent
- Location - Country
South Africa
- Location - Province
Western Cape
- Location - Town or City
Brackenfell, Cape Town
- 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 Advert Details
- Job Category
IT
- 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

  • Solutions Architect Ii

    4 weeks ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2023/12/18 - Reference Number SHO231204-3 - Job Title Solutions Architect II - Job Type Permanent - Location - Country South Africa - Location - Province Western Cape - Location - Town or City Brackenfell, Cape Town - Purpose of the Job As a recognized data engineering authority the Solution Architect collaborates in data engineering standards...

  • Administrator

    6 hours 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...

  • Solutions Architect Ii

    4 weeks 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,...

  • Tender Administrator

    4 weeks ago

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

  • Junior Lab Technician

    1 month ago

    Brackenfell, South Africa AKS Lining Systems Full time

    **Position Overview**: Performs a variety of inspections, sampling procedures and tests for the manufacturing process according to GRI and ASTM methods and standards. Compile all related quality documents and records. Performs factory inspections and liaise with the Production and Logistics departments on all quality related procedures and standards....