Dave Riggle, MCSE, MCDBA, OCA, OCP, MCP, MCTS, MCITP

Jacksonville, Florida

Cell 904-***-**** Work 904-***-**** Home 904-***-****

ab9nbw@r.postjobfree.com

QUALIFICATIONS:

. 40 years of IT experience

. 8 years as DBA Team Lead

. 14 years with SQL server database administration (NT 7, 2000, 2005,

2008).

. 14 Years with SQL development using SQL BI tools (SSIS, SSRS, SSMS,

SSAS, DTS, SQL Profiler, SQL Tuning wizard, SQL Execution plan).

. 12 Years of experience with High Availability and Disaster Recovery,

using replication, log shipping, mirroring and MS clustering

. 8 Years with Oracle server database administration (9I, 10G, 11G).

. Strong in Performance tuning, normalization, data modeling,

transformations, mapping, device allocation, quality controls, data

validation, security, and documentation.

. I am a self-motivated team player with excellent verbal and written

communication skills

. I have a proven record of team leadership, technical, performance-

tuning and analytical problem solving skills.

. I am confident in my ability to develop, implement, and maintain both

MSSQL and Oracle environments, to the highest standards.

SKILLS:

TSQL MS SQL Server SQL Development

T-SQL Development Database Administration Data

Architecture

Replication Log Shipping Mirroring

Performance-tuning MS Clustering MS server

Database design Data encryption SQL mail

Database mail BI SSMS

SSRS DTS SSIS

SSAS DDL ETL

.Net IIS FTP

Active Directory Citrix Oracle

SQL/Plus Toad CommVault

PL/SQL RAC OEM

OMS OID Grid Control

MS Office Lotus Notes Siebel

VBA Excel Access

HP storage Linux Toad

HTML SCAN Jira

Putty WinSCP Xming

Remedy Erwin McAfee

OneShield Insurity GuideWire

Hp storage Visio powerpoint

EXPERIENCE:

The Main Street America Group Jacksonville, FL 5/2010 -

Present

Manager Database Administration/Development

SQL Responsibilities:

. Developing, implementing, and maintaining database high availability

strategy

. Design and manage ETL database extraction processes. (DTS & SSIS)

. Created reports, as needed using SQL Reporting Services (SSRS)

. Database performance tuning, analysis and optimization

. Manage database backup and recovery operations.

. Manage database security model using proven methodologies.

. Perform data modeling and script changes.

. Create, Tune, and debug SQL tables, queries, stored procedures, and

triggers.

. Maintain database capacity planning.

. Perform new installations of SQL server and upgrades (2000 to 2005

and 2005 to 2008).

. Created custom deployment process for Tier rating project

. Created ETL jobs to import billing and claims data to ODS for Tier

rating

. Created over 200 documents and WebEx videos.

. I Identified 25 SQL issues and have corrected over 90% of them

. Upgrade all SQL 2005 servers to latest service package SP4.

. Maintained DBA rotation List

. Created a list for server, databases and owners.

. DBA support in the application and operational environment

. Review databases and coordinate changes during deployment.

. Comvault Backups

. Deployments to DEV,QA,QA2,and UAT

Oracle Database Responsibilities:

. Installation and configuration of Grid Control 11g

. Comvault Backups for Oracle

. Deployments to DEV,QA,QA2,and UAT

. Maintain database capacity planning

. Developing, implementing, and maintaining database high availability

strategy

. Database performance tuning, analysis and optimization

. Perform new installations of ORACLE 10g and 11g

. Comvault Backups

. Deployments to DEV,QA,QA2,and UAT

Storage Responsibilities:

. Manage storage equipment.

. HP P-1000

. HP P-2000

. HP EVA-5000

. HP EVA-8000,8100

. HP P-9000, 9500

Projects:

. Rewrite SSIS ELT process for Merlin Database

. Created new SSIS ELT process for Tier Rating Project

. Created New process for Tier Rating Deployment

USMC/CSC/CPAI Kansas City, MO 11/2009 -

5/2010

SR. Database Administrator/Developer

SQL Responsibilities:

. Developing, implementing, and maintaining database high availability

strategy

. Design and manage ETL database extraction processes. (DTS & SSIS)

. Created reports, as needed using SQL Reporting Services (SSRS)

. Database performance tuning, analysis and optimization

. Manage database backup and recovery operations.

. Manage database security model using proven methodologies.

. Perform data modeling and script changes.

