SUMMARY:

I am a Senior SQL Server Consultant and database professional with almost 30 years of experience; the past 17 years with SQL Server. My experiences and successes extend to the following roles; DBA, ETL/Data Migration (SSIS), Developer, Data Warehousing, and Business Intelligence (SSAS, SSRS). Areas of expertise include performance tuning, automation, data architecture, dynamic tsql, and platform migration; can support projects at every phase of the SDLC with the ability to build OLTP or DWH from scratch. Expertise in rehabilitating neglected systems and tough programming challenges.

EXPERIENCE:

SQL DBA / BI Developer

Confidential, MT

Responsibilities:

• Stabilize production environment, implement standards for SQL security, automation, and disaster recovery, production support and new development (t - sql, SSIS, and SSRS).
• My role grew to include team lead tasks and primary support for all SQL activities supporting the Javelina claims conversion project.
• Use Microsoft SQL Server 2000-2012; Visual Studio 2005-2012; Windows Server 2003-2012; AWS.
• Create new Dev, QA.UAT, and Prod SQL Servers; architect servers; perform all SQL installs and configurations.
• Performed SQL Server and SSRS migrations from SQL 2005 and 2008 to SQL 2008 and 2012.
• Designed SSIS packages, stored procedures, and SQL Jobs to support existing lines of business.
• Create SQL disk monitoring, notifications, automation, system maintenance, and backups.

Director of Databases and Analytics

Confidential, Tampa, FL

Responsibilities:

• Pharmaceutical Industry: Head up the new Data and Analytics Department, establish all related Policy and Procedures, and Build out the SQL farm of servers and BI stack.
• This was a duel role with executive and technical duties.
• Use Microsoft SQL Server 2014; Visual Studio 2012; Windows Server 2012; VMs Azure.
• Architect DB servers; perform all SQL installs and configurations. Create SQL disk monitoring, notifications, automation, system maintenance, and backups.
• Architect and create multiple databases for Operational Data Store (ODS) and Data Warehouses (DWH).
• Create, test and deploy all SSIS projects to load ODS and DWH including audit and logging processes.
• Install and configure SSRS; perform all report development and deployments; manage URL rights and access.
• Create database and all objects/processes to support Call Center activity including reports and new Campaign automation.
• Create Policy for Server Builds, Data Access, Naming Standards, ETL and SSRS development, and Disaster Recovery. Ensure HIPPA compliance and best practices are in use.

Senior SQL DBA / Consultant

Confidential, Franklin, TN

Responsibilities:

• Medical Billing Industry: Stabilized their production and Biztalk servers by addressing performance issues.
• Review and update server architecture, implement DR and server maintenance policies.
• Analyze and improve SQL automation processes.
• Use Microsoft SQL Server 2008 R2, 2012, and 2014; Visual Studio 2008 and 2010; Windows Server 2008 and 2012
• Add auditing and notification across non-connecting loads to find dropped records; found $119 million in unbilled revenue.
• Created maintenance and backup processes, addressed performance and locking issues, and perform server updates.
• Re-architected the Prod and QA SQL Servers to utilize 8 data files for the TempDB database.
• Performed analysis and made recommendations for making QA servers suitable to test scale and volume of data.
• Participate in Change Control and represent the group and its interests.

Senior SQL DBA / Consultant

Confidential, Lebanon, TN

Responsibilities:

• Stabilized and extended the life of their MRP application by addressing performance issues and moving it to a new production server.
• Reviewed the SQL security and reporting environment for improvements, helped establish corporate SQL protocol for server maintenance, created Change Management policies, documentation, and disaster recovery.
• Use Microsoft SQL Server 2005, 2008 R2, and 2012; Visual Studio 2005 and 2008; Windows Server 2003, 2008, and 2012
• Increased production floor productivity by 30%; due performance changes.
• This drastically cut product delivery for Confidential patients Architected and built the new production DB server; performed installs and configurations.
• Performed cut-over to new server moving all SQL objects relating to production and leaving SSRS and SharePoint behind.
• Security, Backups, Replication, Performance and locking issues, data refreshes, code moves, and server updates.
• Created and documented a Change Control process for monthly software releases and hotfixes to production.

Senior SQL DBA / Consultant

Confidential, Phoenix, AZ

Responsibilities:

• Fixed performance issues, stabilized production environment, implemented standards for Disaster Recovery, and made recommendations for archiving, partitioning, security, enterprise reporting, and how to extend the product’s life cycle.
• Use Microsoft SQL Server 2000, 2005, 2008 R2, and 2012; Visual Studio 2005 and 2008; Windows Server 2008, and 2012
• Backups, Log Shipping. Standardize DBMail, notications, and alerts. Deprecate obsolete servers, databases, and users.
• Critical issues fixed or corrected include disk space, locking, blocking, timeouts, and disconnected sessions.
• Fixed or removed failing SQL Jobs, Document jobs and reorganize schedules to eliminate contention and improve performance.
• Reviewed all data load process.
• Gaps and redundancies were identified.
• Automatation and process improvements were provided.

