Professional Summary:

. Over * years of Oracle DBA experience with ORACLE 11g, 10g, on

UNIX/Sun Solaris/AIX and Windows.

. Experienced in planning and implementation of Backup and Recovery

strategy, used physical backup and logical backup using EXPORT/IMPORT,

Expert in disaster recovery.

. In-depth knowledge of setting up RMAN backups using control file and

Recovery Catalog, and maintaining catalog schema. Proficient in

creating auxiliary and duplicate databases using RMAN.

. Strong knowledge in Migrating Oracle 10g to 11g.

. Proficient in Installation, Troubleshoot, Maintenance and technical

Support for Oracle (12c, 11g and 10g) Databases, Grid Control and OEM.

. Experienced in Performance Tuning such as tuning of application,

shared pool, buffer cache, I/O distribution, rollback segments, and

redo mechanisms.

. Highly skilled in Oracle DBA - Installation, Administration, creating

Backup & Recovery Strategy Implementation, Performance

Monitoring/Tuning and Database Security.

. Maintenance and development of database objects like Queues, Tables,

indexes, Stored Procedure, constraints, triggers, Table & Index

Partitioning, DB links, users, roles, profile and SQL NET and

Listener.

. Strong technical and analytical skills with excellent interpersonal

and communications abilities.

. Excellent analytical, research, and problem solving skills.

Professional Experience:

Ishglo-One Crop Frederick, MD

04/2009-Present

Customer: CREC Hartford, CT

Oracle DBA Contractor

. Installed and Configured Oracle 10g and 11g software on LINUX.

. Apply Oracle Critical Patch Update (CPU) patches on our databases

every quarter.

. Installed and configured RMAN to backup production databases.

. Use RMAN to perform database recoveries when necessary.

. Performed database design tasks such as enforcing referential

integrity standards; create database tables and table dependencies

such as indexes, stored procedures, functions, packages, triggers,

views, materialized views etc.

. Used Oracle Transparent Data Encryption to encrypt tables and

Tablespaces that contains PII data.

. Created databases and developed procedure to migrate and refresh

databases between the development and production environments.

. Upgraded several databases from Oracle 10.2.0.1 to 10.2.0.4-11.2.0.2

. Performed various DBA Maintenance task such as rebuilding indexes,

validating constraints, reorganizing tables using the move command.

. Setup technical procedures and administrative policies for production,

test and development databases physical design, administration,

maintenance, tuning, backup and recovery. Allocated system storage and

plan future storage requirements for the database systems.

. Installed and verified the database software on the database server.

Planned, prepared and scheduled software installation.

. Installed Oracle 10g and 11g on Unix, Linux and Windows, applied

patches; upgrade Oracle server and application tools, maintained the

software at the latest stable release level and tested and verified

the installed components.

Uptime System INC Frederick,

MD

Customer: New Hope Manor LLC, Manchester, CT

10/2013 - Present

Oracle DBA (Remote Contractor)

Responsibilities:

. Upgraded several databases from Oracle 10.2.0.1 to 10.2.0.4 to

11.2.0.1 to 12c

. Performs backup and recovery using RMAN, Flashback Technology and user

managed backups.

. Performs regular health checkup of production and test databases and

performance of Oracle application system.

. Performing Database or schema level refreshes using the traditional

EXPORT/IMPORT and Data pump or backup utilities.

. Managing and performing Tablespace Management, Undo Management, Redo

log management, Control file management, online Redo log management

and user privilege management.

. Administer and manage the Oracle Instance using custom scripts and 10g

Oracle Enterprise Manager (OEM) database control and Grid Control.

. Performs Database tuning such as memory tuning, Application tuning

using tools like TKPROF, EXPLAIN PLAN, PLAN TABLE, HINTS, ADDM, and

SQL/Session TRACE.

. Performs database physical and logical design and procedures for

Production, Development, Q&A, Test and Training servers.

. Proactive Database tuning to keep hit ratios at a minimum standard

guideline using STATSPACK and AWR reports.

. Supporting standby database and performs failover and switchover from

primary to standby database when needed using TAF.

. Utilized Oracle 10g Data Pump IMPORT and EXPORT utilities to implement

hot standby database (Data Guard) for production database setup and

successfully performed active failover in the event of production

failure.

. Creating and managing LOBs. Creating Regular views, sequences,

partitions, and refreshing Materialized Views as needed by the

development team.

. On-call database support.

. Capacity Planning.

12am Solutions Inc. Frederick, MD

3/2010 - 9/2010 Oracle DBA (Remote Contractor)

Responsibilities:

. Created and configured database by making changes to the

Initialization Parameters in parameter file and dynamically in session

. Performed backup and recovery using Oracle 10g's user managed backup

such as automated or manual cold backup and hot backup procedures.

. Wrote scripts for informing the DBA's regarding the status,

performance and Space Management of the Database.

. 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 by using Unix Shell scripting.

. Capacity Planning

. Performed tuning such as database tuning, SQL tuning such as query

optimization (RULE and COST BASED), AUTOTRACE, and SQL Profile.

. Prepared and reviewed database specifications, testing and changing

control management programs migrations. Upgraded the database from 10g

to 11g database and applied database patches (CPU).

. In depth knowledge of setting up RMAN backups and recovery, RMAN

tuning, and maintaining catalog schema. Proficient in creating

auxiliary and duplicate database using RMAN.

. Wrote several ad hoc scripts for daily DBA activities such as backups,

user creations, granting roles and privileges, archiving of alert

logs, verifying error entries and checking for space usages/overages.

Hardware/Software:

ORACLE 12c/11g/10g/9i SQL*PLUS, SQL*Loader, Power Builder, SQL Developer

2000/6i, SQL, PL/SQL, UNIX, Linux, Windows 2003/2008, SQL Navigator, TOAD,

ERWIN, TOAD, Data Guard, Oracle Grid Control, PLSQL, OEM, SunOS 5.8/10,

Windows 2003/ XP/NT, Unix Shell scripting, XML, HTML, MATLAB, and MS

office.

Education Qualifications:

OCA & CAPM pursuant

Associate in Accounting University of Ghana Legon

Oracle/Windows Database Administration

Contact this candidate