Davies C.

DATABASE ADMINISTRATOR

Freelancer
9 ans
Lagos, NIGERIA

Mon expérience

Voir plus

APPZONE GROUP LIMITEDJuly 2021 - Présent

* SQL Server Database Migration.

* Data Replication Across several Data Centres Azure to AWS.

* T-SQL Scripting for Lending and Recovery.

* SQL Query Tuning.

* Database Performance Monitoring and Improvement.

* Database Backup and Restore.

* Storage Monitoring Scripts Development.
Build Performance Data for Grafana Dashboards

* Build Data Pipelines.
Voir plus

FIRST CITY MONUMENT BANKDecember 2020 - July 2021

* Finacle Core Banking Database Administration on Oracle RAC 12.1.

* Responsible for the Enterprise Database Patching, Database Backup and Cloning.

* Responsible for Data Migration between Databases using PLSQL and SSIS Packages


* SQL Server Database 2012, 2014, 2016, 2017 Administration and Database Security.

* Database replication and DR Build for Data Guard, Always On and Logfile shipping.

* ETL Scripts development with PLSQL, Python.

* Data Pipeline development with Python.
Development of Apache AIR Flow Dags with Python.

* Data transformation with Python.

* Apply Database Patches on SQL Server, Oracle RAC and Single Instance.

* Configure Database environment for Applications.

* Performance tuning of all Database environments to ensure efficient resource utilization.

* Perform backups and recovery with RMAN.
Voir plus

PLEXADA SYSTEM INTEGRATORS (PLEXADA-SI)August 2013 - November 2020

* Orchestrate advancement and completion of Oracle database administration assignments for diverse industry clients.

* Responsible for the Enterprise Resource Planning Application Patching (ERP R12).

* Responsible for the Enterprise Resource Planning Application Cloning (ERP R12). Customer Report Build with Oracle Report Builder 11g for Weststar and Associates (Project)

* Database Design for Weststar and Associates (Project).

* Development of ER Diagram to show database structure.

* Database Modeling.

* Meet with clients to understand their data needs and proffer solutions.

* Database Performance Tuning, database restore, implement recovery procedures, Database backups.

* Handle support calls from clients, co-ordinate Dba team.

* Implementation of Oracle Siebel and Business Intelligence applications in the Ecobank group Project OYSTER.

* Microsoft SQL Server 2012 Administration.

* Build real-time transaction monitoring with AngularJS, Ajax, and PHP 5

* Oracle RAC administration for Access Bank Nigeria.

* PLSQL Scripting for ETL process at Ecobank Nigeria project

* Develop SQL Queries for key management reports on Core banking Databases - Finacle and Flexcube. Configuring RMAN automated Backups for all Databases.

* Implement Enterprise Manager 12c, 13c for Proactive Database Monitoring.

* Database vulnerability monitoring and Resolution.

* Rebuild of Primary Database in a Data guard using SNAPSHOT Database.

* Point in Time Recovery of Database and Datafiles

* Analysis the customer's data with Oracle Report builder 10g

* Recognized for creating a PLSQL module to resolve the data discrepancy between Access bank Flexcube Database and Siebel CRM database.

Mes compétences

XML, WordPress, VMWare, VirtualBox, Team management, SQL Server Integration Services, Oracle PL/SQL, Oracle Enterprise Manager, Oracle DBA, Oracle CRM, Oracle Applications, Oracle 10g, Oracle, MySQL, Microsoft SQL Server, Linux Red Hat, Linux, Jscript, jQuery, JavaScript, Java, HTML5, GitHub, ETL, Database Design, Database Administration, Data Migration, CentOS, C++, AWS Cloud, Apache Web Server, AngularJS, Amazon Web Services, AJAX