Oracle Database Administrator

Samuel P. Akyea

***

Compton Avenue, Laurel, MD. Cell: 443-***-****. E-mail: ******@*******.***

Objective:

Database Administrator (DBA) with four years of experience seeking an opportunity to support and contribute

to the company’s objectives with my skills as Database Administrator

PROFESSIONAL SUMMARY

• Database Administrator (DBA) with four years of experience.

• Extensive experience in Oracle Database Administration.

• Working knowledge of Oracle 10g, 11g RDBMS.

• Excellent analytical, research, and problem solving skills

• Highly organized with a focus in prioritizing workload and scheduling follow-ups.

• An analytical approach to problem solving and detail specificity.

• Ability to adapt to changing environment and requirements and manage multiple tasks.

• Displays a high level of energy, integrity and ethics with the exceptional ability to deliver outstanding

bottom line results with short deadlines.

• Excellent verbal, written and organizational skills.

Professional Experience

Uptick Systems, Frederick MD 03/2010 – Present

IT Support Specialist- Oracle DBA (Contractor)

• Installed and Configured Oracle 10g/11g software on Linux.

• Upgraded several databases from Oracle 10.2.0.1 to 10.2.0.4 to 11.2 .0.1

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

• Installed Oracle 10g and 11g on Sun Solaris 10, Linux(Oracle Enterprise Linux 4 & 5,Redhat 5) 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.

• Use RMAN duplicate command to clone/refresh development database from production.

• 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.

• Create databases and documents procedure to migrate and refresh databases between the development

and production environments.

• Used Oracle Transparent Data Encryption to encrypt tables and Tablespaces that contains PII data.

• Use RMAN to perform database recoveries and migration when necessary.

• Used Oracle flashback technology to restore databases and tables as needed.

• 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.

William T. Burnett and Co. (Manufacturing) Jessup, MD 01/09 – 3/2010

Jnr. Database Administrator (Contractor)

• Oracle 10g/11g Installation and upgrading Software and Database

• Created Databases based as requested by sponsors.

• Modify Tablespaces and object storage.

• Exported data from old systems and import into new databases using expdp and impdp.

• Setup backup’s scripts using cron jobs.

• Created Users, assigned Privileges and Roles.

• Managed archives logs and redo logs.

• Created Oracle instances with appropriate initialization parameters.

• Altered, Modified and Created Tables, Views and Sequences

• Documented migration process, database creation, monitors, and load scripts.

• Setup backup’s scripts using cron jobs.

• Created Users, assigned Privileges and Roles.

• Administered backup and recovery using RMAN.

TECHNICAL SKILLS

Oracle 11gR2/10gR2 installation, Database Creation, Patch sets Upgrade, Critical Patch Update(CPU).

Upgrade 10g to 11g, Oracle Enterprise Manager, Data Guard, Performance Tuning.

• Understand database recovery models;

• Experienced running backups under each recovery model;

• Experienced restoring backups, including to specific point in time

OS: Microsoft Window Server 2003/2008. Linux RedHat, CentOS, SQL*Loader

EDUCATION and CERTIFICATION

Frostburg State University, Frostburg, MD December 2011

B.S, Engineering

B.S, Physics

Willing to travel and/or relocate

Contact this candidate