CHRIS DOLAN

** ******* *** ****: 603-***-****

Hampton, NH 03842 USA dacwaf@r.postjobfree.com

_____________________________________________________________________________________________

PROFILE

SENIOR ORACLE DBA expert with 13 years experience who makes databases go fast by achieving the following: installations, configurations, creations, patchings, migrations, upgrades, audits, backups, disaster recoveries, performance tuning, storage structures, documentation, startup/shutdown, high availability, troubleshooting, system analysis, schema objects, database design, physical disk storage, user accounts and security, change control management and documentation on Windows, UNIX & Linux platforms.

_________________________________________________________________________________________________

EXPERT IT SKILLS

• UNIX Solaris, HP/UX and AIX plus Linux (SuSe and Red Hat) and Windows

• ORACLE7x-11g, SQL*Net, Net8, RMAN (hot, cold, imp/exp, datapump)

• ORACLE tuning, SQL tuning, troubleshooting and problem solving

• ORACLE SQL, PL/SQL, SQL*Plus

• Erwin, PowerDesigner, Toad DataModeler and ORACLE SQL Developer

• Scripting: shell, bash, ksh, csh

• Certified TUSC Instructor (SQL, PL/SQL & ORACLE Database Performance Tuning), ORACLE11g DBA OCP Candidate

_____________________________________________________________________________________________

EMPLOYMENT HISTORY

• 2001 to Present - SENIOR ORACLE DBA, Northshore Enterprises LLC,

Hampton, NH

• 1998 to 2001 - SENIOR ORACLE CONSULTANT, ORACLE Corp,

Redwood Shores, CA

• 1996 to 1998 - ORACLE DBA, Northshore Enterprises LLC, Hampton,

NH

_____________________________________________________________________________________________

EDUCATION AND TRAINING

• MBA Finance: Master of Business Administration, Southern New Hampshire University Graduate School of Business, Manchester, NH

• BBA Accounting: Bachelor in Business Administration, University of Massachusetts, Amherst, MA

• Peoplesoft8 Certified Technologist, Peoplesoft Bootcamp, Pleasanton, CA

• ORACLE11g DBA OCP Candidate, ORACLE Education Center, Burlington, MA

• ORACLE DBA Masters Certificate, ORACLE Education Center, Boston, MA

• Peoplesoft & ORACLE student who attended 15 classes at ORACLE Education Centers

_________________________________________________________________________________________

PROFESSIONAL WORK DETAIL

Senior Oracle DBA - 2001 to Present

Northshore Enterprises LLC, Hampton, NH

EDELMAN, Chicago, IL

Performed a Healthcheck on clients Oracle10Gr2 database on RHEL (Linux) server that included the following: Executive Summary, Database/Application Observations, Security, Backup and Recovery, Core Configuration, General Maintenance Activities, Daily Procedures, Weekly Procedures, Quarterly Procedures, Infrastructure Checks, User Management, Performance Tuning, Monitoring, DB Configuration, DB Specific, Resource Intensive SQL Analysis, Database Wait Analysis, Architecture Scalability, Database Tier, Recommendations, Architecture Availability, Use of Data Guard, Backup and Recovery, PS Performance Tuning Tips, Server Performance, Web Server Performance, Java Performance Management, Tuxedo Performance Management, Application Performance, Database Performance, Indexes, Performance Monitor, Storage Performance, CPU Performance, Queries, Tempdb, Servers and Memory Allocation

AMERICAN AGRICULTURAL INSURANCE COMPANY, Chicago, IL

Installed Oracle 10.2 in the development environment, Applied all current patches, Migrated copy of production data into development environment, Provided documentation of all installation and patch steps. Performance tuned & setup backup & recovery schemes.

NORTH AMERICAN LIGHTING, Paris, IL

Implemented 10gR2 on SuSe Linux to help setup, knowledge sharing and migration of 200GB database to their development environment. Provided documentation of all installation and patch steps. Performance tuned & setup backup & recovery schemes.

BLUE CARE NETWORK, Southfield, MI

Tuning, troubleshot Oracle10g databases & provided documentation of all Oracle10g installation and patch steps. Performance tuned, setup backup & recovery schemes & tuned poor performing SQL statements.

HARVARD UNIVERSITY, Cambridge, MA

Assisted the Lead DBA at Harvard to resolve the Windows Scheduling problems

NORTHERN TRUST, Chicago, IL

Customer is migrating database from Sybase to Oracle. I wrote a discovery document that detailed the process to convert 9 Oracle Tables along with Stored Procedures from Sybase to Oracle using shell scripts. Included in the Discovery Document was the resources & number of hours and timelines to complete the migration. Platform is Oracle9i/10g & Sun Solaris (UNIX).

TUSC TRAINING, Lombard, IL

