| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
Candidate's Name
E-mail: EMAIL AVAILABLEMobile Phone: PHONE NUMBER AVAILABLEtps://LINKEDIN LINK AVAILABLELinkedIn: https://LINKEDIN LINK AVAILABLEStatus: Green Card Holder | Permanent ResidentSummary: Over 13 years of experience, 11+ experience in Oracle Core DBA, MongoDB, PostgreSQL , MS SQL SERVER, and MySQL Database Administrator with Production, Testing and Development database. Supporting technologies like Data Guard, Backups, RMAN, Data Pump, Patching, Upgradation, RAC, Disaster recovery, and cross-platform or heterogeneous migration Expert proficiency in installation and monitoring of Oracle 9i, 10g, 11g, 12c and 19c database on IBM AIX , Linux - Redhat, OEL and Windows platforms as core 24/7 DBA. Experience on RAC Installations, Data Guard Setups, fixing bugs, applying Patches on AIX RAC (GI , PSU, database, etc) and OEL based systems Proficient administration of Oracle ASM Databases disk operation adding, dropping, rebalancing and swapping out in real-time attaining zero-downtime. Experience in critical migration projects across different RMAN endian formats servers and across data center locations Expertise in upgrading databases from 10g to 11g and 12c and 19c along with regular Patching.
Experience in Oracle EBS including patching, cloning and performance tuning on rel 12.2 Proactive and reactive performance tuning (using addm, awr, ash etc) with strong emphasis DB health checks. Experience in Installation, configuration of Postgres 9.6/10/11 databases. Oracle Goldengate and Exadata installation and administration Managing the Postgres SQL.conf and pg_hba.conf configuration. Performing backups using SQL dump utilites (pg_dump) and pg_basebackup utilities. Experience on Restore/Recover of cluster databases. Support and administration of OCI based instances with resource and cost optimization objectives Strong experience in Oracle Core Database administration and monitoring including exposure to performance of Exadata and Goldengate migration implementation designs Experience with migration of Oracle Databases from On-premise to Oracle Exadata Cloud at Customer Experience with Oracle Enterprise Manager (OEM) tool to monitor heterogenous systems. Advanced scripting and automation of O & M routine tasks
Experience with Patch/Upgrade and release management (database, storage node, server, network, Oracle Exadata) Develop and maintain system documentation related to Oracle Exadata and software configuration
Apply process and architectural improvements to continually improve the availability, capacity, and performance of database systems
Experience in setting up and managing physical standby Data Guard Participated in many Oracle DB projects till date in the United States ,resolving many complex issues via head-hunt consulting Providing 24/7 On-call remote Oracle, MS-SQL, MongoDB and PostgreSQL DBA support for Global Business clients.Certifications: Certified Oracle Professional 10g Certified Oracle Expert (RAC 10g) Certified Oracle Database Services 2023
Certified Oracle Cloud Data Management Foundation Associate Certified Oracle OCI Multi-Cloud Associate 2023 Certified Oracle Cloud Infrastructure Foundation Associate Oracle Expert Security Training with Pete Finnigan - Dubai Certified NVIDIA Fundamentals of AI & Deep Learning Certified ITIL VR 3 Foundations Certified IBM Zero Trust Badge Certified IBM Cybersecurity Badge Certified Project Management Professional, PMP, PMI #3026035Education: M.Sc. Computer Science (FT), Texas Southern University, Houston Texas Aug 2024 M.Sc. Information Systems Mgmt., (PT) University of Roehampton, London United Kingdom Dec 2020 B.Sc. Economics (PT) University of Ibadan, Ibadan - Jun 2012 B.Sc. Computer Science (FT) Yaba College of Technology, Lagos, Nigeria Mar 2005Campus Employment:
Graduate Research Fellow Oct 2022 Summer 2024Texas Southern University / NSF Scholarship Program/Google CSRMP Fellow Conducted research using Matrix Analytic Method and SMDP Semi Markov Decision Process optimization models on VPN/ZTN.
Participated in many Data Analysis Project Subscriber Dump, VPNLogs , etc Investigated and presented research work on Toxicity Reduction on LLM at Google CSRMP 2023B cohort.
Data Mining projects with R using comparative methodologies SVM, DecisionTree, RandomForest, etc Advance python-based project for performance comparison of Oracle Connection Pool using native and python libraries cx_oracle , SQLAlchemy and pyodbc Participated in many machine learning, data analysis projects using R and Python and student tutoring.Professional Experience:
Database & Tech Consultant May 2023 Till dateRYJ Consulting (MO, United States of America) Database technical support to clients services - Oracle, MS SQL, Postgre and MongoDB. Cloud adoption support review of client propositions and scalability assessment Migration of legacy system Oracle DB upgrade and cloud migration Database design and performance tuning on both DB and Server Level Performance metrics consolidation and project documentation prior cut-over Data Analysis project engagement and scripting of business reports Training and client support on ad-hoc Change window or on-call
Oracle Database Administrator / IT Application Analyst Jun 2016 Feb 2022JKK Oneware Ltd (Tech Mahindra/ NatCom Telecom MSA, Lagos MSA) Provided advanced technical support on Oracle Databases, MSSQL DB, Application Support, Backup and Restore, Middleware, scripting to be able to drive performance and 99.999% SLA target. Supported/managed 4-node Oracle 11g RAC on Oracle Clusterware platforms and IBM AIX with Maximum Availability Architecture (MAA); and writing shell scripting for various database maintenance and alerting activities. Vulnerability management DB and AIX , Linux - Redhat, OEL servers hardening, PSU patching, backup and restore schedule (RMAN) in line with RTO and RPO business continuity targets. Complex report building using SQL/PL-SQL and other reporting tools Crystal Report Responsible for administration and setup of all Oracle cloud related resources Database, System, storage, firewall, backup s administration and management. Spearheaded the implementation of OCI security best practices, including Identity and Access Management (IAM) configurations, network security. Executed security assessments and audits, ensuring compliance of systems hardening with industry standards and regulatory requirements. Utilized Oracle Cloud Guard to monitor and respond to security incidents, providing real-time visibility into potential threats and vulnerabilities. Upgraded Oracle 11.2.0.3 database to Oracle 11.2.0.4/12C/19C database.
Oracle performance tuning analysis using Stats pack/AWR/ADDM/ASH reports Support of Casandra and PostGre databases application fine-tuning for optimized customer experience First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching. Provided and implemented performance-tuning recommendations of all components in Exadata database machine. Advised, provided guidance, and developed Disaster Recovery strategies for the Exadata Database machine. Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc. Data guard Setups, fixing bugs, applying Patches, Managing ASM Databases, and Performance issues on RAC Databases. Deep dived and resolved many complex performance tuning issues using AWR, addmrpt, and ash reports whenever there are performance issues or hanging experience. Collaborated and coordinated with other teams like testing / Developers for fixing up issues Provided 24X7 on call support to maintain uptime SLA. Managed all L2/L3 on-site support team on Infrastructure Operations Support Service (BSS/OSS) Managed Service Agreement MSA agreement bothering on following BSS Infrastructures, databases and applications Oracle Billing and Revenue Management (BRM), Oracle RDBMS Databases, Elastic Charging Engine (ECE), Oracle ERP suites, Oracle Application Integration Architecture (AIA), Oracle Policy Charging Rules Function (PCRF), Oracle Siebel CRM, etc.Oracle Project Technical Lead (Contract) Apr 2016 -Jun 2016Ernst & Young, Lagos Conducted high profile assessment of critical payment security solutions for Central Bank of Nigeria bothering on NetApp Storage, AIX/OEL Servers, Oracle RAC, Oracle Active Data Guard and Enterprise Backup Investigated end-to-end independent review of robustness and reliability of application as requested by Bank's Committee of Governors Detailed RCA presentedAdv. IT Specialist/Lead Database AdministratorIBM, Victoria Island, Lagos Feb 2013 Mar 2016 Led team of 6 DBAs and managing West Hub account of Bharti Airtel IBM account with maximum service delivery and tight SLA. Successfully implemented MAA Maximum Availability Architecture and managing Physical Standby Database using Oracle DATAGAURD and RAC feature for Disaster Recovery on IBM AIX servers; escalated issues via IBM Oracle Competency Center for bug fixing. Created and implemented database designs and data model. Installed Oracle RAC RDBMS, Oracle Data Guard for various releases and platforms IBM AIX; HP-AUX, Sun Solaris, Linux, with IBM AIX platform as flagship OS. Collaborated and served as on-site contact resource on Project Blue initiative where legacy servers and services (Oracle DB and middleware) are migrated to IBM AIX servers. This involved rigorous migration planning based on DB and application peculiarity endian format, application design and service type for many customers Communicating with the Client Technical/Service Leads and satisfying the Client needs. Resolving On Call issues including Monitoring, Ticket resolution and Work/ Change requests. Extensive hands-on experience on recovery of data block corrupted databases using RMAN. Performing Refresh activities from Production to Staging/development using RMAN and Data pump.
Scheduling and managing, and review of crontabs jobs for proactive prevention of service disruption Identifying and improving poorly performing SQL Statements, adjusting the most important optimizer parameters. Installed and supported all Airtel Africa Databases/middleware in several countries running on different platforms and RDBMS like Oracle, MS SQL Server, MySQL, Postgres and DB2. Developed a template based on Lean Six Sigma DMAIC for IT infrastructure and operational efficiency. Implemented process improvement plans like 5-Whys, Pareto Analysis, Ishikawa/Fishbone, FMEA Failure Mode Effect, etc.IT SpecialistJaiz Bank PLC, Abuja, FCT Abuja Oct 2011 - Feb 2013 Coordinated and led DBA functions to ensure 24/7 availability of databases, optimally and to enhance service delivery objectives of core banking applications and other e-channels. Administered System and storage services covering AIX 7.1 servers, IBM HMC, IBM Tape Library and IBM Storwize V7000. Managed BI reporting and generation of ad-hoc regulatory reports. Supported patch management, documentation and version control of all deliverables, coordination of CSI - continuous Service Improvement plans and CAB Change Advisory Board. Managed Data Centre Infrastructures and coordinated DC shift personnel.Database Administrator/Apps DBA
International Turnkey Systems, ITS (Airtel-ITO), Banana Island, Ikoyi, Lagos Jun 09 - Oct 2011 Installed and supported Oracle RAC databases, ERP application on IBM AIX, HP-AUX, and Sun Solaris systems Routine monthly cloning (refresh) impdp/expdp or RMAN for Monthly billing cycle test run on TABS application Oracle application development using PL/SQL; tuning and debugging many packages leveraging on Toad tools. Developed, debugged and maintained many existing SQL scripts queries and stored procedures in response to reporting and other ad-hoc demands from marketing , regulatory units and other business channelsSQL Application/DBA Developer Jan 2007 - Jan 2009Identification Solutions Ltd (now IQSS Ltd), Maryland, Lagos Supported Electronic Document Management Solutions and Workflow Design using OpenText Livelink, Kofax and Kodak as part of implementation of eDocument Project for Lagos State Government, Ministry of Science and Technology. Designed and developed security/identification applications (Secure Time and Attendance, SecureCheque, eLands Webservice etc.) using Java, EJB Query Language, C#, MS SQLSERVER, and C++. Oracle Application Development using PL/SQL, Forms/ReportsSystem Engineer
OCI Automation Ltd., Lagos May 2006 - Jun 2007 Industrial automation using national instruments LabVIEW and C++ for a project Asynchronous Automated Traffic System for an intersection at Lagos city capital, Ikeja |