. Create, Tune, and debug SQL tables, queries, stored procedures, and

triggers.

. Maintain database capacity planning.

. Perform new installations of SQL server and upgrades (2000 to 2005

and 2005 to 2008).

. DBA support in the application and operational environment

. Review databases and coordinate changes during deployment.

Oracle 10g Database Responsibilities:

. Installation and configuration of Grid Control 10g

. Backup for Oracle DBA's

Scriptpro Mission, KS 9//2005 -

10//2009

Lead. Database Administrator/Developer

SQL Responsibilities:

. Developing, implementing, and maintaining database high availability

strategy

. Design and manage ETL database extraction processes. (DTS & SSIS)

. Created reports, as needed using SQL Sever Reporting Services (SSRS)

. Setup high availability using Microsoft Clustering

. Testing of data warehouse environment (SSAS)

. Database performance tuning, analysis and optimization

. Manage database backup and recovery operations.

. Manage database security model using proven methodologies.

. Perform data modeling and script changes.

. Design and implement database modules such as full text search, large

volume database updates.

. Create, Tune, and debug SQL tables, queries, stored procedures, and

triggers.

. Implement monitoring and alerting. (SQL Mail and Database Mail)

. Maintain database capacity planning.

. Design and setup of database replication strategies

. Setup database mirroring and log shipping as needed

. Perform new installations of SQL server and upgrades (2000 to 2005

and 2005 to 2008).

. DBA support in the application and operational environment

. Review databases and coordinate changes during deployment.

Oracle 9i/10g/11i Database Responsibilities:

. Operations team lead, developing, implementing, and maintaining

server upgrades and patches.

. Setup security, recovery, backup procedures, and space management

. Installation and configuration of Grid Control 10g.

. Lead a 4 man team to install and configure of Oracle EBS.

Huhtamaki Desoto, KS

1/2002 - 8/2005

Database Administrator/Developer

SQL Responsibilities:

. Developing, implementing, and maintaining database high

availability strategy.

. Design and manage database extraction processes. (DTS)

. Database performance tuning, analysis and optimization

. Manage database backup and restores

. Improve database security model using proven methodologies.

. Design and manage database extraction processes.

. Implement monitoring, alerting and capacity planning.

. Design and setup of database replication strategies

. Perform new installations of SQL server and upgrades (2000 to

2005).

. DBA support in the application and operational environment

Citrix Server Responsibilities:

Developing, implementing, and maintaining applications and web interface

server.

FTP Server Responsibilities:

Creating & maintaining user accounts & folders.

Security Responsibilities:

McAfee E500 appliance and the EPO Server

Projects:

. Enterprise rollout of MainSaver software

. Rollout of MSDS software (ELT processes from DB2 to SQL)

. Project on rollout of LabelView software

. Project leader on rollout of PMC2000 software

. Project leader on enterprise rollout of BEST/FAS software

. Project leader on enterprise rollout of NWA software

. Setup check in check out software for machine shop

. Project leader on enterprise rollout of Iwork software

. Project leader on rollout of NetG software

. Project leader on rollout of Franklin trade software

. Project leader on enterprise rollout of Hyperion software

. Setup Citrix MetaframeXP server farm

. Setup secure FTP server

. Project leader on enterprise rollout of ForecastX software

Better Business Forms & Computers Lenexa, KS 2/1984 - 12/2001

IT manager

8 direct reports

H & R Block Lenexa, KS

11/1991 - 03/1998

Sr. Supervisor of Call Center Support

Lead team of 35 direct reports with 3 supervisors

John Deere Company, MO

02/1980 - 02/1984

Computer Operator

McPike INC., MO

02/1979 - 02/1980

Computer Operator

Marley Cooling Tower Company, KS 01/1978 - 02/1979

Computer Operator

USAF, MO

01/1974 - 02/1978

Telecommuications

Staff SGT. Honorable discharge

EDUCATION:

METROPOLITAN COMMUNITY COLLEGE Kansas City, MO

Associate Degree in Computer science

Certifications

MCP

MCSE 2000

MCDBA SQL 2000

MCTS SQL 2005 Database Administrator/Developer

MCITP SQL 2005 Database Administrator/Developer

MCTS SQL 2008 Database Administrator/Developer

MCITP SQL 2008 Database Administrator/Developer

OCA Oracle 9I

OCP Oracle 9I

OCA Oracle 10G

OCP Oracle 10G

Contact this candidate