Manager Database

Oluwaseun Emmanuel Laoye

• 202-***-**** • **************@*****.***

POSITION:

Oracle Database Administrator

Oluwaseun Laoye is a database administrator with in-depth skills in installation, configuration, upgrading, administration, monitoring, maintenance, and security of enterprise databases to ensure confidentiality, uphold integrity, and availability.

TECHNICAL SKILLS

•5 years + of experience as Oracle 10g,11g, Database Administrator on Linux and Windows OS

•5 years + of experience in SQL, PL/SQL, SQL*PLUS

•5 years+ experience in Enterprise Manager

•5 years+ experience in RMAN, Backup and Recovery

•5 years+ experience in Database Migration and Performance Tuning.

•1 year+ experience in Data Guard Administration

•2 years+ in Database Upgrade and Patch Application.

•1 year + experience in Networking Topologies / Protocols: Ethernet, TCP/IP

PROFESSIONAL EXPERIENCE

CORNERSTONE DISTRIBUTION LTD 2013 - Present

Database Administrator

•Performs standard and fine grain database auditing to monitor data access and all DMLs

•Installs, creates, tests and develops databases following OFA compliance rules.

•Expertise in the installation, creation of databases, table spaces, tables, indexes and other database objects following OFA compliance rules.

•Installation and configuration of relevant network components to ensure database access as well as database consistency and integrity.

•Troubleshoots and resolves various Oracle connectivity problems.

•Provides network troubleshooting and administrative support for the development staff.

•Installation and management of Oracle database using database control.

•Creates and manage documentation on the configuration and support of the Oracle databases.

•Performs bulk load into the database using SQL Loader.

•Documentation of database structure, changes, problems, issues for future reference.

•Administers database user accounts. Create, modify and deactivate user accounts; assign and monitor user access rights.

•Creates Testing and Development databases following OFA compliance rules.

•Provides database administration on production, testing and development database servers.

•Managing Schema Objects.

•Regular Monitoring of Alert log Files and trace files on Day to Day Basis.

•Identifying and removing Fragmentation, row migration/chaining of database objects. Analyzing the Tables and Indexes on performance base regularly.

•Monitoring Tablespaces and Datafiles utilization.

•Managing Undo Tablespaces, Redo Logs, Control files and Archive logs.

•Implemented multiplexing control files and redo log files.

•Configuring various RMAN parameters as per the requirement.

•Performing physical backups using RMAN utility.

•Performes incremental backups using RMAN.

•Identifies and recover the corrupted db blocks using Block recover option in RMAN utility.

•Performing Complete Media Recovery of Database depends on the nature of failure. Configure and implement the use of Oracle Recovery Manager (RMAN) for cold and hot backup to the databases.

•Extensively using DATAPUMP and Export /Import utilities for logical backups.

•Performing database cloning and duplication using RMAN.

•Monitoring the user sessions and take appropriate action to kill the inactive sessions Creating and rebuilding indexes as necessary.

•Moves data from one database to the other using Transportable tablespace.

•Performes various performance goal oriented database tuning.

•Use explain plan, AWR, ADDM and various Oracle Advisors to tune the database. Created and tuned various materialized views.

•Tunning of various slow running query Performed series of database refreshes from production to test.

•Performes instance tuning, memory tuning query tuning and complete database tuning.

•Creates and implemented various table partitions for large tables.

•Resolved various complex issues with the database.

•Apply quarterly CPU patches to different version of databases.

•Upgrade Oracle 10g database to 11g and 11g.2.0.1 to 11.2.0.3 using patch set.

•Configure and setup Oracle 11gR2 Data Guard.

•Manages Data Guard using Data Guard broker.

•Troubleshoots and resolves log gap in Data Guard Configuration.

K&D TRANSPORT LTD 2010 - 2013

Database Administrator/Network administrator

•Provided database administration on production, testing and development database servers.

•Analyzed the tables and indexes on performance base regularly, using the optimizer to determine the most efficient execution plan and the most important step in processing of any SQL statement.

•Maintained the integrity, security and availability of multiple databases by administering database user accounts, create, modify and deactivate user accounts; assign and monitor user access rights

•Configured various RMAN parameters as per the requirement.

•Performed physical backups using RMAN utility to backup the control files, SP files and data files.

•Performs full and incomplete disaster recovery of database depends on the nature of failure using the recovery catalogue or complete recovery as the case may be.

•Configured and implemented the use of Oracle Recovery Manager (RMAN) for cold and hot backup to the databases.

•Extensively used DATAPUMP and Export /Import utilities for logical backups to achieve fast bulk data and metadata movement between Oracle databases.

•Monitored the user sessions and take appropriate action using dba_locks, dba_waiters, dba_blockers or v$session to kill the inactive sessions and releasing the locks on them.

•Performed various performance goal oriented database tuning such as instance, memory, query tuning and complete database tuning.

• Evaluated and recommended available database management system (DBMS) products

•Use explain plan, AWR, ADDM and various Oracle Advisors to tune the database for various slow running query by documenting database structure, changes and problems for future reference

EDUCATION/CERTIFICATION

Oracle 11g Database Administrator Certified Professional (OCP) In progress

Oracle 11g Database Administrator Certified Associate (OCA) In progress

Oracle Data Guard Boltos solutions Laurel MD June 2014

Bachelor’s degree (Bsc) in Computer Science October 2013

Federal Ploytechnic Ilaro, Ogun state, Nigeria.

Reference upon request.

Contact this candidate