We provide IT Staff Augmentation Services!

Dba Manager/business Analyst Resume

Durham, NC

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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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

Responsibilities:
  • 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.

Hire Now