Oracle Data

Oracle Database Administrator

OLUWATOSIN ADESHOPO

Email: *********@*****.*** Phone: 240-***-****

Professional Summary

Over 8 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g,11g,12c and Oracle Exadata

Data transferring with export/import utilities and Data Pump and SQL* Loader.

Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.

Experienced in installing and setting up Oracle 12c, 11g R1/R2, 10g, databases.

Deployed Standby databases using Data Guard 11G (Maximum Performance).

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch as well as database upgrades

Installed and maintained Real Application Clusters (RAC)

Performing complete and incomplete recovery during disasters, failures and user errors.

Configuring user creation, their roles and privileges profiles to control access over database objects.

Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.

Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.

Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.

Extensive experience in database production support.

Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator.

Monitored physical I/O and Proper sizing of rollback segments.

Optimized SQL using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.

Education

University of Maryland University College

• Master in Cybersecurity(Incomplete)

University of Adoekiti

• B.Sc in Economics

Oracle University

• OCP 11g

• OCP 10G

• OCA 10G

Technical Summary

Databases Oracle 11G/10G/12C

Operating

Systems

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

Tuning

Tools:

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages SQL, PL/SQL, UNIX Shell Scripting, PERL. Utilities RMAN, OEM, SQL*Loader, EXP, IMP, Data pump,, TOAD, Oracle SQL Developer.

Professional Experience

CSRA(CMS), Columbia MD July 16–

Role: Database Administrator

Environment: Oracle 11.2.0.4, 12.1.0.2, ORACLE X4 Exadata 3 node RAC environment, RMAN, OEM, Datapump, AWR, ADDM, ASH

• 24x7 Production database administration, support and monitoring to ensure proactive problem recognition and resolution of database issues.

• DBA Day-to-day activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs.

• Performed hot and cold backup and recovery using RMAN and UNIX Scripts

• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.

• Monitored database and system performance. Administered Oracle clusterware and resources on 11g and 12c using CRSCTL/SRVCTL

• Comprehensive experience as Database Administrator, especially with Exadata and proficient in Oracle11g/12c software installations and migrations

• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.

• Worked on application and database security (data access, passwords, network, etc.)

• Handled daily production problems/change requests with Oracle.

• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.

• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).

• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases and discovering issues that could potentially cause disasters

• Monitored the server's memory, disk, CPU I/O and network to establish baseline and peak performance for applications using UNIX command line utilities.

• Analyzed SQL queries causing performance problems.

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

• Work cooperatively with developing team to make structural changes to the databases.

• Implement table partitioning/indexes etc. to improve performance and data management and monitor user access rights

• Perform RMAN configuration, database backup which included (hot and cold) and recovery, troubleshoot and resolve related issues. Created shell scripts to execute the processes and also executes the database scripts for applications as well as RMAN backups

• PL/SQL Tuning and bottlenecking: Tuning and fixing some performance problems using AWR/ADDM and EXPLAIN PLAN.

Northrop Grumman, Little Rock AR Oct 15 – May

16

Role: Database Administrator

Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, DataGuard,RMAN, OEM, Datapump, AWR, ADDM, ASH

Responsibilities:

Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.

Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.

Worked with application developers to address and clarify data requirements to resolve technical and functional issues.

Enforced corporate business rules through adequate user/resource/object management.

Reconcile functional and technical problems through interaction with the client by researching and identifying the defined issue and by fully testing and confirming possible solutions to the problem.

Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.

Involved in performing upgradation from Oracle 9i, 10g to Oracle 11.2.0.3 RAC database.

• Experience in using Golden Gate to support data replication in the Oracle database environment.

Experienced in installing and setting up Oracle 12c, 11g R1/R2, 10g, databases.

Worked on POC on OEM 12c Cloud, installed in all our non -prod databases, have good knowledge on 12c.

Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS

Experience in Data Migrations using oracle export/import, datapump, sqlldr.

Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN.

Proficient in using OEM and RMAN.

Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.

Designing the logical and physical database structure.

Schema design experience using ERwin, expert scripting experience in Perl and all Unix shell scripting variations.

Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.

Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.

Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).

Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.

Troubleshoot and resolved log gap in Data Guard Configuration Charles Schwab -Denver, CO. Jun 12 – Aug 15

Role: Database Administrator

Environment: Oracle 11g/10g/9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump.

Responsibilities:

Installation of oracle 11g databases in production, development and test environments depending on project requirements.

Configuration of Listener and Tnsnames.

Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.

Created database link between two databases to access the table data from one local database to remote database using distributed database feature.

Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..

Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.

Designed Logical and physical database for business transaction functionality.

Provide production support for the deployed project till it is stabilized.

Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database

Refreshing development/test database from production using Export/Import & RMAN backups.

Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.

Managing database security.

Creating and assigning appropriate roles and privileges to users depending on the user activity.

Defragmentation of tables and indexes for improved performance and effective space management.

Managed Database Maintenance Activities to achieve optimum database uptime.

Written SQL scripts to create database objects like tables, views and sequences.

Created procedures and functions using PL/SQL.

Preparation of High Level & Low Level Design documents. Baxter Inc. -Deerfield, IL Mar 10 - Jun 12

Role: Oracle Production Support Database Administrator Environment: Oracle 11.2.0.3, 10.2.0.2, Sun Solaris 10.0. Responsibilities:

Estimating table sizes, table spaces.

Created database objects like tables, tablespaces, buffer pools, indexes and views.

Analyzing tables and indexes for performance tuning..

Ensured that the ICD-9-CM diagnosis and procedure codes & CPT codes requirements are thoroughly understood by all the stakeholders to incorporate appropriate changes in the recording system.

Creation, maintenance, backups and restoration of databases.

Analysis and Designing Database.

Create a PL/SQL function, stored procedure, package to support reports.

Refreshing and manipulating data in tables using PL/ SQL procedures.

Creation of logins and user ids and setting up privileges and procedures for protection of data

Monitored and tuned rollback segment, temporary table space, redo log buffer, sort area size.

User creation with proper roles and privileges.

Data migration between databases using both Oracle 11g and 10g export/import utility and Oracle 11g exp/imp data pump.

Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.

Ran scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

GMAC Commercial Mortgage – Horsham, PA Nov 09 – Mar 10 Role: Junior Oracle Database Administrator

Installation and configuration of Oracle database 9i (9.2.0.4), 10g (10.2.0.1) on various OS platforms like HP-UX, Linux, and Windows NT, 2000

Monitored Customer Databases, physically located in U.S and Remote administration of fifteen Production Databases in UNIX environment

Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database

Worked on the physical and logical designing of the database, which includes the distribution of data- files on different disks

Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters

Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability

Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes

Created primary database objects (tables, views, indexes) once application developers have designed an application

Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements

Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks

Allocated the separate rollback segments for the Batch processing jobs in order to speed up processing

Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks

Contact this candidate