Learn Data Skills
Beta

Victor Ogbesanya

Data Engineer

Claritae

Technologies

My Portfolio Highlights

My New Track

Data Engineer

My New Project

Cleaning Bank Marketing Campaign Data

My New Course

Introduction to Python

My New Track

Data Engineer

Data explorer, uncovering insights in the digital wilderness.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to Python

course

Intermediate Python

course

Introduction to SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

Bluechip Technologies Limited | Mar 2023 - Present

Database Administrator / Data Platform Engineer

AND PROD) + Installed PostgreSQL database and configured it on CBN server Lagos and Abuja State. + Worked on setting up data warehouse enterprise environment for Central Bank of Nigeria which involved installation of Apache Atlas, Solr, Hadoop, Airflow, Ranger, Spark, Kafka etc. + Participated in the encryption of CBN Oracle tablespace using TDE. + Installed PostgreSQL 15 standalone, PostgreSQL Cluster (1 standby and 1 master) on CBN Server. + Migrated database from one server to another server. + Managing the database connected to the Hive application. + Ensure all the applications was running on the right port number, worked along with CBN Network Engineers to fix port number issues on the Big Data Environment server. + Linux Scripting + Linux Administration. + Implementing Data Masking, Data Redaction on Oracle database. + Creating of OS users on Redhat Linux. MTNN + Installed Apache Airflow, Anaconda and Python on MTN Nigeria server both PROD and POC. + Providing 24/7 support to the Data Engineers. + Installed Apache Kafka cluster involving 3 nodes. + Manage and Administer MySQL, MariaDB and Hive database. + Replicated Hive server database from one server to another without no downtime and loss of data. + Worked Apache Hive and MySQL query optimization. + Hadoop Ecosystem Administration. + Linux Administration. + Writing of T-SQL and complex queries against data warehouse environment. + Writing of Shell scripts on Linux environment Fidelity Pension Managers + Performed Transparent Data Encryption on MS SQL Server database. 9mobile + Installed Oracle Analytics Server (OAS) on 9mobile environment. + Applied patches to Oracle Analytics Server, Middleware. Vodafone Ghana + Upgraded Apache Nifi from version 1.12 to version 1.20 both single node and cluster. Vodafone Congo + Migration of Oracle 11g database standalone RAC to 19c Exadata GTBank Gambia + Linux Administration
Show More

Claritae | Mar 2022 - Present

Database Administrator

* Creation of database and Data warehouse, maintaining of PostgreSQL database both on windows and Linux. * Performing data analyst task of large data generated using SQL queries. * Preforming Data mining. * Backup, restoring of database backup and testing the backups. * Performing ETL operations. * Migrating database from on premises server to cloud AWS RDS. * Performing SQL Tuning of database by using analyze to update the pg_stat table and also using explain to explain query analysis. * Creating of procedure, functions, views, index and giving support to the application developer to allow seamless operation of the database. * Installing of database cluster of both on Linux and Window. * Upgraded the company databases from version 10 to version 14 due to because of procedure functions. * Created more than 3 data warehouses to be used for data analysis by the data analyst and using 3 various ways to populate the fact table (Creating of triggers, Using Foreign Data Wrapper (FDW) and using on pg_cron to schedule inserts). Installing of database cluster of both on Linux and Window. * Upgraded the company databases from version 10 to version 14 due to because of procedure functions. * Created more than 3 data warehouses to be used for data analysis by the data analyst and using 3 various ways to populate the fact table (Creating of triggers, Using Foreign Data Wrapper (FDW) and using on pg_cron to schedule inserts). *Using tools such as Pg_Admin, psql, DBeaver, repmgr, barman. python * Designed the full data model for a new application to be used. * Data Engineering task

University of Ilorin | Sep 2016 - Dec 2022

Student

N/A

REDEEM CHRISTIAN CHURCH OF GOD kwara province 5 | Jan 2019 - Apr 2022

Assistant Head Of Media Department

-To project during service or any program at church. - Administrator of all the social platforms owned by the church - Design motion graphics - Design video announcement to be projected every Sunday using After Effect and Microsoft PowerPoint. - Train upcoming members.

Berger Paints Nigeria Plc | Mar 2020 - May 2021

Intern

Maintenance department Working with qualified staff's to work on factory machines. Learning more on mechanical, electrical and metallurgical engineering aspects.

Berger Paints Nigeria Plc | Aug 2019 - Oct 2019

Internship Trainee

Maintenance department Working with qualified staff's to work on factory machines. Learning more on mechanical, electrical and metallurgical engineering aspects.

University of Ilorin | Aug 2018 - Oct 2018

SWEP Student's working experience program

First training Working with different departments: Agric and bio system engineering, Mechanical engineering, Electrical engineering and Metallurgical engineering. Training on how to use appliances and tools that we've been taught in lecture rooms.

University of Ilorin | Oct 2017 - Oct 2018

Student's Representative Council

Incharge of the welfare of student's in my level (200 level) at 2016/2017. Representative of my course mates at the departmental level.

AFTATECH | Jun 2014 - Aug 2014

Computer Training

Computer Training on: 1. How to use a computer for novice 2. Maintenance of a computer 3. Using Microsoft word 4. Using Microsoft Excel 5. Using Microsoft PowerPoint 7. Using Paint. 8. Using windows envinroments well.

My Education

Take a look at my formal education

Bachelor of Engineering - BE, Metallurgical EngineeringUniversity of Ilorin | 2021
SSCE, ScienceChrist the Redeemer's Secondary school | 2016

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free