CORE COMPETENCIES:

• Performance & Tuning
• Database Standards
• T - SQL Coding
• ETL Development (DTS/SSIS)
• Problem Determination & Resolution
• Database Design

CAREER HIGHLIGHTS:

Confidential, Raleigh, North Carolina

Staff Database Engineer/Team Lead

Responsibilities:

• Currently developing process to split multi-tenant databases utilizing Change Tracking feature of SQL Server.
• Assist SQL Developers with design and development of code for various projects.
• Successfully worked with Operations and Engineering teams to migrate database platform to AWS dedicated instances.
• Led daily SCRUM standup meetings to ensure development sprints are completed successfully.
• Have performance tuned over four (4) dozen stored procedures resulting in an overall wait time reduction of 80%.
• Created and implemented a partitioned table for company’s activity log, utilizing a sliding window technique to only keep the last 3 months of data within SQL Server.
• Help manage and assign new projects and tasks to the team as priority dictates.
• Implemented coding standards and naming conventions for SQL objects.
• Reduced SQL code implementation times from hours to minutes with the use of the Red-Gate Tool Suite.
• Working with DBA staff to capacity plan future database growth.
• Successfully migrated & upgraded Analytics reporting environment to SQL 2012 Server.
• Mentoring junior development staff on an as needed basis.
• Implemented and Administer SolarWinds DPA SQL monitoring tool.
• Work with Analytics team on maintain and design ETL processes for on-going reporting needs.

Confidential, Raleigh, North Carolina

Senior Database Administrator

Responsibilities:

• Managed AWS SQL 2012 Server installations, which, maintaining backups, mirroring for HADR purposes and upgrading and installing new servers.
• Trained Junior DBA to assist with day to day workload.
• Participated in code rollouts
• Worked with developers to improve performance of SQL code.
• Upgraded several instances of SQL 2008 to SQL 2012, minimizing the downtime through the use of database mirroring.
• Migrated data to AWS in Ireland from AWS Virginia with minimal downtime for one of the company’s larger clients utilizing log shipping and Powershell scripts.

Confidential, Durham, North Carolina

Database Administrator

Responsibilities:

• Provided around the clock support for both Confidential and Confidential Nephrology solutions.
• Successfully implemented Red Gate SQLTool Belt Suite into the environment. Utilizing SQL Backup Pro 6.5, I was been able to cut the backup times for Confidential from 7 hours per instance to under 2 hours each. Implementing this process also reduced the backup disk footprint by over 400GB.
• Confidential application utilizes 25 user databases currently totaling over 700GB of space and running in production on a 3-node Active/Active/Passive cluster running SQL 2005.
• Maintained Disaster Recovery site for Confidential utilizing asynchronous mirroring.
• Responsible for Database change control standards and code installations to staging and production.
• Utilizing Confio Ignite Monitoring product to assist in problem resolution and performance tuning.
• Converted Confidential databases from a single tenant to a multi-tenant model. The databases were built on SQL 2008R2.

Confidential, Tampa, FL

Senior SQL Server Consultant

Responsibilities:

• Was Lead DBA for Datamart project built on SQL Server 2005. Mentored Junior DBA to assist with support.
• Developed star-schema design for data warehouse pilot. Type 2 Slowly Changing Dimensions were utilized to demonstrate historical reporting. Reports were designed utilizing SSRS 2005.
• Designed and implemented Reporting Services reports to replace current ad-hoc reporting solution maintained by Asset reporting subject matter experts.
• Successfully migrated Datamart databases from single server to two-node SQL Server 2005 active/active cluster for both testing and production. The number of databases migrated were eight, totaling over 90GB of data.
• Created and maintained SSIS Packages which pulled data from numerous data sources including Oracle, DB2, PostgreSQL, SQL Server and Flat Files. Packages are dynamic in nature, reading variables from XML configuration files. Number of packages stood at over forty (40).
• Created a DB2 trigger-based history tracking system for managed server data.
• Developed and implemented a datamart for a third party application called Mazu. This application monitored network traffic. It was built in SQL 2000 and utilized distributed partitioned views and dynamic DTS packages for data loads.
• Developed reports and provide production support for Blazent Analytics application. This application utilized Microstrategy Intelligence Server as the analytics (BI) engine.
• Developed ETL processes, which loaded the Oracle 10g Blazent instance. ETL Code was developed using a combination of PL/SQL and SSIS.

Confidential, Tampa, FL

Senior SQL Server Consultant

Responsibilities:

• Lead DBA and SQL Developer for Receivables Management system known as iFinals.
• Implemented iFinals databases using a federated database model. Data size of iFinals was over 400GB. Databases were installed in a SQL 2000 multi-instance cluster configuration.
• Assisted with SQL development and implementation of X.5C application. X.5C provides data to various systems via the use of .Net Web Services. System handled approximately 1 million transactions per day. X.5C data utilized approximately 1 terabyte (TB) of disk space.
• Developed, implemented and automated RAMP export process for X.5C, which created export files for use by Wholesale users. Data was used for revenue assurance purposes.

Confidential, Lakeland, FL

Senior Database Administrator

Responsibilities:

• Provided production and development support for large a corporate SQL Server infrastructure.
• Worked with project team to successfully implement BizTalk Server 2002 for the enterprise. Databases resided on a multi-instance cluster.
• Built and maintained four (4) multi-instance SQL Server 2000 Database clusters.
• Assisted primary DBA in support of over 700 installations of SQL Server 7.0 in retail stores.
• Provided support for databases, which ranged in size from a few hundred MB to over 200GB. Databases were utilized in a distributed web environment.
• Worked closely with project team to implement Veritas NetBackup for database backups.
• Participated in enterprise disaster recovery design, documentation, and testing for SQL Server.
• Designed and implemented customized log shipping process in SQL 7.0 for the dairy plant.

Confidential, Columbus, Ohio

Consultant

Responsibilities:

• Provided complete SQL Server database support for state government agency.
• Successfully implemented two (2) instances of SQL Server 2000.
• Lead DBA on four (4) installations of SQL Server (7.0 and 2000).
• Administered and supported client’s installation of Microsoft Project Central Server 2000.
• Migrated instance of SQL Server 6.5 to 7.0 onto new Windows 2000 from NT4 server on separate domain. Server was responsible for CA’s Unicenter TNG products.

Confidential, Tampa, Florida

Partner

Responsibilities:

• Provided Complete Web/Database solutions for small to midsize companies.
• Developed DTS packages and stored procedures for client’s web based data mart project known as Gross Margin Viewer. The team successfully delivered the project on time and under budget.
• Provided production database support for client’s SQL 7.0 and Sybase 11.9.2 installations.
• Assist in development of client’s web sites utilizing ASP 2.0.
• Utilizing ERwin, designed backend web database schema for dynamic generation of web content.

Confidential, Tampa, Florida

Consultant

Responsibilities:

• Provided production database support for multiple SQL Server installations for client.
• Created server performance reports utilizing perfmon for client’s major production systems. Reports were used to assist the production DBA team to tune systems.
• Worked with other members of DBA staff to manage and monitor over 40 SQL server installations.
• Maintained a replication instance between two (2) SQL 7.0 servers for reporting purposes.
• Created logical and physical data model for Enterprise Server Information Project in ERwin.
• Installed and maintained log shipping process for a SQL 7.0 installation.