TECHNICAL SKILLS:

Operating Systems: Windows XP, 2000, 7, Windows Server 2000, 2003, 2008 / 2008 R2, 2012 2012 R2

Databases: SQL Server 6.5, 7.0,2000,2005,2008,2008R2,2012,2014; FoxPro

Languages: TSQL, VB, HTML,,Visual FoxPro 2.x,3,5,6,7,8,9

Applications: SSRS, Red Gate SQL Tools, Idera SQL HeartBeat, Crystal Reports

Technologies: SQL Clustering, SQL Server Replication, Mirroring, Log Shipping, DR,HA, SAN, Virtualized SQL

EXPERIENCE:

Sr. DBA Analyst

Confidential, Raleigh, NC

• Implemented Mirroring for over 100 databases (2 TB) including an automated failover script
• Installed and QA’d SQL Servers in 2005,2008 and 2012 for VMWare, Backup Exec, Veem and other 3rd party software
• Technologies Used in Environment
• SQL Clustering (Active/Passive, Active/Active)
• SQL Replication
• Database Mirroring
• Transaction Log Shipping
• SAN (EMC and NetApp)
• VMWare ESX Hosts
• Custom Monitoring Solution

Principal DBA

Confidential, Durham, NC

• Monitored and maintained complex SQL Server production cluster Millions of transactions per day
• Maintained Replication to multiple reporting environments
• Improved Replication Performance
• Implemented Monitoring of key servers
• Implemented Mirroring for DR
• RedGate SQL Backup
• Managed QA and Development SQL Environments
• Performance Tuned Queries
• Archived Data for Performance
• Improved Dev Process
• Worked with QA to ID bottlenecks and other key issues

DBA Manager/Business Analyst

Confidential, Cary, NC

• Transformed unreliable, organically grown database environment from a system with multiple single points of failure to a redundant and robust system that has true High Availability utilizing Virtualization, SAN Storage and Microsoft Clustering technology
• This Change allowed a 24x7 Business run smoothly and without interruption from unforeseen failures and from routine maintenance.
• Managed DBA Group prioritized tasks and was responsible for entire database environment with 1.5TB of data
• Implemented RedGate SQL Response and Monitor for SQL Server monitoring
• Created Daily, Weekly and Monthly tasks lists to ensure proactive management of entire SQL Environment (Dev, Staging, Production)
• Maintained a 24x7 on call rotation to ensure High availability for 24x7 environment
• Built two SQL Server 2008 Failover clusters on Windows 2008 Servers. This move minimized downtime to less than 2 minutes for many major hardware issues
• Created interim BI solution using SSRS and dedicated SQL Data warehouse
• Reporting solution delivered over 1000 reports a day to various customers and allowed near - real time analysis of campaigns
• Implemented code standards and code review process of all developer SQL Code looking at standards and performance of code.
• Implemented a Change Control policy and procedure to ensure stability that included Business Stakeholder, Technical Review and QA approval to all changes to systems
• Acted as Business Analyst for several major pharmaceutical marketing promotions. These promotions were for TrialCard customers .
• Helped to build IT Team from just one person to a team of over 25 developers and business analysts.

Senior Applications Analyst Programmer

Confidential, Raleigh, NC

• Maintained SQL Server 2000 and 2005 merge replication for customer sites
• Reviewed TSQL and VFP code from all developers for standards and performance
• Taught Custom Software classes as well as Report Writing with Crystal Reports, SQL Primer and Database Design, Disaster Recovery and Planning.
• Analyzed, Designed, Developed Data Exporting modules for multiple import formats
• Analyzed, Designed and Developed GIS Pin Mapping with Routing for entire Suite of products
• Created Object to attach OLE Objects to a database record
• Analyzed, Designed and Developed E-Sign compatible Electronic Signatures
• Created Setup distribution packages for Third Party tools
• Analyzed, Designed and Developed Additional Modules for Product Suite such as Building Systems Inspections and Communication Server including Faxing
• Reviewed and Implemented a Structured Product Build Process utilizing Source Control, Documentation and Tracking of Changes and Bug Fixes

Senior Database Architect

Confidential, Morrisville, NC

• Created, tested and implemented SQL Server 2000 failover cluster
• Migrated production data to temporary SQL 2000 server then to SQL Server Failover cluster
• Automated key data import process utilizing Data Transformation Services Reducing data import errors and time key personnel spend doing data imports

Database Administrator/Applications Analyst

Confidential, Raleigh, NC

• DBA of SQL Server 6.5, 7.0 and 2000 production servers
• Administered ONYX CRM
• Analyzed, Developed and Maintained internal systems that included cost control applications for Purchasing and Travel and Time Tracking systems for Consulting Services
• Integration of ONYX into the HAHT web site in the form of a Customer Self Service Center.
• Custom Reporting on ONYX data via Excel Pivot Tables and Custom Web Interfaces

Applications Developer Consultant

Confidential, Raleigh, NC

• Maintained and modified a Manufacturing Tracking System for Honda Motor Company
• Designed and developed a real time inventory control system for Captive-Aire Systems
• Analyzed, Designed and built a Space Allocation and Rental System for IHFC
• Taught Visual FoxPro 5.0 Classes in the Tech Ed Division at DB Basics

Systems Analyst/Programmer

Confidential, Youngsville, NC

• Designed and Administered SQL 6.5 Server Database and Hardware on NT 4.0
• Designed and Developed an Enterprise Wide Object Oriented Client/Server information system that enabled Captive-Aire to significantly increase their revenue with a 0% increase in administrative staff.
• Wrote OLE Automation software that automated the Quote Generation Process, reducing quoting time from 3 hours to 30 minutes.