Jr Oracle DBA

STANLEY ASANTE

***** ******* **** ******* #*** Ashburn VA 20147

Tell: 804-***-****

**********@*****.***

OBJECTIVES: Looking for Junior Oracle Database Administration position to utilize my

skills and experience in a challenging environment.

SUMMARY OF QULIFICATIONS

Over 4 years of specialized experience in database administration, providing support to

developers, testers, help implementation teams, and maintenance of Oracle 11g, 10g and 9g

databases.

Strong technical experience with exceptional talent in installing, creating databases,

establishing connections and creating other database objects for applications

Allocating system storage and planning future storage requirements for the database system

Modifying the database structure, as necessary, from information given by application

developers.

Enrolling users and maintaining system security.

Ensuring compliance with your Oracle license agreement.

Controlling and monitoring user access to the database.

Monitoring and optimizing the performance of the database.

Planning for backup and recovery of database information.

Maintaining archived data on tape.

Troubleshooting and resolving ORA- errors.

Installation of the Oracle Software on Windows and Linux.

Backup, restore and recovery database using RMAN and Data Pump utilities.

Administer and maintain multi-terabyte Oracle 11G RAC production databases in an

LINUX/UNIX clustered environment and also ensure the availability, performance, recovery

and security of the databases.

Key Oracle Strength

Uses Oracle RMAN as the primary utility for disaster recovery solution through the

•

creation and maintenance of physical backups and also experienced in performance tuning.

Effective storage management datafiles, controlfiles, and logfiles by primarily

•

maintaining the disks assigned to the oracle related files.

Uses Oracle Enterprise Manager Grid Control to manage multiple database instances

•

across multiple systems under my responsibility

Uses Oracle Recovery Manager primarily to manage a backup, restore and recovery plan

•

that includes full and incremental online backups to disk or to tape

Creating primary database storage structures (tablespaces) after application developers

•

have designed an application

Creating primary objects (tables, views, indexes) once application developers have

•

designed an application

Special Computer Skills and Training

Windows – Servers (2003 and 2008) and Vmware Workstations 8,9,10 (Vista and Windows 7 and

8),Oracle VM VirtualBox, LINUX - Red Hat and CentOS, SQL * Plus, Netca, RAC, ASM,

RMAN, Data guard, SQL Loader, DBCA, ADR, Oracle Enterprise Manager (OEM) DB Console,

DBlink, Shareplex, Oracle SQL Developer, Data pump, MS Office Product Suite, R, MiniTab,

Stella, SAS, SPSS,, Paint Shop Pro, Adobe Photoshop

Work History

Chaveran Inc. Bowie, Maryland 09/2010 – Present

Oracle Database Administrator (Intern)

Customers include various companies within and around the State of Maryland. This position

involves fixed high-profile deadline with no database downtime. Position involves database

administration for development, testing and production environments as well as back-end SQL

programming.

• Using Oracle Enterprise Manager (OEM) Grid Control for monitoring and ensuring

database connectivity and availability at all times for both developers and end users.

• Created materialized views as per clients requirements to refresh data for reporting. Using

Oracle Enterprise Manager (OEM) Grid Control for monitoring and ensuring database

connectivity and availability at all times for both developers and end users.

• Responsible for setting up a new development environment including installing Oracle, creating

databases, scheduling backup and recovery, maintenance jobs and patching on the databases.

• Ensuring daily database backups of data and logs are performed, using Oracle Recovery

Manager (RMAN)

• Configuration and installation of Real Application Cluster (RAC) database instances.

• Managing a replicated standby production database using Oracle DataGuard for quick

recovery in case of disaster.

• Installing upgrades, patches and troubleshooting Oracle RAC database performance

(AWR/ADDR).

• Tuned problematic sql statements and improved performance on some sql statements

from 3 minutes to 12 seconds by adding indexes, partitioning tables and adding optimizer

hints.

• Cloning development and testing databases as needed, using RMAN and a backup copy

of production database.

• Regularly monitoring memory or storage space errors and taking necessary action, e.g

