Oracle Database Administrator

2 months 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 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 Progressive IT Resourcing Full time

    **What will you do?** - The DBA will design, install, configure, administer, monitor, and troubleshoot all components of the MSSQL platform including the core database as well as the additional components and functionality. - The DBA will also be responsible for security administration as well as administration tasks related to SDLC. - The DBA will also be...


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

  • Database Administrator

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

  • SAP Administrator

    3 months ago


    Bellville, South Africa Legates Group Full time

    A SAP Administrator plays a critical role in managing and maintaining SAP systems within an organization. The primary responsibilities, skills, and qualifications for this position typically include the following: Job Title: SAP Administrator Job Overview: Key Responsibilities: - **System Installation and Configuration**: - Manage system landscapes,...

  • Database Administrator

    7 months ago


    Bellville, South Africa Hr Legend Full time

    **DATABASE ADMINISTRATOR - SQL (Bellville, Cape Town)** Market related package with benefits Bellville, Cape Town **REQUIREMENTS**: Minimum: - Grade 12 - Relevant tertiary qualification i.e. Bachelors Degree in a computer discipline or relevant SQL certification - 5 years of experience as a SQL Server DBA or similar role - 5 years of experience with...


  • Bellville, South Africa Parvana Strategic Sourcing Full time

    **Client Details**: Our client is a well-established and highly regarded South African software development company that develops, supports and consults software solutions for the academic sector. With offices in Jhb and Cape Town, they are progressive with regard to their technology stack. Their solutions and services span the full range of the software...


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

  • Administration Manager

    7 months ago


    Bellville, South Africa The Joblink Full time

    Contact person for this position: Ronel Bakker Job overview My client in the wholesale bakery industry, is looking for an experienced Administration Manager to join their team in Bellville. Areas of Responsibility (Your duties will include but are not limited to) - General administration duties as required, filing, invoicing, calls to clients,...


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

  • Iwms Specialist

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

  • SAP Administrator

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


  • Bellville, South Africa Westside Trading Full time

    **JOB SUMMARY** All Westside Trading’s Work Instructions (WI), policies and procedures relevant to this job function must be adhered to, always. Your Job description is not limited to the responsibilities below and you will be required to perform other reasonable tasks and assume other reasonable responsibilities in line with your position. **MAIN JOB...


  • 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 Santam Full time

    CAREER OPPORTUNITY An exciting career opportunity exists for someone to perform a new and critical role with in B.IT.S - Santam Business Information and Technology Services, reporting to the Configuration Manager: IT Finance Solutions at Santam Bellville (Cape Town) Head Offices. Guided by the CNC Manager and a prioritised backlog, this role will be...