Charlene Tracy-Ann Mckenzie

**** ****** ****

Greenbelt MD 20770

Phone- 202-***-****

Email: ac01f0@r.postjobfree.com

ORACLE DATABASE ADMINISTRATOR

PROFILE

Seeking to obtain a challenging position that will utilizes my skills as a trained Oracle DBA. Possess excellent leadership, problem-solving, decision making and communications skills. Set realistic priorities and initiate viable courses of action to attain objectives and able to meet critical deadlines. I am competent in administering databases on Microsoft Windows Platforms, RHEL and Solaris platforms. I have great understanding of backup and recovery strategies using (RMAN) to insure database recoverability and availability. I am outstanding in data quality, integrity, logical and problem resolving skills.

Technical Skills

Proficient in Oracle 10g and 11g, 12c Database Administration

Proficient in Enterprise Manager

Proficient in Database Migration, Upgrade and Patch Application

Performance Tuning

Real Application Clusters

Data Guard Administration

Operating Systems: Windows server 2008, RHEL 5&6

System Tools: SQL, DBCA, NETCA, RMAN, SQL Developer, Enterprise Manager,

Microsoft Office (specializing in: Power point, Access, Excel, Word), SSH, Oracle Universal Installer, Oracle VM Virtual Box

PROFESSIONAL WORK EXPERIENCE

Pepco Holdings Inc, Washington DC

Oracle Database Administrator May 2014 - present

Planning, installation, configuration, management and troubleshooting of Oracle 11g and 12c databases on Linux and Windows OS.

Installed and managed (OEM) Oracle Enterprise Manager.

Installed and configured relevant network components to ensure database access as well as database consistency and integrity.

Troubleshoot and resolve various Oracle connectivity problems.

Create and manage documentation on the configuration and support of the Oracle databases.

Perform bulk load into the database using SQL Loader.

Perform standard and fine grain database auditing.

Documented database structure, changes, problems, issues for future reference .

Administer database user accounts. Create, modify and deactivate user accounts; assign and monitor user access rights.

Created Testing and Development databases following OFA compliance rules.

Provide database administration on production, testing and development database servers.

Managing Schema Objects.

Regular Monitoring Alert log Files and trace files on Day to Day Basis.

Identifying and removing Fragmentation, row migration/chaining of database objects.

Analyzing the Tables and Indexes on performance base regularly.

Monitoring Tablespaces and Data files utilization.

Managing Undo Tablespaces, Redo Logs, Control files and Archive logs.

Implemented multiplexing control files and redo log files.

Configuring various RMAN parameters as per the requirement.

Performing physical backups using RMAN utility.

Identify and recover the corrupted db blocks using Block recover option in RMAN utility.

Performing Complete Media Recovery of Database depends on the nature of failure.

Configure and implement the use of Oracle Recovery Manager (RMAN) for cold and hot backup to the databases.

Extensively using DATAPUMP and Export /Import utilities for logical backups.

Performing database cloning using RMAN.

Total Wine and More Bethesda, MD Senior Accounts Payable Specialist Jan 2013 – April 2014

Handle monthly and quarterly closing entries.

Processed invoices for payment within an automated environment, ensuring accuracy, timeliness, and proper coding.

Trained Junior Accounting Clerks on Processes and Policies about the company.

Ensured that invoices submissions are in compliance with company requirements.

Uploaded invoices from Access and Excel into Lawson Accounts Payable.

Prepared supporting documentation in batches for review by a supervisor.

Mailed checks payments to specified Vendors across 13 states in the US.

Log activities and exceptions into a database.

Handle AR and AP Journal Entries and GL reconciliations.

Followed up with vendors, store managers, and other employees to resolve open issues and discrepancies.

Handled Accounts Payable Help Desk inquiries within set timelines.

Assisted team members, as needed, to meet all department deadlines.

Other duties as assigned as required by Top management.

BWW Law Group Bethesda, MD

Accounts Payable Clerk Jan 2012 – Dec 2013

Receive and verified all invoices of publications for MD, VA, foreclosures.

Prepare batches of invoices for data entry.

Verifying expense reports and requests for advances; preparing checks.

Completes payments and controls expenses by receiving, processing, verifying, and reconciling

Invoices .

Education

University of Maryland University College (UMUC) Adelphi, MD

Pursing B.A., Computer Science 2014-Current

Professional Training

Oracle DBA OCA & OCP - Boltos Solutions Inc Laurel, MD

August 2013- Jan 2014

Contact this candidate