AddThis Social Bookmark Button
Cherie Collins ( Available )
Mckinney, Texas - 75070 USA
Expertise :Oracle Database Administrator, Oracle Architect, Oracle Analyst
Status :Citizen
Job Type :
All - W2,1099
Position :Computer Software Engineers, Applications, Computer Software Engineers, Systems Software, Computer Systems Analysts

Resume
 
Summary




Versatile IT professional with experience in software analysis and database administration. Record of performing well in call center, quality assurance and development environments. Effective communicator and resourceful problem solver. Adept at interpreting business needs and creating effective solutions. Analytical, conscientious and committed to excellence.


Employment

November, 2002 -  November, 2008
Senior Support Analyst

II
Project team member with QA/Systems and Programming staff to manage project schedules, design and build databases. Upgrade, tune, monitor availability and perform maintenance on 250+ databases.
Performed security administration, adding and removing users while giving access to levels of use.

Provided direction and advice to support specialists and analysts on policies, procedures, plans and activities.
Tested, verified and resolved defects in finished products and update patches.
Modified, customized table structures, forms and views in databases. Index rebuilds and recompiles on relational databases. Installed, setup and configured databases, software and performed productions backups, restore and recovery operations on failed databases.
Application Development
Troubleshoot and created solutions and reports to complex product-related issues.
Contributed to software maintenance release planning.
Planned and delegated application design, development and maintenance.
Recommends input for selection of beta sites and participation. Verified release notes and product specifications. Anticipated obstacles and suggested business solutions to management.
Developed, administered and communicated FAQ s and TSB Technical Support Bulletin documents for NSP Network Service Providers and internally documented standards with support and management.
Tested and recommended new products to increase functionality, product usability and supportability.
Served as chief technical officer of the OMSComp product, managing daily operations, supporting system infrastructure and executed priority software sensitive database development upgrades, OLTP.
Continuously assessed business needs, determined solutions, oversaw testing of new technologies and evaluated test results to facilitate product enhancements and advancement of product knowledge.


May, 2001 -  May, 2002
Computer Specialist

Technical Support Level II

Supported general public and staff division wide conducting management system testing and other testing concerning internet applications. Configured email accounts, diagnosed and resolved DSL connectivity issues.


May, 1999 -  May, 1999
MicroComputer Specialist

Internship
Provided comprehensive hardware/software services, support for 350+ users, installations, upgrades, troubleshooting and development of technical strategies.


June, 1998 -  June, 

Major : Systems Engineering




Education

Techskills of Dallas Dallas , Texas 11/2008 Current
Certificate : Database Administration Linux+ , OCA Oracle 10g I , OCP Oracle 10g II
Old Dominion University Norfolk , Virginia

Bachelor of Science : Biology/Chemistry , 2002
UNIVERSITY OF VIRGINIA
Charlottesville , Virginia



Training

4 Linux+
4 Oracle 10g I Certified Associate OCA
4 Oracle 10g II Certified Professional OCP

TECHNICAL
TECHNICAL
Implementations and Upgrades User Training and Trainer Support Back-Ups and Restorations RMAN
Created users assigning default tablespaces , quotas , roles and profiles .
Used ADDM Automatic Database Diagnostic Monitor to monitor , analyze data and identify potential performance issues .
Managed database performance by collecting performance statistics and reports with AWR Automatic Workload Repository capturing wait events and resource intensive SQL statements , object usage stats and system and session stats . Tuned SQL statements using the SQL Tuning Advisor Tool . Identified segments with unused space and reclaimed segment space using the tool segment advisor .
Used OEM to set database availability states to receive notifications on metrics and policy settings .
Used RMAN to perform backups and recover . Flashback feature used to restore from errors .
Oracle Flashback Version Query , Rollback , SQL , PL/SQL , SQL coding familiar , ASM . RAC , SAN , Veritas , partition and replication interested in becoming familiar .