Oracle Management

aul Turkson

P Oracle DBA

***** ****** *** **********, ******** 22191 (703) 910 – 1080 ************@*****.***

Professional Summary:

Over 5 years of Oracle DBA experience with ORACLE 11g, 10g, 9i on UNIX/Sun Solaris/AIX and Windows.

Proficient in Installation, Upgrading, Troubleshooting, Maintenance and technical Support for Oracle (11g/10g/9i)

Databases.

Proficient in Performance Tuning such as tuning of shared pool, buffer cache, I/O distribution, rollback segments,

and redo mechanisms.

Extensive experience in Oracle Database Administration

Excellent in the use of the import and SQL*Loader utilities to load data and performing exports as supplemental

to hot, cold and RMAN backups to be used for database restore and recovery

Maintenance and creation of database objects like Tables, Indexes, Stored Procedure, Constraints, Triggers, Table

& Index Partitioning, DB links, Users, Roles, and Profiles.

Creating users and assigning roles using profiles.

In depth knowledge of setting up RMAN backups using Control File and Recovery Catalog, and maintaining

Catalog Schema.

Knowledge in migrating of Oracle databases from one server to another.

Knowledge in cloning using cold backup, hot backup and RMAN.

Strong knowledge and experience in Migrating Oracle 9i to 10g and 10g to 11g.

Familiar with ASM.

Knowledge in UNIX shell scripting.

Strong in Structured Query Language (SQL).

Strong technical and analytical skills with excellent interpersonal and communications abilities.

Professional Experience:

Blutech Inc., Woodstock, Maryland 11/2010– Present

Oracle DBA, Consultant

Responsibilities:

Performs regular health checkup of production and test databases and performance of Oracle application system

using utilities like ARDCI and PLSQL packages.

Performs Database Sizing, Tablespace Management, Undo Space Management, Rollback space Management,

Transaction Management.

Performs backup and recovery using RMAN, Flashback Technology and User Managed backups.

Resized database redo log files by creating new redo log files and later dropping the existing redo logs

Administer and manage the Oracle Instance to ensure high availability using custom scripts and Oracle Enterprise

Manager (OEM) database control

Resolving TAR issues while assisting the functional team and oracle support and managing database security.

Provides support to Development, Testing, and QA teams on applications/database issues.

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

Responsible for working with application developers, system administrators and management to ensure that any

new product usage or release upgrade takes place with minimal impact on test and production environments.

Analyzing tables and schemas; collecting database and system statistics

Performs various DBA Maintenance tasks such as rebuilding indexes and tables, validating and enforcing

constraints, and reorganizing tables.

Page 1 of 3

aul Turkson

P Oracle DBA

13673 Hornet Way Woodbridge, Virginia 22191 (703) 910 – 1080 ************@*****.***

Performs database design tasks such as enforcing referential integrity standards; create database tables and table

dependencies such as indexes, store procedures, functions, packages, triggers, views, materialized views,

sequences, etc.

Performs database troubleshooting and tuning using ADDM, ASH and AWR Report.

Performing Database or schema level refreshes using the traditional EXPORT/IMPORT and Data pump, RMAN

or User Managed backups.

Allocated system storage and plan future storage requirements for the database systems.

Monitors database activity and file usage, and ensure necessary resources are present so that databases function

properly by removing, or deleting old or obsolete files.

On call database support.

Florida Power Line, Juno Beach, FL 01/2005 – 10/2010

Oracle DBA

Responsibilities:

Created and modified database structures as required by developers due to business or application requirements

Monitor database instances to ensure availability, ensure uptime.

Performed database troubleshooting and tuning using ADDM, AWR Reports.

Implemented automated backups and recovery procedures of databases using User Managed and Server Managed

(RMAN) backups.

Wrote scripts for informing the DBA’s regarding the status, performance and Space Management of the Database.

Engaged and supported software and application developers during SDLC.

Partitioned tables to improve performance and manageability.

Used EXPORT/IMPORT, SQL*Loader utilities and External Tables to load and backup data.

Upgraded database from 9i to 10g database using Database upgrade assistant, EXPORT/IMPORT utilities and

using oracle scripts. Managed and monitored hot standby database using (Data Guard) as well as monitoring

primary database.

Assisted development and applications team in SQL tuning for optimization using RULE or COST BASED

Optimizer, AUTOTRACE, EXPLAIN PLAN, and SQL Profile.

Prepared and reviewed database specifications, testing and changing control management programs migrations.

Upgraded the database from 9i to 10g database and applied database patches (CPU).

Performed various DBA Maintenance tasks such as rebuilding indexes, validating constraints, and reorganizing

tables using the move command.

Administered user accounts by creating and managing database user accounts. Defined, created and managed user

roles such as administrators etc. Granted and revoked privileges and managed resource usage by users.

Education Qualifications:

University of Science and Technology Kumasi, Ghana

Bachelor of Science, Mechanical Engineering 1997 2001

Hardware/Software:

ORACLE 11g/10g/9i SQL*PLUS, SQL*Loader, SQL, PL/SQL, UNIX, Linux, Windows NT/2000, TOAD, Data Guard,

Oracle Grid Control, RAC, ASM, OEM, HP UX 11.0, SunOS 5.8/10, UNIX 4.0, AIX, Windows 2003/ XP/NT, Unix Shell

scripting, XML, Microsoft Project, and MS office.

Page 2 of 3

aul Turkson

P Oracle DBA

13673 Hornet Way Woodbridge, Virginia 22191 (703) 910 – 1080 ************@*****.***

Page 3 of 3

Contact this candidate