
Oracle Database Administrator
3 weeks ago
**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-
-
Ops Spec: Database Administrator
4 days ago
Bellville, South Africa BCXP Full timeStructure, 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...
-
Enterprise Specialist: Database Administrator
2 weeks ago
Bellville, South Africa Cape Peninsula University of Technology Full timeFaculty - 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...
-
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...
-
SQL Db Administrator
4 weeks ago
Bellville, South Africa Sanlam Full timeWho 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...
-
Pension Fund Administrator
1 day ago
Bellville, Western Cape, South Africa Speciality Full timeKey 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,...
-
Tracking Administrator
3 weeks ago
Bellville, South Africa CAR AUDIO WAREHOUSE Full timeWE 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. -...
-
Office and Administration Manager
3 weeks ago
Bellville, South Africa JSM Business Services Full timeOur 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,...
-
Sales Account Administrator
2 weeks ago
Bellville, South Africa Pepkor Speciality Full timeSPCC, 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...
-
Office and Administration Manager
2 weeks ago
Bellville, South Africa JSM Business Services Full timeOur 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,...
-
People Support Systems Administrator
4 weeks ago
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...
-
Logistic Coordinator Administrator
2 days ago
Bellville, Western Cape, South Africa Frank Consult Full timeOur 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...
-
Administrative Support Specialist Wanted
5 days ago
Bellville, Western Cape, South Africa Platinumwealth Full timeAdministrative 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...
-
Administrator (Cipc & Sars)
2 days ago
Bellville, South Africa Company Partners Full timeCompany 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 timePosition 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 timeFaculty - 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...
-
Executive Administrative Assistant Needed
5 days ago
Bellville, Western Cape, South Africa Platinumwealth Full timeJob 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 -...
-
Procurement Systems Administrator
4 weeks ago
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...
-
Benefits Administrator
3 weeks ago
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,...