William Hagan, OCA

Phone: 301-***-****) ● Email:accn3x@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Oracle Certified Associate, OCA with over 7 years of IT experience Provide

•

administrative support for all applications that use oracle database 10g and 11g

Experience with RMAN, 11g, Data Pump, Performance Tuning and knowledge about

•

ASM, RAC, DATAGUARD, Fine Grain Auditing (FGA), performing Flashback,

transportable Tablespace and Security Management.

• Management and implementation of database models, data flow diagrams, database

schemas, database scripts, to support a robust data management infrastructure

• Perform database cloning, data warehouse, database backup, recovery procedures and

security.

• Advanced knowledge of relational databases and concepts.

• Identify, resolve, or provide recommendation to different kinds of performance problems.

• Perform daily database backup of development and test environments, use production data

to refresh development and test schemas for testing.

• Implement/maintain database security with roles and system privileges, create, develop,

review, and support physical and logical models

• Working experience of defining triggers events, cursors, stored procedures and packages.

• Adopt at routine Database Administration tasks including automated installation, creation

and replication of databases, management of tablespaces, logs, grants, roles, users, indices.

• Working experience in database cloning, data warehouse, database backup, recovery

procedures and security.

Extensive Experience with RMAN Backups, Hot Backups and Cold Backups. Experience

•

working in a cross functional domain of data analysts and database administrator.

• Knowledge of SQL analysis tools and database internal debuggers including

ORADEBUG.

• Ability to conceive, communicate, document and implement strategic concepts.

• Experience in application Support, SQL Loader, Data pump, Grid Management, Data

Guard and knowledge about Real Application Cluster (RAC), Fine Grain Auditing (FGA),

performing Flashback, transportable tablespaces.

• Prepare documentation for DBA department

TECHICAL SKILLS / COMPETENCIES

Databases Oracle 10g, 11g

Database Tools

Oracle (Oracle Enterprise Manager (10g, 11g OEM), Oracle Universal Installer, Database

Configuration Assistance (DBCA), SQL Loader, Database Upgrade Assistance (DBUA),

Oracle Net Manager, SQL*plus and iSOL*Plus, Recovery Manager (RMAN),

EXP/IMP/Data Pump, Statspack/AWR, ADDM, SDLC.

Operating Systems UNIX / LINUX, Microsoft Windows 8, windows 7, windows vista and

XPRemote Tools Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop,

VMware Virtualization.

EDUCATION

Oracle Certified Associate, OCA Oracle University Gaithersburg MD

High School Mfanstipim school 2005

PROFESSIONAL EXPERIENCE

Jelani Consulting LLC 2008 to present

Oracle Database Administrator

Create oracle databases on configured servers using both the DBCA & Database creation

scripts.

● Manage, tune and troubleshoot database issues both on UNIX and LINUX command

line, SQL*Plus, OEM client, Oracle 11g database control, oracle 11g Grid Control as

well as other third party tools.

● Monitor database systems and provide technical support for database system issues and

application performance enhancement/improvement using OEM, Oracle 11g database

control & SQL*Plus.

● Data migration between databases using both Oracle 11g and 10g export/import utility

and Oracle 11g exp/imp data pump.

● Analyzing schemas of databases created to collect statistics using the DBMS STATS

package.

● Use AWR/ADDM for 11g Statistics management and database tuning following

creation of new databases and periodically thereafter.

● Troubleshoot installation errors with team members, independently and with Oracle

support (via My oracle Support)

● Application of quarterly Oracle software patches when/where necessary.

● Backup/Recovery monitoring and reporting using both BMC SQL Backtrack Oracle

RMAN

● Documentation of all configurations, installations, implementations, monitoring and

testing projects for future utilization.

● Work closely with Systems Analysts, Systems Engineers/Admins & Application

Developers through the SDLC from Development to Production, via Tech-Test in Needs

Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle

Installs), Database Designing (Physical & Logical) and Implementation, database user

creation and database access both at role & table levels, as well as final Project

Performance Assessment/Evaluation.

● Create database Objects, Table spaces, Schemas as needed.

● Schema migrations from Development to Production via Tech Test environments.

● Replication (Snapshots/materialized views, through database backup and control files)

& Cloning of databases from production to test, development & staging databases

● Designing & implementation of Database Backup and Recovery strategies - RMAN,

Netback up & Manual Patch download.

● Automate DBA activities using Cost -Based Optimizer for performance tuning using

Statspack/AWR, OEM Grid, dictionary & dynamic views, Explain Plan, hints, stored

procedures as well as mentoring users.

● Successfully performed data replication using Materialized views and Oracle Streams

in Oracle 11g.

●Migrated databases using RMAN and traditional Data Pump export/import utilities in

Oracle

● Implemented recovery strategies whenever required and successfully recovered

databases in case database crash, media/disk failures by using RMAN.

● Scheduling the Physical backups (hot & cold) using RMAN utility and monitoring the

scheduled jobs.

● Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to

groups and grant necessary privileges to the relevant groups.

● Constantly monitor the performance (V$ dynamic performance views at peak load) of

the Databases and viewing Alert log files & Trace files.

● Used to run the scripts to check the status of databases such as growing table sizes,

extent allocation, free space, used space, fragmentation etc.

● Performed space management, capacity planning, disaster recovery and overall

maintenance of the databases.

● Used SQL TRACE, EXPLAIN PLAN utilities for optimizing and tuning SQL

queries.

● Maintained the data integrity and security using integrity constraints and database

triggers.

● Provided 24X7 supports for all the production and development databases.

Micro Electronics INC 2006 to 2008

Computer Customer Service Tech Support

• Perform basic diagnostics on customer computer on the Spot

• Trouble shoot computer Hardware problems with PC Check software

• Perform Backup and recovery for customer’s DATA

• Upgraded Perform virus and malware removal and installing and updating antivirus and

anti-customer’s computer hardware and software.

• Assist customers to configure printers and other peripherals.

TOOLS USED

Oracle 10.2.0. RAC, Oracle Streams, DBMS STATS, RMAN, Data Pump, SQL TRACE,

EXPLAIN PLAN, SQL TRACE.

Contact this candidate