South Africa Job Openings

Sanlam

Oracle Database Administrator

Bellville

FULL TIME

November 19, 2024

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 Database Administrator’s role is to design, support, monitor, maintain, and performance tune production databases while ensuring high levels of data availability. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability and recoverability of databases and their accompanying software. Perform general Oracle database administration tasks on Oracle 19C installations for Sanlam’s centrally hosted Oracle solutions for African countries, as well as support of in-country hosted implementations. Oracle is deployed on both Linux and Windows. This position includes both system - and application database support tasks. The client which will be supported is Sanlam Allianz.

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
Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures
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.
Oracle Patching routines – N-1 requirement in line with application certification.
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.
DBMS performance troubleshooting, monitoring user activity and trace application session activity.

Upskill & / or participate in Oracle DBMS component support

Data Guard (Recovery)
Advanced Security (Encryption)
Database Vault (DAM)
Multi-Tenant (PDB & CDB)
Masking & Sub Setting (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 Mi Way 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

Drives results - Contributing through others

Collaborates - Contributing through others

Being resilient - Contributing through others

Turnaround time

The shortlisting process will only start once the application due date has been reached. The time taken to complete this process will depend on how far you progress and the availability of managers.

Our commitment to transformation

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 ensuring a thriving and sustainable business in South Africa. The Group's Employment Equity plan and targets will be considered as part of the selection process.

New Job Alerts

PFFSA

Fundraising Manager

Cape Town

FULL TIME & PART TIME

December 4, 2024

View Job Description

Webmech Pty Ltd

Construction Manager

Cape Town

FULL TIME

December 4, 2024

View Job Description

Experian

Account Manager Bloemfontein

Johannesburg

FULL TIME

December 4, 2024

View Job Description

Momentum Insure Company Limited

Senior Java Developer

Centurion

FULL TIME

December 4, 2024

View Job Description

Odity Cape Town

Dutch Customer Service Brand Ambassador

Cape Town

FULL TIME

December 4, 2024

View Job Description

SPARK Schools

High School Natural Science & Technology (SP) - SPARK Rivonia High - 2025

December 4, 2024

View Job Description