Database Administrator
2 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?**
- 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.**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.
- Operational Management- Create models for new database development and/or changes to existing ones.
- Install and configure relevant network components to ensure database access as well as database consistency and integrity.
- Respond to and resolve database access and performance issues.
- Assist developers with SQL optimization.
- Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
- Monitor, optimize and allocate physical data storage for database systems.
- Plan and coordinate data migrations between systems.
- Develop, implement, and maintain change control and testing processes for modifications to databases.
- Create, or support creation of, required reports in response to business user needs.
- Perform database transaction and security audits.
- Establish appropriate end-user database access control levels and review reports.
- Develop routines for end users to facilitate best practices database use.
- Ensure maintenance plans are in place i.e. reorg of databases, index adviser, runstats, backups
- Responsible to identify and manage risks within your environment.
- Qualifications- Matric
- Degree or Diploma in Information Technology
- Knowledge and Experience- At least 5 years database administration experience
- Strong understanding of database structures, theories, principles, and practices
- Working technical experience with database design, maintain and support, including SQL code optimization
- Hands-on database tuning and troubleshooting experience
- Experience in DB2 LUW data base technology and tools (Data Server Manager)
- Experience in troubleshooting and resolving database integrity issues, locking and deadlocking issues,replication issues, log shipping issues, connectivity issues, security issues etc.
- Ability to detect and troubleshoot CPU, memory, I/O, disk space and other resource contention
- Knowledge of AIX and Linux environments
- Good understanding of scripting
- Good knowledge and implementation skills of applicable data privacy practices and laws**Knowledge and Skills**
- IT Data Analysis- Database Knowledge- Database Security- Project Coordination- Risk Management**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**
- Being resilient - Contributing through others- Collaborates - Contributing through others- Cultivates innovation - Contributing through others- Customer focus - Contributing through others- Drives results - Contributing through others**Turnaround time**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 tar
-
Ops Spec: Database Administrator
1 month 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...
-
Office and Administration Manager
1 week 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
1 week 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...
-
Administration Manager
4 weeks ago
Bellville, South Africa The Joblink Full timeContact 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,...
-
Sales Administrator and Lead Generator
4 weeks ago
Bellville, South Africa 247 Recruitment Advice (ta Evolution Recruitment) Full timeSales Administrator and Lead Generator Office based - Durbanville Monday - Friday, 08h00 - 17h00 Permanent position - offering great scope for growth! Remuneration: R8 000 basic slightly negotiable + monthly KPI bonus + commission Minimum Requirements: - Matriculation - Bilingual verbal communicator in English and Afrikaans - 2+ years’ cold...
-
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...
-
HR Administrator
4 weeks ago
Bellville South, South Africa Measured Ability South Africa Full timeOur national client in the production, warehousing and distribution industry requires your qualifications and experience as an HR Administrator for one of their operations in Bellville South, Cape Town. **Job Title**: - Human Resource Administrator **Occupational Level** - Semi-Skilled & discretionary decision-making **Department** - Human...
-
Assistant Company Secretary
1 month ago
Bellville, South Africa Silver Solutions 1579 Full timeWe are looking for a well groomed female with at least 3 years experience in administrative or front office experience. In this portfolio you will report directly to the owner and managing director of this company. Your Duties, responsibilities and qualifications will include the following: Must be Fluent in English and Afrikaans, Must reside in Northern...
-
Junior Receptionist
4 weeks ago
Bellville, South Africa Silver Solutions 1579 Full timeWe are looking to employ a well groomed lady with at least 1 years experience as a receptionist. In this portfolio you will report directly to the owner and managing director of this company. Your vibrant and cheerful well spoken personality will secure this job. Your Duties, responsibilities and qualifications will include the following: Must be Fluent in...
-
Portfolio Manager
1 month ago
Bellville, South Africa CBRE Excellerate Full time**Main purpose / objective of the position**: To manage a building / cluster of buildings by optimizing the building's income stream by establishing and maintaining mutually beneficial relationships with tenants, manage and control personnel, service contractors, repairs, revamps, tenant installations, inspections and general building administration. To...
-
Co-ordinator: Donor Prospect Research
4 weeks ago
Bellville, South Africa University of the Western Cape Full timePost Number- 8022063 (ITS 1765)- Faculty/Department- University of the Western Cape -> Rectorate -> Institutional Advancement- Type of Position- Permanent - Full Time- Length of Contract Period- Location- Main Campus - Bellville, WC ZA (Primary)- Closing Date- 10/3/2024**Role Clarification & Key Performance Areas** Institutional Advancement is dedicated to...
-
Logistics Coordinator
1 month ago
Bellville, South Africa Frank Consult Full timeOur client offers a wide range of logístical services and specializes in the local transportation of containers to all South African ports. They are looking for a highly motivated and experienced **Logistics Coordinator** to join their team in their **Northern Suburbs** office. **Responsibilities**: The Logistics Coordinator will be responsible for the...
-
Head Core Platforms, Applications
6 days ago
Bellville, South Africa Sanlam Full time**JOB OVERVIEW** - The core purpose of this role will be to ensure that the managed service we receive (from multiple vendors) delivers on the agreed SLA’s, is appropriate for our need and strategy and that we can measure and report on the implementation, monitoring, maintenance, upgrade, and administration of IT infrastructure systems. This includes but...
-
Application Support Specialist
4 weeks ago
Bellville, South Africa DataTech Recruitment Full time**Responsibilities** - Collating and documenting requirements on new portfolios/clients added. - Impact assessment of new additions - Provide development requirements to developer on system enhancements and scheduler changes - Data mapping and XML editing - Monitoring of monthly fee data import and export process - Checking the invoicing and bank payments...
-
Dealer I
1 month ago
Bellville, South Africa Sanlam Full time**What will you do?** - Under close supervision, assists with the raising, purchasing, selling and utilisation of funds which could include shares, securities, bonds, foreign exchange, money and capital market instruments, bonds and derivatives. May assist with cash management and foreign exchange exposure management. Maintains appropriate portfolio records...
-
Engineering Technician
20 hours ago
Bellville, South Africa Western Cape Government Full time**Job Purpose**: The Department of Infrastructure, Western Cape Government has opportunities for two (2) qualified individuals to render technical services and support in engineering research, design, manufacturing, operations and maintenance. **Minimum Requirements**: An appropriate 3-year National Diploma in Megatronics/ Mechanical Engineering or relevant...
-
Engineering Technician
1 week ago
Bellville, South Africa Western Cape Government Full time**Job Purpose**: The Department of Infrastructure, Western Cape Government has opportunities for two (2) qualified individuals to render technical services and support in engineering research, design, manufacturing, operations and maintenance. These posts are stationed in Bellville. **Minimum Requirements**: An appropriate 3-year National Diploma in...
-
Ccc: Mail Distribution Agent
1 month ago
Bellville, South Africa Sanlam Full timeWho are we? The Sanlam Retail Affluent business (SRA) is dedicated to empower South Africans in the middle - and upper-income segments to be financially confident, secure and prosperous. With deep client understanding and a focus on excellence in technology, client and intermediary experiences, SRA delivers financial solutions including comprehensive...
-
Ccc: Mail Distribution Agent
4 weeks ago
Bellville, South Africa Sanlam Full time**Who are we?** The Sanlam Retail Affluent business (SRA) is dedicated to empower South Africans in the middle - and upper-income segments to be financially confident, secure and prosperous. With deep client understanding and a focus on excellence in technology, client and intermediary experiences, SRA delivers financial solutions including comprehensive...
-
Ccc: Mail Distribution Agent
1 month ago
Bellville, South Africa Sanlam Full time**Who are we?** The Sanlam Retail Affluent business (SRA) is dedicated to empower South Africans in the middle - and upper-income segments to be financially confident, secure and prosperous. With deep client understanding and a focus on excellence in technology, client and intermediary experiences, SRA delivers financial solutions including comprehensive...