shared pool, archive log cleanup, data files, tablespaces.

• Installed and created Oracle databases, tablespaces, redo logs, multiplexed,control files, created

SQL DDL and DML scripts, helped developers in testing their scripts and implementing code.

• Monitoring and administration of database space requirements, increasing flash recovery

space as needed or altering tablespaces and creating data files.

• Responding to remedy tickets and troubleshooting issues arising from customer bug

reports.

• Providing technical support to end-users e.g. user accounts, access privileges

Viasystems Inc, Sterling-Va: 2012-Present

Chemical Maintenance and Analytical Lab Technician

• Worked under good SOP in a heavy and wet- chemistry section of a semiconductor plating

company ensuring that chemical baths were within specification.

• Troubleshooting electroless and electrolytic bath controllers for copper, nickel and gold plating

lines

• Formulated new chemical baths under standard operating procedures for Immersion Gold, Nickel

and Copper Electroless baths.

• Performed analytical laboratory experiments to check for the concentration of inorganic and

heavy metallic components in the chemical baths and making the required additions

• Calibration of chemical line controllers to fall within specification

• Dumping of used chemicals through appropriate heavy chemical waste management techniques

under EPA standards

• Good Knowledge of OSHA and MSDS

Amazon/SMX Sterling, VA 04/2010-09/2010

Database/ Administrative Assistant (contract)

• Responsible for loading and maintaining pos and shipment data used for planning purposes.

Proficient in structure and operations of warehouse.

• Established, maintained, and updated files, databases, records, and other documents.

• Maintained data, and performed routine analyses and calculations in the processing of data for

recurring internal reports

• Coordinated with various staff for operational support activities of the unit in the resolution of day-

to-day administrative and operational needs.

• Provided administrative support for various departments/divisions such as editing and reviewing

articles, coordinating press conferences, and resolving a range of administrative problems and

inquiries

• Operated desktop computer to design, create, and edit company website with a web developer,

as well as managed aspects of the company website

• Scheduled and coordinated meetings, seminars, conferences, events and other similar activities

Home Depot Richmond, VA 03/2008-01/2010

Database Analyst - Merchandise Execution Associate

• Administration of planograms, department reports, surveys, onsite configurations, and inventories

using cooperate database management software and portal

• Execute import and export of various data using RDBMS

• Utilize windows mobile device connected to RDBMS for inventory control

• Responsible for loading and maintaining pos and shipment data used for planning

purposes.Proficient in structure and operations of warehouse

• Conduct monthly survey on new products from vendors to stores using data on company

databases

JAMES RIVER ASSOCIATION, Richmond, VA, 05/2009-08/2009

Environmental Science Intern

• Shoreline restoration

• Habitat restoration

• Maintained a vigil on the river body, monitored its conditions, identified problems

and ensured that solutions are executed properly.

• Researched and helped in formulating or writing Tidings newsletter.

• Maintained rain gardens along the watershed

• Participated and organized workshops

H.G.A Quest Merrifield VA 06/2007-01/2008

• Responsible for loading and maintaining pos and shipment data used for planning

purposes. Proficient in structure and operations of warehouse

• Setting bay to Plano gram, C-maps and executing special projects.

• Packing down, pricing and taking pictures with P.D.A.

• Provided excellent customer service

• Administration of planograms, department reports, surveys, onsite configurations, and inventories

using cooperate database management software and portal

Bloom Store: South Riding Va. 03/2007-01/2008

• Received merchandise and placed them in their respective Shelves and took inventory.

• Interacted with customers to find merchandise in a friendly manner and helped build cordial

relationship with them.

• Provided excellent customer service.

Giant Food: South Riding Va. 12/2006-03/2007

• Checked sales records and inventories in the database.

• Supervised cashiers and approving returns

• Gave daily sale report and prepare weekly schedule.

Education

Virginia Commonwealth University – Richmond/Virginia

B.SC Environmental Science

University of Cape Coast - 2005 Cape Coast Ghana

B.SC Biological Science

References

Provided upon request

Contact this candidate