Certificate in Information Technology

Bachelor of Engineering

Software Engineer

Application development,first and second-line support of production operations and logistics system:

• Installing new applications and customizing existing applications to make them fit for purpose.
• Carry out maintenance of onsite backup and restoration procedures.
• Apply software patches, updates and go-live deployment.
• Maintain application security of the systems.
• Ensuring new systems in project/development phase are supported on go live.
• Respond to user queries (1st line) and ensure responses by the team are timely and accurate.
• Administer, maintain and provide user training.
• Liaise with relevant ICT members of the Infrastructure and Backend teams.
• Conduct UAT, parallel testing and regression testing.

Senior Database/Data Engineer

Job Title: Senior Data Engineer

JobDescription: Build and manage ETL pipelines, databases,data marts, and data warehousing solutions. Design, interpret, and analyze wells,subsurface, seismic data, hydrocarbon reports and dashboards. Generate businessintelligence insights and analytics needed to guide critical oil production andexploration decisions.

Responsible for the followingdatabase administration activities:

• Monitor pipelines, troubleshoot and investigate data problems and conduct root cause analysis (RCA).
• Architect and developed a data warehouse from scratch using on-premise ETL tools like Microsoft SSIS, Altyerx, Informatica and Cloud like Azure tools and open source Apache tools like PySpark & Data Bricks.
• Resolve report issues by cleaning and optimizing data quality.
• Conduct detailed industry analyses and research.
• Develop custom scripts, schedules, and business intelligence reports and dashboards for decision making.
• Assist well data scientists with in-depth analysis which resulted in a 20% performance and costs optimization
• Translate data requirements for production, well, and subsurface engineering teams.

• Responsible for installation, patching and upgrade of ETL and data-warehouse systems.
• Work with IT Project Managers, Application Specialists & Well Scientist/Engineers to successfully delivery projects

Job Title: Senior Database Engineer

Job Description: Daily maintenance of over five hundred (Oracle,SQL Server, PostgreSQL, MySQL and MongoDB) on-premise and cloud databases (MicrosoftAzure, Oracle Cloud and Amazon Web Service) in production and test landscapes.

Responsiblefor the following database administration activities:

• Monitor daily full and incremental database backup.
• Investigate database problems and conduct root cause analysis (RCA).

• Responsible for installation, patching and upgrade of database on Linux and Wintel servers.
• Allocate database storage and plan for future storage requirements for the database system.
• Work with IT project managers, application & database programmers to successfully delivery projects

• Provide technical resolution to database related problems.
• Manage database security, access permissions and privileges.
• Develop, manage and test back-up and recovery plans.
• Build and support scalable high availability and always-on database feature
• Monitor database performance, implement changes and apply new patches and versions when required
• Periodic performance tuning and monitoring of database to resolve deadlocks, waits and slow response.
• Create new database instances and user accounts with appropriate roles and privileges.
• Responsible for managing corporate information warehouse.
• Liaise with Hosting/Server and storage Engineers to resolve database issues
• Capacity planning and space management of database size and table space on shared mount volumes
• Migrate applications from test and staging to production database environment.
• Develop scripts to simplify and automate administrative tasks.
• Performing database upgrades to latest releases and patches.
• Periodic test database restore/refresh from production systems.
• Provide evidence for database control, SOX internal and external audits.
• Ensure 100% compliance with database control and audit requirement.
• Enforce and document database policies, procedures and standards
• On-board new database to production and non-production (tests) landscape.
• Maintain database availability in line with agreed organizational level agreement (OLA).
• Design and update database inventories and technical documents.
• Prepare request for (RFC) for change ticket and service management.

Senior Database/Data Engineer

Responsible for DataEngineering and Analytics activities which include but not limited to thefollowing:

Database Engineer:

• Assist with data/database migration for new or existing applications
• Investigate database problems and conduct root cause analysis (RCA).
• Monitor database backup, replication and perform routine database restores
• Manage database security, user accounts, roles and privileges permissions.
• Create new databases and maintain existing ones
• Periodic performance tuning and monitoring of database to resolve deadlocks, waits and slow response.
• Continuously monitor databases systems to ensure high availability

Data Engineer:

• Builds data pipelines systems ETL/ELT systems using Python (PySpark), DBT (data build tools) and SyparkSQL
• Conduct detailed industry analysis/research and develop custom scripts, schedules, business intelligence reports/dashboards for stakeholders and management.
• Develop custom script and schedule for Google Analytics reports migration to the central data warehouse using Apache Airflow
• Automate tasks include ingestion, acquisition, modeling, and data transformations, orchestration, consumption, access patterns, and code deployment
• Perform basic data/business analyst functions such as metrics requirements gathering, SQL based analysis, technical designs, testing and documentation
• Will work directly with agile team and cross functional technical teams in a collaborative manner on test (development, staging, and acceptance) and production infrastructure.
• Experience identifying and solving issues concerning data management to improve data quality, and clean, prepare and optimize data for ingestion and consumption
• Expertise in building Business Intelligence reports/dashboards, interpret trends and patterns using PowerBI & Metabase for key business decisions
• Performs other job-related duties as assigned or apparent.

Data Engineering on Microsoft Azure (DP-203)