Oracle Database Administrator

3 weeks ago


Bellville, 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?**What will make you successful in this role?**

**Strategy & Planning**
- Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers
- Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets

**Acquisitions & Deployment**
- Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

**Specific daily tasks will include, but is not limited to**
- General Oracle multi-tenant and schema administration tasks, management and maintenance.
- Application database request handling.
- Starting up and shutting down databases routines as part of the OS patching routines.
- Database logical and physical storage structure changes and maintenance.
- Oracle user access control and review.
- Create, deploy and review DDL and DML to manage user data and schema objects.
- Database backup and recovery process implementation and monitoring.
- Database health monitoring and reporting issues to senior DBA, as well as actively take part in preventive or corrective actions.
- Implement and review DR capability and participate in twice annual Sanlam DR exercises.

**Upskill & / or participate in Oracle DBMS component support**
- Data Guard (Recovery)
- Advanced Security (Encryption)
- Database Vault (DAM)
- Multi-Tenant (PDB & CDB)
- Masking & SubSetting (Data Obfuscation)
- Qualifications and Experience**Qualifications**:
- Matric
- Degree or Diploma in the field of computer science and/or 2 years equivalent work experience

**Knowledge & Experience**:
- DBMS Backups
- Perform database backups (Hot/Cold Backups) using RMAN.
- Perform schema-based backups using export and import utilities.
- TDE - Wallet encryption for file encryption
- Database Security
- Implement and maintain Oracle database user roles and privileges (ie. c##, etc.) for adherence to Sanlam data access
- and data security policies
- Disaster Recovery
- Understand disaster recovery principles and take part in DR exercises
- Linux and MS OS Proficiency
- Working knowledge of the underlying Linux - and Microsoft OS to perform basic Oracle DBMS tasks.
- Sound knowledge of OS level DBMS utilities. (IMPDB, EXPDB, RMAN etc)
- PL/SQL & SQL - DDL and DML
- DDL creation for database object manipulation using basic SQL, PL/SQL scripts SQL procedures. (All database schema objects - tables, indexes, views, database link, PL/SQL procedures and triggers)
- Database maintenance job creation, scheduling and monitoring.
- Management Tool Knowledge
- Sound working knowledge of Toad / SQLDeveloper for daily task management
- Good working knowledge of OEM Cloud Control will be advantageous
- Cloud knowledge and skills are advantageous
- Oracle specific
- Working knowledge of Oracle DBMS, Sound working knowledge of the operating system Oracle server resides on and usage of underlying infrastructure
- Knowledge of general database concepts
- Understanding up to Oracle DMBS v19C
- Working knowledge and understanding of Oracle DMBS v19C
- Working knowledge and sound understanding of all available products, services and resources in the Oracle DMBS v19C Server suite of products
- Knowledge to advise and execute on integration to the Oracle environment including ODBC, JDBC, ODBO and other Oracle supported connectors
- Knowledge of the Oracle manager to monitor database performance and troubleshooting

**Knowledge and Skills**
- IT Data Analysis- Database Knowledge and Monitoring- Data Security- Risk Management- Project Oversight**Personal Attributes**
- Organisational savvy - Contributing through others- Manages complexity - Contributing through others- Plans and aligns - Contributing through others- Optimises work processes - Contributing through others**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 five business clusters - Sanlam Fintech, Sanlam Life and Savings, Sanlam Investment Group, Sanlam Allianz, Santam, as well as MiWay and the Group Office - the group provides many opportunities for growth and development.**Core Competencies**
- Cultivates innovation - Contributing through others- Customer focus - Contributing through others-



  • Bellville, South Africa BCXP Full time

    Structure, Grade & Reporting Job grade/level S6 Business Unit Digital Platform Solutions Business Unit Digital EXA Position reports to Manager: Delivery Span of Control 0 Level of Engagement Client, Employees and Line Manager Core Description To provide a stable and secure production database environment which performs in alignment with predefined standards...


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

    Faculty - Department - Cape Peninsula University of Technology -> Computer & Telecom Services - Campus/ Location - Bellville Campus - Bellville, Cape Town, WC ZA (Primary) - Job Type - Permanent - Occupational Function - Support / Admin - Number of Positions - 1 - Annual Salary Package (incl. Medical Aid rate based on principal member only) - To be...


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

  • SQL Db Administrator

    4 weeks ago


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


  • Bellville, Western Cape, South Africa Speciality Full time

    Key ResponsibilitiesYour key responsibilities will include providing administrative support to the Benefits team, assisting with project coordination and implementation, maintaining accurate and up-to-date records and databases, and performing other administrative tasks as required. You will also assist with organizing and framing long service awards,...


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


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


  • Bellville, South Africa Pepkor Speciality Full time

    SPCC, a division of Pepkor Trading (Pty) Ltd, is looking for a superstar Sales Account Administrator to join our dynamic team! You'll be the backbone of our sales force, providing critical administrative and organizational support to our Sales Account Manager. **Key Responsibilities**: - Track orders and ensure efficient processing - Coordinate with...


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


  • Bellville, South Africa HR Talent Partner Full time

    **Job Overview**: **Date Posted**: Posted 2 days ago- **Location**: Bellville, Western Cape- **Job Title**: People Support Systems Administrator- **Education Level**: Bachelors Degree- **Job Level**: Intermediate- **Minimum Experience**: 3 - 5 Years**People Support Systems Administrator - Bellville, Cape Town.**: A renowned Cosmetics Company is looking for a...


  • Bellville, Western Cape, South Africa Frank Consult Full time

    Our client is seeking a highly organised and communicative Logistic Coordinator Administrator to join their team. This role will focus on managing the administration of the Logistics Container Department, ensuring efficient operations and building strong relationships with transporters and clients.Main Duties and Responsibilities:Add new transporters to the...


  • Bellville, Western Cape, South Africa Platinumwealth Full time

    Administrative Assistant WantedOur business is expanding into a new field and requires an organized and motivated professional to join our team.Key responsibilities will include:Providing administrative support to the Recruitment ManagerAssisting the Training ManagerAnswering phone calls and responding to general client inquiries, including sales-related...


  • Bellville, South Africa Company Partners Full time

    Company Description Company Partners is an Online 1-stop-machine for start-up businesses who over the past 5 years, have served more than 15000 clients, of which 20% purchase additional services after 1 year, and a further 10% invested in monthly subscription packages. Company Partners holds South Africa’s largest variety of compliance services with over...

  • SAP Administrator

    4 weeks ago


    Bellville, South Africa Legates Group (pty) ltd Full time

    **Key Responsibilities**: - Collaborate with warehouse operations and IT teams to identify, analyze, and resolve SAP-related issues promptly. - Implement system enhancements and upgrades, ensuring mínimal disruption to operations and compliance with best practices. - Monitor system performance and conduct regular system audits to ensure data integrity and...

  • Iwms Specialist

    3 weeks ago


    Bellville, South Africa Excellerate Full time

    Position title : IWMS Specialist Position reports to : Head of BI & Analytics Business Unit : Operations **Main purpose / objective of the position**: As an IWMS Specialist, you will be required to configure, customize, and integrate methods of Integrated Workplace Management Solutions (IWMS), including Planon (a fully web-based solution that allows...


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

    Faculty - Department - Cape Peninsula University of Technology -> CPUT Libraries - Campus/ Location - Bellville Campus - Bellville, Cape Town, WC ZA (Primary) District Six Campus - Cape Town, WC ZA - Job Type - Permanent - Occupational Function - Support / Admin - Number of Positions - 1 - Annual Salary Package (incl. Medical Aid rate based on principal...


  • Bellville, Western Cape, South Africa Platinumwealth Full time

    Job Opportunity - Executive AssistantWe are seeking a highly skilled and experienced executive assistant to join our team.Key responsibilities will include:Providing administrative support to senior managementAssisting with recruitment and training initiativesResponding to phone calls and emails from clientsUpdating client information in our databasePrevious...

  • Office Administrator

    2 weeks ago


    Bellville, South Africa Pepkor Speciality Full time

    **Key Responsibilities**: - Provide administrative support to the team - Assist with project coordination and implementation - Maintain accurate and up-to-date records and databases - Compiling,analysing and reporting of data - Prepare and edit documents, reports, and presentations - Coordinate travel arrangements and meetings - Front desk reception -...


  • Bellville, South Africa Feedem Recruitment Full time

    **Job Advert Summary**: We are currently recruiting for an experienced, meticulous, and diligent Procurement Systems Administrator to join our dynamic Procurement department, situated at our regional offices in Bellville. As the Procurement Systems Administrator you will play a crucial role in ensuring the efficiency and accuracy of our procurement...


  • Bellville, South Africa Pepkor Speciality Full time

    **Key Responsibilities**: - Provide administrative support to the Benefits team. - Assist with project coordination and implementation i.e. Sample Sale, Wellness day initiatives. - Maintain accurate and up-to-date records and databases. - Provide administrative support pertaining to the death claims. - Assist with Online withdrawal submission management,...