Taught 4 Oracle Classes at TUSC Training Center: 1. Performance Tuning 2. SQL and SQL*PLUS

SUNGUARD/UPSTREAM, Schaumburg, IL

Restored customers Oracle database to point in time where customer was able to recover necessary data to continue business. This customers database was down for TWO MONTHS and I restored it in ONE DAY! Also involved in tuning/troubleshooting issues. Platform is Oracle9i & Solaris (UNIX).

COMCAST, Philadelphia, PA

Installed, created & managed 5 Oracle 10g databases; development/production oracle DBA on Sun Solaris 10 software and hardware.

MDA FEDERAL, Rockville, MD

Cold backup of a 5 terabyte Oracle 10.1.2.0.2 database (source) on Linux x86-64 server, created new database (target) on separate Linux server, copied source to target, recreated control file; tuned troubleshot separate database using Statspack on Oracle 9.2.0.4 database on Solaris 10 server. General Health check of entire IT architecture.

LOCKHEED MARTIN, Endicott, NY

Installed, configured and managed Oracle10gR2 database 10.2.0.2 on Solaris10 and Application Server Release 10.1.2.0.2 (MidTier & Infrastructure) on Solaris 10 using zones. Migrated 9.2.0.6 to 10.2.0.2 database using database upgrade assistant. Documented all of this work in detail.

TIMBERLAND CORPORATION, Stratham, NH

Managed, maintained, backed up & tuned 30 Oracle8.x & 9.x databases on Windows 2000 (13 databases) and Unix (17 databases) on RS6000/AIX OS 5.2.0.75 Windows 2000, x86, SP4.

DYNAMICS RESEARCH CORPORATION, Andover, MA

Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of the company database (test, development /production), ie backup & recovery, RAC (test & development), Dataguard (test, development & production) and RMAN. Creates, implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues. Familiar with standard concepts, practices, and procedures within Oracle. OS: Windows Server 2003; Oracle 9i & 10g

FNB MORTGAGE CORPORATION, Vienna, VA

Installed, configured & administered Oracle10g RAC on Windows 2003 on (2) Dell 2950 with 2 drives in a mirrored configuration (2) Fiber Switches (Dom 1, Dom 2), (1) SAN w/ 14 73GB drives. (5 drives RAID 5 for backup, 4 drives RAID 10, 4 drives RAID 10, 1 drive as hot spare).

GLOBAL RELIEF TECHNOLOGIES, INC, Portsmouth, NH

Administered, maintained, developed and implemented policies and procedures ensuring the security and integrity of the company database. Installed/Setup Oracle RAC on 9i database. Implemented data models and database designs, data access and table maintenance codes; resolved database performance issues, database capacity issues, replication, and other distributed data issues. OS: Windows 2003

DEPARTMENT OF NAVY, NAVSEA, Portsmouth, NH

Installed, upgraded, migrated, patched and configured Oracle 8174 RDBMS in a UNIX Solaris environment, maintained database security and user account management, performed Database Audits, implemented backup and recovery processes, performance tuning & troubleshooting, team player with ability to multitask with minimal supervision and high reliability, Strong drive to learn, Problem Solving attitude, Excellent oral/written communication skills, Knowledgeable of the Oracle 11i Applications, documented all work for staff. OS: Windows 2003 & UNIX.

Senior Oracle Consultant - 1998 to 2001

ORACLE/PEOPLESOFT CORPORATION, Redwood Shores, CA

Responsible for supporting the Oracle 8.1.7.4 & Peoplesoft 8.4 implementations. Provided database installation, configuration management, performance tuning and documentation, application maintenance issues such as program fixes and patches and change management. Production/Application DBA experience in Oracle (7.x, 8.x, 9.x), UNIX (Sun/HP/AIX/Linux), Intel 2000/2003; Systems/Network Administration, Web/Application Server Administration focused on installing, upgrading, migrating, patching, performance tuning, backing up & recovery, SQL tuning, documentation, understands RAC, Dataguard, Streams and maintenance of Oracle database servers, application servers. Planned the logical/physical structure and design of a database using tools such as entity relationship diagrams, TOAD & Designer 2000. Created databases and database objects, database security, created interfaces and reports to input and view the data respectively. Proficient with Oracle tools (OEM). Worked with over 20 clients in 3 years with Oracle.

1996 TO 1998 - SENIOR ORACLE DBA, Northshore Enterprises LLC, Hampton, NH

Worked with 25 clients using Oracle 7.x-8.x installing, configuring, creating, patched, migrated, upgraded, audited, backed up, recovered, performance tuned, arranged storage structures, documented, startup/shutdown scripts, high availability, troubleshooting, system analysis, schema objects, database design, physical disk storage, user accounts and security, change control management and documentation on Windows, UNIX & Linux platforms.

Contact this candidate