Database Oracle

OLADIMEJI A. OLAYIWOLA

Email Address: ****.******@*****.*** Cellphone: 240-***-****

DATABASEADMINISTRATOR ENGINEER

SUMMARY:

Database Administrator experience on development, pre-prod, production seeking a challenging position, in a heterogeneous environment supporting multiple RDBMS platforms. An accomplished, result-focused IT professional, works well with team as well as independently, assumes increasing levels of responsibility and interfaces with all levels of technology and able to work well under pressure and meet timeline and open to learn and developed new skills on any other databases and new technology.

Skills:

• Extensive knowledge of relational database logical/physical architecture of single instance, RAC and Standby (Data Guard) databases and Linux OS. Provide 24x7 on-call support, Identify the issues and solve emergency database issues ranging from performance to storage problems.

• Database server/client software installation, perform patches apply both on single instance, RAC databases and upgrade. Establish client connections to Oracle database through TNS and Listener.

• Work cooperatively with developing team to make structural changes to production databases based on business requirements.

• Execute RMAN configuration, backup and recovery. Perform data movement, and Data Pump.

• Manage database security and also create and grant appropriate roles and privileges to users depending on user activities or tasks in hand.

• Installed Oracle RAC from scratch on Linux Operating System and posses the ability to document procedure properly in different format.

• Sound understanding of Oracle database architecture, configuration and administration, backup & recovery

• Experience with new features on 10g, 11g R2 and 12c and 12cR2 which includes SQL Access Advisor, SQL Performance Analyzer, SQL Plan Manager, Table compression enhancement.

• Administered and worked on 10g, 11g and 12c and Grid Control and posses some networking experience on LAN and WLAN and DHCP server.

Certifications:

•SQL Expert Fundamental Oracle database 11g

•Oracle Database 11g Administrator Certified Associate (OCA)

•Oracle Database 11g Administrator Certified Professional (OCP)

•Oracle RAC 11g Grid Infrastructure Administration (OCE)

•Oracle Certified Expert (OCE) Performance Tuning 11g

WORK HISTORY

Oracle Database Administrator

Technatomy Cooperation

Database Administrator

Fairfax, VA

January 2013-Present

Primary Responsibilities Includes:

•Participating in the Implementation and validating of various versions of Oracle Databases from 10g Release 2& 11g Release 2 to 12cR2 on all the environments most especially on the Linux Environment.

• Experienced with SRVCTL, OCR and Voting Disk on 10g and 11g and 12c RAC

•Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability from development to Production.

•Install database software and also perform the install/upgrade/patching processes on the environments from development to production.

•Provide support for the server patching both in development, pre-prod and prod environment on Linux OS and UNIX.

•Provide support for VDR test of the application on Data Guard and good knowledge of ASM especially on RAC and single instance database

•Maintain/manage single instance, RAC and standby databases on various operating system, such as, Linux, and Solaris

•Troubleshoot and resolved log gap on Data Guard (Standby Database Environment).

•Implement database security. Create user accounts, grant necessary permissions/roles to the accounts for database access.

•Also, perform bulk load into the database using SQL Loader on test environment

•Documented database structure, changes, problems, issues for future reference

•Create table spaces, users, synonyms and database links, triggers and support development application teams. etc. Tune expensive codes.

•Administer database user accounts. Create, modify and deactivate user accounts assign

•Participate in the perform RMAN configuration, database backup which included (hot and cold) and recovery, troubleshoot and resolve related issues.

•Regularly Monitoring Alert log Files and trace files on Day to Day Basis and trouble shoot any issues that may arise.

•Manage RAC and single instance database on development, test and production environment and provide maintenance without downtime for the customers.

•Creating and dropping of users, granting and revoking permissions to users/roles as and when required.

•Responsible for Space Management and Security on the Database and perform node add and delete on Oracle Rac database environment

•Troubleshoot RAC issues with olsnodes, crs_stat, crs_register, crs, crsctl check crs,

•Perform database upgrade from 10g to 11g and 12c on dev and pre-prod

•Configure and manage tablespaces, tables, and users for custom applications and experience with DDL/DML.

Oracle Database Administrator

Chimes Cooperation Inc.

Database Administrator

Baltimore MD

April 2008–December 2012

Primary Responsibilities Includes:

• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.

• Participated in day to day DBA tasks: installations, ongoing maintenance tasks, database updates, backup and recovery process for Oracle databases

• Worked in PL/SQL and SQL Tuning tasks, change management, database refreshes.

• Provide support in dev server patching and trouble shoot oracle network problems.

• Provide network troubleshooting and administrative support for the development staff

• Experience in Installation and configuration of Oracle 10g, 11g and 12c on LINUX and Solaris environment.

• Experience in Installation of Oracle 10g, 11g and 12c Real Application Clusters (RAC) databases on Linux and Solaris operating system.

• Hands on experience in configuration, administration, maintenance & recovery of single-instance & Real Application Clusters (RAC) Databases.

• Participated in Configured Data guard environments for disaster recovery and high availability, experience setting up physical standby, active data guard.

• Hands on Experience using Oracle utilities Data pump, SQL Loader, RMAN, Original export/import.

• 24*7-production database support with Support to developers & end-users.

• Manage security and grants for database users.

• Expertise in ASM administration and the creation of databases, table spaces, tables, indexes and other database objects

• Responsible for managing daily backups and fix any issue that may arise

•Responsible in recovered corrupted datafiles from backups.

• I possessed strong physical and logical Data Guard skills and Troubleshoot RAC issues with olsnodes, crs_stat, crs_register, crs_unregister, crsctl check crs,

Skills Summary:

•Databases: Oracle 11gR2, 11gR2 RAC, Oracle10g,

•DBA Tools: TOAD, OEM, Grid Control, SQL*Loader, Rman

•RDBMS Tech: Oracle 10g, 11g,12c Standby Database.

•Tools and Utilities: Export/Import, RMAN, Data Pump, WinScp, ASM, PUTTY,

•Operating Systems: UNIX, LINUX, SOLARIS, Windows Server

EDUCATION:

Bachelor of Science in Criminal Justice

Coppin State University

Baltimore Maryland. May 2009

Masters of Science in Health System Management

University Of Baltimore

Baltimore Maryland. May 2012

Boltos Solutions Institute- Affordable Oracle Hands-On Training

Laurel Maryland. May 2010 &August 2013

References:

Available on Request

Contact this candidate