Resume

Sign in

Oracle DBA

Location:
Baltimore, Maryland, United States
Salary:
$95,000
Posted:
November 15, 2018

Contact this candidate

Resume:

Olamide Ikuomola

Phone :443-***-**** Email:ac7pe6@r.postjobfree.com

Professional Summary:

Seasoned database administrator with extensive professional work experience in securing the integrity of Oracle and SQL Server databases. Profound in the administration, installation, upgrading, configuration, maintenance, and troubleshooting of databases. Background experience involves working with technical teams to design, test, code and support next generation solutions for our company. Proven the ability to champion the implementation of updated versions of Oracle/SQL Server products to enhance the workplace productivity. I’m a competitive achiever who can successfully manage multiple priorities, willing to work, and perform under pressure in a fast-paced, rapidly changing environment. Experienced in maintaining high quality standards to meet the challenges of this “frenzied” and high turn-over industry. My core strengths are in the areas of:

Oracle 11g and 12c database administration on Linux and Windows platforms

MSSQL Server 2008, 2012 database administration on Windows Server

Database Duplication, Migration, Refresh, Upgrade and Patch application

Physical (RMAN) and Logical (Expdp/Impdp) database backup, restore, and recovery

Performance turning (Proactive and Reactive maintenance)

Administering and Managing RAC, ASM, RAID & Data Guard

PL/SQL deployment

Capacity planning, sizing applications and server hardware

User and security management

Assisting developers with application design

Collaborating with vendors, end users, and other support groups

Technical Skills:

RDBMS: Microsoft SQL Server (2008, 2012), Oracle (11g, 12c)

Languages: HTML, JavaScript, PL/SQL, SQL, SQL PLUS

Operating Systems: Linux/Unix (RED HAT LINUX), Windows (2008, 2010)

Tuning utilities/Oracle Concepts: Oracle Enterprise Manager, Dataguard, SQL Plus, Data Pump, RMAN, ADDM, Oracle Jobs, Flashback, Oracle Recycle Bin, Oracle Advanced Queuing, Oracle Streams, SQL LOADER

Experience:

Quest Diagnostics, Chantilly, VA (Feb 15 - Present)

Oracle DBA

Oracle 11g, 12c

Roles and Accomplishments:

Configure databases for recoverability

Manage Oracle 11g RAC database using CRSCTL and SRVCTL

Manage RAC database on ASM storage

Apply critical patch updates on RAC database using OPatch auto

Manage Oracle 11gR2 data guard

Worked with DBA team to migrate 12T of data from 11g to 12C (VLDB)

Troubleshoot and resolve log gap in data guard configuration

Validate RMAN Backup, restore and recovery of database physical files

Perform Database refresh using Export and Import Data Pump

Create database links to enhance developers

Performance tuning of databases with optimizer, AWR, ADDM, explain plan and advisory frameworks

Tune slow running queries

Reverse engineering of database schemas into physical and logical models

Performed operation and maintenance tasks at O.S and database level

Monitor Sessions and resolve lock issues

Manage PL/SQL stored procedures, triggers and packages

Collaborate with developers to investigate database issues and execute scripts

Document database structure, changes, problems, issues for future reference using one note

Work with developers/analysts on troubleshooting issues.

Provide database security measures by creating and assigning appropriate roles and privileges to users.

Generate object comparisons between databases.

Provide solutions and maintain the database for troubleshooting by using trace files, and alert logs.

Daily incremental backup and weekly full backup of databases using RMAN.

Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and running scripts given by the clients.

Routine database clean ups, removing old trace files/ archived logs.

Monitored and resolved issues that appear in production environment

Table space monitoring, performance monitoring and tuning for performance improvement.

MSSQL SERVER 2008/2012

Routinely monitored Server activity, error log and space

Schedule backup using Full, Differential and Transactional log backup process

Deploy SSIS packages

Perform database refresh from higher environments to lower environments

Manage security scheme for the database environment

Monitor Job logs and manually execute failed jobs

Monitor SQL server agent

Vector Security, Hanover, MD (Dec 13-Feb 15)

Jr. Oracle DBA

Oracle 11g/MSSQLMS

Roles and Accomplishments:

Install the Oracle client and server software and configuration

Configuring Backup (RMAN) for database and database recovery/restoration.

Database Links, Creating, Managing Tablespaces and Datafiles.

Load and transfer data using Data pump and SQL Loader utilities.

Set up and manage database security by creating new users, roles, profiles, and

provide required user privileges

Managing schema objects

Regular monitoring alert log files and trace files on day to day basis

Configure and implement the use of Oracle Recovery Manager (RMAN)

Moved data from one database to another using transportable tablespace

Granting roles and privileges to end users.

Implement multiplexing of control files and redo log files

Performed Oracle CPU Patch using OPatch.

Monitor Tablespaces and Datafiles

Loading data into database tables using SQL Loader.

Implemented Materialized views, database links.

Responsible for quarterly patches, /maintaining/monitoring/upgrading the production and test databases for products.

Responsible for the administration of highly available web logics database solution supporting over 70 concurrent users.

Administer databases using SQL Server Management Studio (SSMS).

Provide on-call support to production environments (sometimes wknds)

Work in a team environment and provide hands on experience sharing to DBA team

Managing, troubleshooting and resolving Oracle database and application issues.

Allied Barton, Columbia, MD (Jan 13-Dec13)

Jr. Oracle DBA

Roles and Accomplishments

Monitor, tune, and supporting day-to-day activities of the production, testing and development databases; then work on urgent issues and resolve them based on priority.

Collaborated with managed service providers, internal development team, consultants and Oracle Support.

Assist users with request such as creating tables, accounts, and users.

Assist on the development, test, and production of database support.

Assist/Monitor database management on 11g OEM (Oracle Enterprise Manager)

Develop and implement database queries.

Attended Oracle Identity Management training. (Tues, Thurs)

CERTIFICATIONS

Oracle: SQL Fundamentals 11G

Oracle: 11g Database Administrator Certified Associate (OCA)

Education

Prince Georges Community College: Aug 06-May 09 (General Studies)

Coppin State University: Aug 09-May 10 (Mass Communications)

Graduate School of Washington DC: June 11- Dec 11 (Clinical Lab Science)

DBA/Oracle Tutoring in Laurel MD: Jan 17 - Present

Reference upon request



Contact this candidate