Junior Maria/mySQL Database Administrator

2 weeks ago

Bellville, Western Cape, South Africa Sanlam Full time
Who are we?

Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture.

We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology governance and risk orchestrator for technology across Sanlam.

What will you do?

The MariaDB / MySQL DBA is expected to administer, monitor, and troubleshoot all components of the MariaDB / MySQL Platform including the core database as well as the additional components and functionality.

The MariaDB / MySQL DBA will also be responsible for security administration as well as administration tasks related to SDLC.

The MariaDB / MySQL DBA will also be expected to escalate and consult with team members in troubleshooting and improving performance of the DBMS.

What will make you successful in this role?

Responsibilities:

Ongoing maintenance tasks to ensure database system is available
Ongoing maintenance tasks to ensure database system is secure
Ongoing maintenance tasks to ensure database performance
Review and tracking of database performance
Review and tracking of ongoing suspicious transactions on database
Review and tracking of health of underlying operating system
Response to analysis of Incidents of database
Perform patching of database
Escalation of performance, security or availability issues
Deployment of add-ons, plug-ins or enhancements as allowed on the platforms
User and security administration on the DBMS
Create and change users, assign and remove role assignments, perform password resets, lock and unlock accounts.
Create and change security roles by adding and removing relevant permissions
Create, change and troubleshoot analytical privileges (data dependent authorizations)
Troubleshoot security issues
Ensure backups of DBMS or databases take place in line with design
Ensure replication of DBMS or databases take place in line with design
Ensure restore of DBMS or databases are actioned in line with design and policy
Log urgent or complex events or incidents with Database provider ensuring necessary supporting information is available
Ensure data in database conform to Regulations and relevant company policies and the maintenance of data (including data deletion)
Execute process required to promote code and structures between databases in line with SLDC and company policies
Execute refresh of data in Dev and QA databases in line with guidelines
Ensure monitoring tools of the DBMS active Knowledge and Experience
DBMS Knowledge
Working knowledge and understanding of MariaDB / MySQL DBMS,
Sound working knowledge of the operating system MariaDB / MySQL server resides on and usage of underlying infrastructure. (Linux)
Knowledge of general database concepts
Working knowledge and understanding of replication for MariaDB / MySQL
Working knowledge and sound understanding of all available products, services and resources in the MariaDB DBMS Server suite of products

Knowledge to advise and execute on integration to the MariaDB/MySQL environment including ODBC, JDBC, ODBO and other MariaDB supported connectors.

Knowledge of the MariaDB to monitor database performance and troubleshooting
Design, configure, troubleshoot MariaDB Workload Management
Familiar with Linux Operating system
Use advanced Linux bash / MariaDB command line tools to monitor, administer and troubleshoot
Knowledge of general database concepts Qualifications

Qualifications:

Matric
Degree or Diploma in Information Technology
Database Administration certification(preferable)
Knowledge and Skills Database Queries and Reports Database Security Applications Database Knowledge Data Analysis Compliance Personal Attributes Interpersonal savvy - Contributing independently Decision quality - Contributing independently Plans and aligns - Contributing independently Optimises work processes - Contributing independently Build a successful career with us
We're all about building strong, lasting relationships with our employees.

We know that you have hopes for your future - your career, your personal development and of achieving great things.

We pride ourselves in helping our employees to realise their worth.

Through its four business clusters - Sanlam Life and Savings, Sanlam Investment Group, Sanlam Emerging Markets, Santam, as well as MiWay and the Group Office - the group provides many opportunities for growth and development.

