Olalekan Omoniyi
Personal data and contacts will be open only to employers with access to CV database
Database Administrator 500 000
Job Type: Full-Time

Education

From 0 to 2002
University Of Iloring
From 0 to 1998
Federal University Of Technology Minna
No added languages

Experience

Database Administrator
Globacom Ltd
January 2011 - Present Day (6 years 2 months)
  • Oracle Database Administrator (Oracle Enterprise Server 8i, Oracle Enterprise Server 9i, Oracle Enterprise Server 10g and 11g) on UNIX, Linux operating Systems and Windows servers
  • Oracle installation and configuration, database administration including planning, implementation, backup & recovery strategies. Experience in real life SDLC for any new Development.
  • Successfully maintained various databases of varying database sizes, Proficient in I/O tuning and experienced in memory and application tuning.
  • Backup and recovery by utilizing Recovery Manager (RMAN), Export / Import, Data pump etc. Exposure in Oracle10G and 11G RAC, Exposure in OEM and TOAD, Auditing the database.
  • Backup and restoration using RMAN on Symantec backup utility.
  • Maintain high availability of databases for 24/7 global operation
  • Worked in one of the largest Telecommunication company in Nigeria (Globacom Nigeria)
  • Performing recommended actions based on the health checks, analysis to fix the database /server problems if any.
  • Involved in preparing proof of concept for the same.
  • Database design and implementations.
  • Database Reorganization and design indexes to improve response of queries
  • Leverage database architecture to be more efficient and more flexible
  • Establish, review and maintain enterprise database standard and best practice Covering
  • backup/recovery procedure, monitoring scheme, space management
  • Monitor CPU usage, I/O contention, memory paging on Windows Servers
  • Evaluate and adjust Oracle database initialized parameters in init.ora file.
  • Monitor and optimize database performance.
  • Manage Users, roles and privileges
  • Troubleshoot Undo and Temporary Tablespaces related issues
  • Maintain and monitor the physical layout of disk storage, Tablespaces, Data files, and object extents
  • Monitoring & handling locks & deadlocks & wait events.
  • Monitoring index usages & creating, dropping, coalescing & rebuilding the indexes.
  • Monitoring tables for partition requirements & partitioning the tables & purging the Partitions.
  • Monitoring & performing database or schema or table level stats gathering.
  • Performing Database Tuning which involves tracking hit ratios an d database wait events & re-configuring
Senior Manager
SystemSpecs Limited
February 2004 - December 2010 (6 years 11 months)
  • Software Development, Support and Maintenance of an ERP Solution (Payroll, HR, Pension, Asset) Using PowerBuilder 8.0. , Java, JavaScript, Java Server Page(JSP) on SQL, ORACLE database and JBoss as the application Server.
  • Applications, Infrastructure and Systems design, development and Implementation.
  • Systems Review (Health checks, Capacity planning, Architecture review etc)
  • Use of Report Generating/Designer tool (I-net CrysterClear Designer XML).
  • Designing, Implementing and Administering Oracle and Microsoft SQL databases.
  • Read and Write complex PL/SQL queries to perform application business logic.
  • Tuning database and optimizing/rewrite query for better performance
  • Software Modification and Maintenance and generation of both User and code Documentation.
  • Implementation of Biometric data capturing for IPPS