Oracle Manager

ESTHER A. ADEJARE

****************@*****.*** 404-***-****

Atlanta, GA

EXECUTIVE SUMMARY

Database administrator (DBA) with extensive experience implementing, tuning, testing and supporting next generation

•

database solutions in Oracle enterprise.

Proficient in an assortment of technologies including UNIX, Windows, Oracle 10g/11g, documentation, testing, training

•

and production support.

Provided 24x7 production supports for Oracle 11gR2 databases on Windows / UNIX platforms.

•

Proficient in all DBA responsibilities such as installation, Configuration, Upgrades, Patches, Performance Tuning,

•

Backup, Recovery, Cloning, Space management, Database Security, Auditing, Troubleshooting, Unix Shell Scripting,

Scripting in RMAN and Documentation.

Cloning Oracle Applications and Databases between DEV, UAT and Production Environments.

•

Refreshing data on cloned instance of Oracle application by cloning.

•

Involved in creation, installation, maintenance and administration of Databases in LINUX and WINDOWS Platforms.

•

Managing the production database for Oracle and SQL Server and resize the space of

•

database/Datafiles/Tablespace/Transactional Logs.

Creating, Updating, Altering Tablespace, Indexes, Tables, Views, Synonyms, Profile, Role, Privileges

•

Creating/Managing users profiles and analyzing their privileges and tablespace quotas.

•

Strong experience in administration and database monitoring.

•

Experience in Creating and maintaining Physical Standby Database.

•

Performing activities like Switch Over and Failover in the data guard environment.

•

Changing the Mode of the Stand by database to Maximum Protection, Maximum Availability.

•

Planning & Implementation of Oracle CPU patch in environments.

•

Performance tuning at DB and OS level (monitor and investigate further PPID’s with high resources in terms of CPU and

•

Memory)

Daily Health check of the Database.

•

Manage; refresh (manual & automatic) reviews.

•

Report & documentation

•

CORE COMPETENCIES

Database Design & Administration • Solutions Delivery • Team Building • Project Planning & Delivery •

Troubleshooting & Problem Solving • Process Improvements • Technology Implementation • Communication

TECHNICAL SKILLS

SQL, PL/SQL, Oracle 10g/11g, SQL*Plus, Enterprise Manager (OEM), Grid Control, Data Pump, SQL Loader, Oracle

Recovery Manager (RMAN), Recovery Catalog, Automated Workload Repository (AWR), ADRCI, Oracle Scheduler, Data

Pump, Real Application Clusters (RAC), Standby Database (Physical, Snapshot, Logical), Unix Shell Scripting, Automatic

Storage Management (ASM), TOAD, SecureCRT, Enterprise Reporting using Microsoft Office (Word, Excel, PowerPoint,

Outlook ), MS SQL Server 2005/2008/2010, MySQL, Windows OS, Linux

PROFESSIONAL EXPERIENCE

Resume

Alani Akintoye CPA, PC Atlanta,GA June 2011 Till date

Oracle Database Administrator

Manage Oracle database administration assignments for diverse industry clients. Enhance database performance, perform

restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical

and functional designs meet business requirements.

Responsibilities:

Manage Oracle database administration assignments for diverse industry clients. Enhance database performance,

perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups.

Ensure technical and functional designs meet business requirements.

Monitoring database performance, repairing deadlock errors, executing maintenance packages, monitoring space

and updating index statistics.

Developed and tested storage strategies and disaster recovery plan for large manufacturing company's operational

database, delivering solution that guaranteed recovery performance and high availability.

Enhanced end users' understanding of database systems by conducting pre implementation workshops, delivering

group and individual training sessions and creating user friendly training materials .

Provide 24x7 support for critical production systems on call/ rotation basis

Perform scheduled maintenance and support release deployment activities after hours

Perform database backup and recovery, including creating and testing backup strategies.

Assist Developers to design, develop, test and maintain Oracle PL/SQL packages, triggers, stored procedures and

functions to support numerous clients.

Create, update, and maintain system documentation for removal, storage, and retrieval of online data.

Implemented data transfer using Export/Import utilities and Data Pump

Troubleshoot of Performance and Tuning problems in Oracle database using tools like AWR, ADDM, OEM Grid

Control and manual scripts.

Set up Standby Database using shell scripts and RMAN utility tool, activating and Re building Standby Databases

both Physical and Logical supported by DATAGUARD

Perform Switch Over and Failover in the data guard environment.

Implement and manage ASM to simplify management of files in and out of the database.

Successfully setup, Design, Install & Implementation of Oracle 11g Grid/11g RAC, ASM,11g/10g RAC (Real

Application Clusters) multiple RAC Node Configuration for our clients

American Pacific Mortgage Network, Norcross Georgia Feb 2010 April 2011

Jnr. Oracle Database Administrator

Responsibilities:

Clone, recover, and migrate Oracle databases

Performs systems security administration functions, including creating user profiles, accounts, grant access and

privileges to users

Monitors and manages system resources, including CPU usage, disk usage, and response times to maintain operating

efficiency

Keeps the database managed to peak performance, monitors daily system performance, and tunes the database when

necessary.

Monitored Tablespace size, resizing Tablespace, relocating data files for better disk I/O.

Created backup plan design and implementation using cold/hot backups using RMAN backup technology. Works

closely with other IT staff to insure that user interfaces are working properly.

Resume

ALANI AKINTOYE CPA, PC Atlanta, GA. Jan 2007 Jan 2011

Staff Accountant:

Responsibilities:

Assist in tax preparation for companies and individuals.

Prepared small companies monthly sales and excise tax.

Reconciled small companies daily invoice transactions into Peachtree software

Handled all activities in accounts payable.

Prepare accounting and financial reports, schedules and statements.

Prepared financial reports and analysis for small businesses.

Maintain the general ledger for the various corporate entities, including preparation of journal entries & invoice

coding.

Complete all bank reconciliation reports with subsidiaries, divisions and corporate office.

Prepare accounting and financial reports, schedules and statements.

EDUCATION

Bachelor of Business Administration in Accounting

Kennesaw State University, Kennesaw, GA.

TRAINING

Oracle Database 10g/11g Administration

SQL and PL/SQL Fundamentals

Introduction to UNIX Scripting/ Red Hat Linux

Oracle Grid Infrastructure and ASM

Hands on Approach to Oracle Real Application Cluster (RAC)

PROFESSIONAL DEVELOPMENT

Oracle Database 11g Administrator Certified Associate (OCA)

Oracle Database 11g: Structured Query Language (SQL)

Resume

Contact this candidate