Intermediate Data Engineer - Oracle DBA

Let's Write Africa's Story Together!

Old Mutual is a firm believer in the African opportunity and our diverse talent reflects this.

Job Description

As a Intermediate Date Engineer, part of the RPP platform team, this role supports, maintains and develops databases and their applications to support the systems, Testing, QA and Production environments. The incumbent is individually accountable for achieving results through own efforts. Responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of complex database environments operating in AWS

MINIMUM QUALIFICATIONS/EXPERIENCE (REQUIRED FOR THE JOB)

• Matric, with a degree in Computer Science, Business Informatics, Mathematics, Statistics, Physics or Engineering.

• 3+ years of data engineering experience  

• Should be at least at a proficient level in at least one of Python, Java, C/C++ or similar (Advantageous)

• Should be Proficient in bash/ksh, perl, SQL

• Experience with designing and implementing Cloud (AWS) solutions including use of APIs available.

• Knowledge of Engineering and Operational Excellence using standard methodologies. Best practices in software engineering, data management, data storage, data computing and distributed systems to solve business problems with data.

• Some experience in applying SAFe/Scrum/Kanban methodologies.

• Good problem-solving skills.

• The ability to exercise judgment in solving technical, operational, and organizational challenges, to identify issues proactively, to present solutions and options leading to resolution.

• Advanced administration experience with Oracle Database

• Knowledge of Oracle RDS, Amazon Aurora, DynamoDB, Redshift, Athena, as well as AWS Database Migration Service and more advantages.

• Experience in Oracle WebLogic Server Administration

• Experience with System Administration with Linux (RedHat, Oracle Linux) and/or Microsoft Windows Server and associated technologies (Active Directory, Exchange) Advantages

• Experience or firm knowledge of Automation Required.(SQL, Shell, Java Python, AWS CloudFormation)

• Database troubleshooting and performance tuning

• Experienced setting up monitoring / alarming for production DB environments

• Database migration and ETL experience

• Experienced with Linux system monitoring and analysis

• Good understanding of distributed computing environments

• Experience with query optimization

• Good understanding of Virtualization technologies

• Experience with AWS - any or all of EC2, S3, EBS, ELB, NLB, ALB, RDS, Dynamo DB, EMR

• Firm understanding of security concepts / best practices

• Experience with Load Balancing technologies such as KEMP, and or network monitoring /troubleshooting tools

• Experience Troubleshooting the full application stacks from the OS up through custom applications

• Knowledge of Test Data Management advantages

• Create and maintain DevOps Pipelines in Azure DevOps (advantageous)

Designs, builds, and maintains the infrastructure that supports data storage, processing, and retrieval. Works with large data sets and develops data pipelines that move data from source systems to data warehouses and other data storage and processing systems. OML roles mapped to this profile are: Intermediate Data Engineer, ETL Developer, RoA : Developer ETL & Integrations, RoA : Developer Staging and Mapping (incl UI) Storage Specialist and Oracle and Cloud Database Engineer.

Responsibilities

Data Architecture

Oversee data collection mechanisms and how they fit into data architecture, partnering with internal and external stakeholders to ensure quality and accuracy.

Data Management

Manage basic aspects of the data management system with guidance from senior colleagues. This includes being responsible for developing or operating basic elements of the data management systems to deliver prescribed outcomes.

Business Requirements Identification

Collect business requirements using a variety of methods, such as interviews, document analysis, workshops, and workflow analysis, to express the requirements in terms of target user roles and goals.

Databases Installation

Install and test complex databases and associated products to ensure they are suitable for use and meet customer requirements.

Infrastructure and Network Development and Maintenance

Design and select medium-complexity storage, data center, network, and client/server environments to design solutions in line with industry best practice and provide a third-line point of escalation for appropriate global infrastructure solutions.

Information Security

Implement required security measures, such as firewalls or message encryption, and provide input on their design, monitoring performance to notify security experts of any problems.

Documentation

Create and maintain technical and/or user documentation to a high standard.

Technical Developments Recommendation

Discuss and recommend technical developments to improve the quality of the website/portal/applications software and supporting infrastructure to better meet users’ needs.

Analysis of "As Is" and "To Be"

Support and contribute to the documentation of "as is" and "to be" processes and describe the changes required to migrate to the "to be" capability to record accurately the change required.

Operational Compliance

Identify, within the team, instances of noncompliance with the organization's policies and procedures and/or relevant regulatory codes and codes of conduct, reporting these instances and escalating issues as appropriate.

Data Software Development

Develop existing data applications and contribute to development of new applications by analyzing and identifying areas for modification and improvement. Develop new routine applications to meet customer requirements.

Data Software Maintenance

Monitor, identify, and correct more complex software defects to maintain fully functioning applications software.

Data Software Roadmap

Contribute to and maintain road map to facilitate data software development and ensure the development work is prioritized in line with business requirements.

Design and Conceptualization

Produce multiple concepts and prototypes to design digital products/services.

Skills

Action Planning, Business Requirements Analysis, Computer Literacy, Database Administration, Database Reporting, Data Compilation, Data Controls, Data Management, Data Modeling, Executing Plans, Gaps Analysis, Information Technology (IT) Support, IT Architecture, IT Implementation, IT Network Security, Market Analysis, Test Case Management, User Requirements Documentation

Competencies

Action Oriented

Business Insight

Communicates Effectively

Cultivates Innovation

Drives Results

Ensures Accountability

Manages Complexity

Optimizes Work Processes

Education

NQF Level 7 - Degree, Advance Diploma or Postgraduate Certificate or equivalent

Closing Date

10 January 2025 , 23:59

The appointment will be made from the designated group in line with the Employment Equity Plan of Old Mutual South Africa and the specific business unit in question.

Old Mutual Limited is pro-vaccination and encourages its workforce to be fully vaccinated against Covid-19.

All prospective employees are required to disclose their vaccination status as part of the recruitment process.

Please refer to the Old Mutual’s Covid-19 vaccination policy for further detail. Kindly note that Old Mutual reserves the right to reinstate the requirement to vaccinate at any point if it is of the view that it is imperative to do so.

The Old Mutual Story!