Senior SQL Consultant

Confidential, Lake Buena Vista, FL

Responsibilities:

• Improved Data Warehouse for WDW s global network of attractions and shows.
• Use Microsoft SQL Server 2008 R2, SSIS 2008, and SSRS 2008; Windows Server 2008
• Implemented a rolling 730-day data partition on the data warehouse with a nightly downtime of less than 3 minutes.
• Created dynamic SQL objects that access data by partition number to increase performance in cases by over 1000%.

Senior SQL DBA / ETL Developer

Confidential, Tampa, FL

Responsibilities:

• Production and QA support of e-commerce clients; Implement a hybrid Data Warehouse.
• Use Microsoft SQL Server 2000, 2005, 2008 R2, and 2012; Visual Studio 2005 and 2008; Windows Server 2003, 2008, and 2012
• Security, Backups, Indexing, Log Shipping, Performance and Locking issues, Server installations, and Code moves.
• Architected and build Data Warehouse; Develop SSIS Packages and implement Automation, Dashboards, and Alerts.
• Implemented and test Disaster Recovery plan, Change Control, and Source Control; create all initial departmental documentation.
• Performed SQL Server migrations from SQL 2005 and 2008 to SQL 2008 and 2012.

Senior SQL Data Warehouse Architect / Developer

Confidential, Des Moines, IA

Responsibilities:

• Fuel and Foods Industry: Modified the existing Data Warehouse to meet immediate business needs and plan for its replacement.
• Use Microsoft SQL Server 2008 R2, SSIS 2008, SSAS 2008; Windows Server 2008
• Scripted DML changes, additional indexes, Merge code, audit code, and SSIS packages for the new Dim and Fact changes.
• Added additional indexes and optimize existing stored procedures to increase performance of fact table loading.
• Created documentation for existing data warehouse; Data Dictionary, ERDs, DFDs, and job scheduling.

Senior SQL Data Warehouse Developer / DBA

Confidential, Orlando, FL

Responsibilities:

• implemented new Data Warehouses and Marts for reporting of all Park and Show activities.
• Use Microsoft SQL Server 2008 R2, SSIS 2008, JDA on IBM AS/400, Oracle 12i, SSRS 2008; Windows Server 2008.
• Designed databases and script the SQL objects for the Data WH and the Data Mart; dynamically generate the Merge statements.
• Designed ETL packages to load data for the Data Warehouses and Data Marts; initial loads and daily loads.
• Created special coding for Tridion project to reproduce quasi-XML files to WebMethods from an eCommerce site.
• Implemented tools for performance monitoring and backups.

Senior SQL Data Consultant / ETL

Confidential, Clearwater, FL

Responsibilities:

• Planed and perform the data migration of Fixed Asset, Accounting, Finance, and Confidential ’ Customer and Order data into a Microsoft Dynamics ERP platform; Windows Server 2008.
• Use Microsoft SQL Server 2008 R2, SSIS 2008, SSRS 2008, and Microsoft Access 2010
• Evaluated existing systems’ schemas and new systems' requirements and identify data gaps.
• Designed SQL tables, indexes, stored procedures, and functions to stage data. Wrote highly complex SQL processes to de-duplicate and merge Customers data.
• Wrote SSIS packages and SQL stored procedures to de-duplicate and merge Customers data and re-assign foreign keys.

Senior SQL DBA / Developer

Confidential, Lake Buena Vista, FL

Responsibilities:

• Implemented Data Warehouse and reporting solutions for WDW s global network of attractions and shows.
• Use Microsoft SQL Server 2008 R2, SSIS 2008, SSRS 2008 and Tableau; Windows Server 2008
• Evaluated existing systems schema and replication process and make recommendations for system improvements.
• Made schema changes; add/remove tables/indexes and modify relationships between entities to improve performance.
• Replaced the service based Replication process with a faster more stable option.
• Designed SSIS packages, stored procedures, and SQL Jobs to automate data loading and perform system maintenance.

SQL/SSIS Developer

Confidential, Tampa, FL

Responsibilities:

• Implemented a SQL Data warehouse for an Oracle Enterprise management system.
• Use Microsoft SQL Server 2008, SSIS 2008, SSAS 2008, ERWin, and PL/SQL; Windows Server 2008
• Designed databases, tables, indexes, wrote T-SQL; for Stage and Warehouse environments.
• Designed complex SSIS packages to extract, transform, and load Oracle data.
• Developed utility scripts, functions, and procedures used to collect and report data loading statistics and errors.