Core Competencies Being resilient - Contributing independently Collaborates - Contributing independently Cultivates innovation - Contributing independently Customer focus - Contributing independently Drives results - Contributing independently Turnaround time
The Sanlam Group is committed to achieving transformation and embraces diversity. This commitment is what drives us to achieve a diverse, inclusive and equitable workplace as we believe that these are key components to

  • Junior SAP Hana Database Administrator

    2 weeks ago

    Bellville, Western Cape, South Africa Progressive IT Resourcing Full time

    Our ClientThis division is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology governance and risk...

  • Database Administrator

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology...

  • Senior Database Administrator

    2 weeks ago

    Bellville, Western Cape, South Africa CareerfinderZA Full time

    Key Performance Area: Oversee all data generated, monitor server transaction speeds, and look for any service degradation in speeds due to SQL fragmentation or lack on maintenance Oversee all SQL instances and databases Ensure all databases of the same platform is up to data and the same Ensure data is accurate and integrity is maintained with SQL backups...

  • Junior / Contract Administrator

    2 weeks ago

    Bellville, Western Cape, South Africa Aluvent Full time

    Aluvent (Pty) Ltd, a well-established company who prides themselves for their client service and support is looking for a dynamic Junior / Contract Administrator to join their team.Requirements for the position: Must be fluent in both Afrikaans and English 2 year experience in a similar Administror role required Knowledge in the Glass and Aluminium...

  • Accounting & Administrative Junior Clerk

    2 weeks ago

    Bellville, Western Cape, South Africa Accounting & Tax Services Full time

    Accounting & Administrative Junior ClerkAccounting practice near Tyger Valley is looking to employ a young individual to form part of our team.The position offers plenty of growth and development opportunities.Duties and requirements include but are not limited to the following:Capturing/Data processing on Pastel & Xero Assisting with various accounting,...

  • junior bookkeeper

    2 weeks ago

    Bellville, Western Cape, South Africa Wenz Recruitment Full time

    JUNIOR BOOKKEEPEROur client in the Bellville area and manufacturing industry is seeking to employ a JUNIOR BOOKKEEPER RESPONSIBILITIES:Debtors and creditors controlVAT calculationsAssist with salaries and payroll as requiredDeal with financial enquiries as need beGeneral administration, filing and reception dutiesProcessing of all accountsManaging accounting...

  • Junior New Business Development Advisor

    2 weeks ago

    Bellville, Western Cape, South Africa Time Personnel Full time

    Job OverviewDate Posted:Posted 4 hours agoLocation:Bellville, Western CapeJob Title:Junior New Business Development AdvisorEducation Level:High School / MatricJob Level:JuniorMinimum Experience:3 YearsJunior New Business Development Advisor - Bellville, Cape Town.Are you a target-driven person and confident in connecting with potential clients...

  • Junior Admin Assistant

    2 weeks ago

    Bellville, Western Cape, South Africa HotelJobs Full time

    We are looking for a Junior Administrator Assistant and will be responsible for:Invoicing Creating Purchase Orders Sourcing products for clients to quote on Creditors Debtors Answering of telephones Filing

  • Accounting & Administrative Junior Clerk

    2 weeks ago

    Bellville, Western Cape, South Africa Accounting & Tax Services Full time

    Accounting & Administrative Junior ClerkAccounting practice near Tyger Valley is looking to employ a young individual to form part of our team.The position offers plenty of growth and development opportunities.We are looking for the following in an applicant:Speak, read and write in English and Afrikaans Understanding of VAT & PAYE Knowledge of Pastel & Xero...

  • Administrative Officer

    2 weeks ago

    Bellville, Western Cape, South Africa University of the Western Cape Full time

    Post Number Faculty/Department- University of the Western Cape -> Registrar -> Deputy Registrar: Academic Administration- Type of Position- Permanent - Full Time- Length of Contract Period- Location- Main Campus - Bellville, WC ZA (Primary)- Closing Date- 21/4/2024Role Clarification & Key Performance AreasThe primary area of responsibility of the Office of...

  • Junior Finance Assistant

    2 weeks ago

    Bellville, Western Cape, South Africa HotelJobs Full time

    A new restaurant is opening in the heart of Claremont - Cape Town and is looking for a Junior Finance Assistant to be responsible for keeping track of an organization's financesRESPONSIBILITIES Update financial spreadsheets with daily transactions Prepare balance sheets Track and reconcile bank statements Create cost analysis reports (fixed and variable...

  • Office Administrator

    2 weeks ago

    Bellville, Western Cape, South Africa Stefan Steenkamp - Real Estate Full time

    An exciting opportunity has arisen for an Administrator to join a Real Estate company. You will provide administrative and secretarial support. You will be responsible for updating current CRM and related administrative responsibilities + contract preparation + client liaison + telephonic canvassingThis is a fantastic opportunity for a junior administrator...

  • Linux Intern

    2 weeks ago

    Bellville, Western Cape, South Africa Nexio Full time

    ROLE PURPOSEResponsible for the 1st line Linux system administration support at customer site. This will include daily systems tasks, reporting and first line system administration of Linux systems within this environment.ROLE REQUIREMENTS Junior level within a major Function for a business unit. No direct impact on business performance Junior role no...

  • Junior Interior Designer

    2 weeks ago

    Bellville, Western Cape, South Africa SQ Design Full time

    Job Title: Junior Interior DesignerLocation: Bellville, Cape TownCompany: SQ DesignSQ Design, a forward-thinking and innovative interior and graphic design firm based in the vibrant heart of Bellville, Cape Town, is excited to announce an opening for a Junior Interior Designer to join our dynamic team. We specialize in creating conceptually driven,...

  • Tracking Administrator

    2 weeks ago

    Bellville, Western Cape, South Africa CAR AUDIO WAREHOUSE Full time

    WE ARE CURRENTLY IN THE MARKET TO EMPLOY A TRACKING ADMINISTRATOR.JOB RESPONSIBILITIES BUT NOT LIMITED TO:SCHADULING TRACKING FITMENTS FOR TECHNICIANS. CALLING AND LIASING WITH CLIENTS. CHECKING STOCK. ASSISTING WITH OFFICE DUTIES. MAINTAIN RECORDS/ DATABASES/ FILING SYSTEMS.QUALIFICATION: MATRIC KNOWLEDGE OF ADMINISTRATIVE SERVICES. ABILITY TO MULTI TASK...

  • Office and Administration Manager

    2 weeks ago

    Bellville, Western Cape, South Africa JSM Business Services Full time

    Our client, an Electrical and Mechanical Engineering firm that provides safe and profitable engineering and renewable energy solutions, wants to appoint an experienced Office and Administration Manager.Duties and responsibilities: Being the face of the business in the front of house Answer phone calls and greet guests Arrange and manage travel, accommodation...

  • Junior Copywriter

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who we are?Sanlam Investments Group is one of South Africa's largest investment management companies. We have a performance history spanning over 100 years, and offer a range of investment and financial planning solutions to protect and grow the long-term wealth of our clients.We take particular pride in: Sanlam's longevity and innovation People, teamwork...

  • Agency Administrator

    2 weeks ago

    Bellville, Western Cape, South Africa A24 Group Full time

    Responsibilities: Maintain accurate records, files, and databases, ensuring all information is organized and easily accessible. Prepare and edit CVs, profiles, and correspondence with exceptional attention to detail and clear written English. Work in a fastpaced environment, managing multiple tasks and priorities with efficiency and accuracy. Demonstrate...

  • Junior Lecturer

    2 weeks ago

    Bellville, Western Cape, South Africa Cape Peninsula University of Technology Full time

    Faculty- Health & Wellness Sciences- Department- Cape Peninsula University of Technology -> Health & Wellness Sciences -> Medical Imaging & Therapeutic Sciences- Campus/ Location- Bellville Campus - Bellville, Cape Town, WC ZA (Primary)- Job Type- Contract- Occupational Function- Academic- Number of Positions- 1- Annual Salary Package (incl.Medical Aid rate...

  • Junior HR Administrator Bellville

    2 weeks ago

    Bellville, Western Cape, South Africa Job Crystal Full time

    HR Administrator vacancy in Bellville.Must have 1-2 years experience within HR (Financial Services Industry)HR qualificationReliable TransportationPay: Up to R16 000,00 per month