Intermediate Data Engineer - Oracle DBA
Apply locationsPinelands posted on Posted 2 Days Ago job requisition id JR-61524
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 an Intermediate Data 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.Proficient in at least one of Python, Java, C/C++ or similar (Advantageous).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.Some experience in applying SAFe/Scrum/Kanban methodologies.Good problem-solving skills.The ability to exercise judgment in solving technical, operational, and organizational challenges.Advanced administration experience with Oracle Database.Knowledge of Oracle RDS, Amazon Aurora, DynamoDB, Redshift, Athena, as well as AWS Database Migration Service (advantageous).Experience in Oracle WebLogic Server Administration.Experience with System Administration with Linux (RedHat, Oracle Linux) and/or Microsoft Windows Server.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.Experience troubleshooting the full application stacks from the OS up through custom applications.Knowledge of Test Data Management (advantageous).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.
ResponsibilitiesData ArchitectureOversee data collection mechanisms and how they fit into data architecture, partnering with internal and external stakeholders to ensure quality and accuracy.
Data ManagementManage basic aspects of the data management system with guidance from senior colleagues.
Business Requirements IdentificationCollect business requirements using a variety of methods to express the requirements in terms of target user roles and goals.
Databases InstallationInstall and test complex databases and associated products to ensure they are suitable for use and meet customer requirements.
Infrastructure and Network Development and MaintenanceDesign and select medium-complexity storage, data center, network, and client/server environments.
Information SecurityImplement required security measures, such as firewalls or message encryption.
DocumentationCreate and maintain technical and/or user documentation to a high standard.
Technical Developments RecommendationDiscuss and recommend technical developments to improve the quality of the website/portal/applications software.
Analysis of "As Is" and "To Be"Support and contribute to the documentation of "as is" and "to be" processes.
Operational ComplianceIdentify instances of noncompliance with the organization's policies and procedures.
Data Software DevelopmentDevelop existing data applications and contribute to the development of new applications.
Data Software MaintenanceMonitor, identify, and correct software defects to maintain fully functioning applications software.
Data Software RoadmapContribute to and maintain road map to facilitate data software development.
Design and ConceptualizationProduce 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. The Old Mutual Story! About UsOld Mutual is a premium African financial services organisation that offers a broad spectrum of financial solutions to retail and corporate customers across key market segments in 14 countries.
#J-18808-Ljbffr