Sql Server Project Manager

Daniel J. Donovan

**** ******* **** **** ***-***-

2227

Waxhaw, NC 28173 mobile 704-996-

5626

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

PROFILE

Database administrator, architect and technical lead exposed to a variety

of applications within multiple industries. Experienced and proficient

using multiple RDBMs Oracle, SQLServer and DB2. Current database focus is

Oracle.

SKILLS SUMMARY

Application Development Tools: GRID, Oracle Enterprise Manager,

SQL Enterprise Manager

Databases / DB Tools: Oracle 11g, ASM, 10g, 9i & 8i, SQL Server 2003,

2000, V7, V6, DB2 OS 390, DB2 UDB, Sybase

Desktop Tools: MS Office, ER-Studio, DBArtisian, PLSQL

Developer, ER_Win

Hardware: AIX Servers, IBM Compatible Servers and PCs,

IBM mainframes

Operating Systems: Unix, NT, Linux, OS/390

Programming Languages: PL/SQL, T-SQL, Korn Shell

Utilities / Command Languages: Oracle Utilities, RMAN, MS SQL

Server utilities, DB2 Utilities

PROFESSIONAL EXPERIENCE

SSI Schaefer Jan 2011 - Present

Senior Oracle Database Administrator

Environment Summary Oracle 11g, ASM, RAC, Linux

Job Description Summary

* Technical and application support to existing client customer base

Provide performance analysis and enhancement options for OLTP

application

Provide proactive monitoring of database instances using GRID and

other Linux utilities

RAC, GRID and system requirements installation preparation

Carolinas Health Care March 2004 -

December 2010

Senior Database Administrator

Environment Summary Oracle 11g, ASM, 10g, 9i and 8i, DB2 UDB (8.2

and 9.5)

UNIX AIX, Windows 2000, 2003 and 2008R2

Job Description Summary

* Primary DBA support for in house data warehouse application

Devised an Oracle Export/Import plan that reduced source system data

backload time by to the warehouse by 75%

Identified and implemented SQL query rewrites yielding measurable

response time improvements using GRID and ADDM /AWR reports

Mentored Business Object developers in the use performance

enhancements such as Analytic Function, hints and query rewrites to

improve query response time.

Monitor, service, and resolve Oracle database alerts and GRID events.

Created benchmark comparison scripts using common business queries to

anticipate statistics related performance issues

Architected and implemented encryption scheme for loading sensitive

PeopleSoft HR data to data warehouse

Re-model data warehouse application for expansion to 1Tb+.

Converted data warehouse databases to ASM

Implemented table partitioning for high volume Fact tables

Implemented Logon triggers, Fine Grain Auditing, revised and

implemented user access security procedures to address HIPAA

Compliance and Security Framework

* PeopleSoft Application Finance and HR Database Support

Support PeopleSoft technical team during application release upgrades

Database advisor to PeopleSoft application team during data archive

projects.

Performed Oracle database upgrades 8i to 9i, 9i to 10g for PeopleSoft

HR and Finance applications

Prototyped, authored and presented to management Physical Standby Data

Guard database proposal for PeopleSoft Human Resources and Finance

application to enhance 24x7 availability

Demonstrated, documented and mentored application developers in the

use of Analytic Functions to improve query response time.

Verified RMAN backup/restore scripts using RMAN duplicate for

production to test replication

Created Oracle report procedures for use by PSoft Finance developers

* Third party Clinical Application Database Support

Performed Oracle database upgrades 8i to 9i, 9i to 10g along with

application upgrade

Created views for application team for reporting and online

application information

Created Project Management chart for application and database upgrade

from 9i to 10g

Consultation with vendor altered database metadata to improve

performance

* Data Modeling quality assurance

Installed and tested Oracle Warehouse Builder for performance testing

vs. Informatica

Collected data requirements for ER_Studio ERD model created logical

and physical models

Wrote quality assurance scripts to compare ETL documents to model and

model to physical database objects and generate STAR Schema DDL

Designed and implemented an ODS (Operational Data Store) for end user

evaluation

Reverse engineered SQL Server databases for presentation to data

analysts project teams

* Perform backup and recovery planning

Created and tested Point-in-Time RMAN recovery scripts for disaster

recovery scenerio

Wrote/modified Korn shell scripts to facilitate common DBA monitoring

jobs

Participate in on-call production support rotation

* DBA Support for IBM/Tivoli applications

Expanded UDB knowledge to support multiple IBM Tivoli applications

Online backup recovery using TSM

Installation and database upgrade

Keane, Inc./Metro Information Services June 2002 -

February 2004

Royal & SunAlliance June 2002 - January 2004

August 1998 - February 2001

Senior Database Administrator/Principle Consultant

Environment Summary Oracle 9i and 8i, SQL Server 2000, OS/390 DB2 v5 and

v6 HP UNIX, Windows 2000 and 2003

Job Description Summary

* Multi-platform Database Administrator using Oracle, MS SQL Server, DB2

and Sybase

Installed and tuned Star Schema Oracle 9i 1Tb+ Operational Data Store

Performed multiple Proof-of-Concepts trials for database conversion

from Sybase to Oracle

Extracted system of record DB2 data to MS SQL Server for ad-hoc query

reducing OS/390 CPU charges

Performed installation analysis and Prototype design DB2 Stored

Procedure implementation

Re-designed and implemented SQL Server 2000 conversion effort using

DTS packages

Performance tuning analysis and implementation for DB2 queries

The Vanguard Group February 2001 -

June 2002

Architect/ Senior Database Administrator

Environment Summary Sun Solaris UNIX, Windows 2000, Oracle 8i and

9i

Job Description Summary

* Architect and Database Administrator for a 1Tb+ Oracle Parallel Server

Data Warehouse

Designed and prototyped the Unix Korn scripts for loading daily

System-of-Record extracted data

Partitioned, mapped and implemented physical database from test

through production

Wrote PL/SQL procedures to automate and manage partitioned

tablespaces

Tested and verified automated backup/recovery scripts (pre RMAN)

* Technical Lead

Worked with application reporting team to optimized queries for

throughput

Prototyped SQL Loader scripts for quick load

* Provided DBA support on existing MS SQL Server applications

Designed and migrated SQL application from R6.5 to 7.0 including the

strategy to utilize NT integrated security

Various Independent Consulting Engagements prior

August 1998

Independent Consultant

* Microsoft's Solution Provider program Participant MS SQL Server 4.2, 6.0,

and 6.5

Completed extensive coding and testing of Transact-SQL stored

procedures, triggers, rules and defaults, built the backup/recovery

procedures and tuned database Server for maximum responsiveness

Acted as interim NT administrator

* Project manager

Lead 4 month project beginning with technical sales call, project plan

definition and bid submission

* Technical manager

Supervised management reporting and technical specifications required

to modify existing client/server application code written in C using

MS-Windows 3.0 SDK

* Database Architect/Technical Leader for point-of-sale client/server

project

* Sr. Database Administrator

Converted database access programs from 16 bit to 32 bit architecture

Database expertise across multiple OS/390 DBMS solving client problems

in mission critical high visibility databases

Designed a custom unload / reload utility for an IDMS customer

information application which did not lend itself to standard Cullinet

unload/reload utilities

CONTINUING EDUCATION

Project Management CPCC

Oracle Performance Tuning Oracle University

Optimizing Oracle SQL Intensive Hotsos

CERTIFICATIONS

MCP 1998 SqlServer NT

EDUCATION

MS Mathematics Lowell Technological Institute Lowell, MA.

BA Mathematics St. Michael's College Winooski, VT

Contact this candidate