SUMMARY

Extensive experience in the design, development, performance tuning and implementation of Microsoft SQL Server Internet Enterprise Client Server systems and Netezza Twin - Fin Data Appliances using parameterized stored procedures, triggers, functions and in-line SQL Queries. Specializing in SSIS packages, database architecture, design, coding and implementation from SQL Server 2000 to SQL Server 2008 R2 with some SQL Server 2012. Recent experiences with integrating the REST API Web Services using both ASP.NET and Java Script client rendering objects adds to my overall experience. Used OAuth 1.0 Authentication schemes, XML shredders and JSON deserializers for these applications. Utilized multiple report writing packages including both Crystal Reports and Microsoft SSRS. Also experienced with the SQL Server Full Text Search Engine and several performance tuning products like Confio Ignite and Idera SQL Diagnostics Manager with and without Dynamic Management Views for performance tuning. Have implemented SQL Server within the Terremark Enterprise Cloud Environment, the Azure Cloud Services environments and Cloud Share as well.

TECHNICAL SKILLS

• Internet Programming Tools, Languages and Technologies
• SQL Server 2000 through SQL Server 2012 Database Design, Development and DBA tasks. Netezza Twin-Fin Database Appliance and some Oracle 10g. Active Server Pages ASP 3.0, IIS 5.0 through IIS 8.5, HTML, SQL Server SSIS Packages, Transact SQL T-SQL, SQL Stored Procedures, Functions and Triggers, VB Scripting, XML, Crystal Reports 8.5 through 10.0 and Iron Speed ASP.Net Designer. SQL Server Reporting Services and SQL Server SSIS Packages plus SQL Full-Text Search Services. Expert in the CONFIO Ignite SQL Performance Monitoring and SQL Tuning package. Have used Red Gate Tools, Apex SQL Tools and the BI Express Engine from Pragmatic Works. Experienced with REST API calls returning JSON and XML and the implementation of Console Based REST API application development using Apigee.com, MaaSive.net and MuleSoft.com consoles among others. Used both the dbSchema.com ERD Reverse Engineering Tools, Dezign for DBs and the CodeOnTime.com CRUD generators for ASP.NET 4.5, under IIS 8.5 with SQL Server 2012.
• My Performance Optimization technique includes the use of the following methodically executed components:

1 Using Third Party monitoring and diagnosis tools like CONFIO Ignite and Idera SQL Performance Manager

2 Using Dynamic Management Views DMVs provided by Microsoft or other 3rd party products or sites or those written by myself

3 Analysis of SQL Query Plans, using the Index Tuning Optimizer and other comparable internal SQL server tools to remediate slow running procedures

4 Adjusting the SQL Schema designs where performance optimizations could be obtained via a total or partial re-design and some de-normalizations

5 Analyzing hight level server-wide SQL Server settings like Transaction Isolation Level, WITH NOLOCK settings, etc.

6 Implementing SQL Server partitioning to minimize the date range spans involved in various queries

7 Distributing the storage files across more physical disk spindles by using smaller disks and multiple .MDF and .NDF files, one per physical disk

8 Performing periodic over-night pruning, re-indexing and the re-builds of any badly fragmented Indexes during periods of minimal disk I/O

9 Running either Diskeeper.com or Auslogics,com disk defragmenters if not already handled with scheduled jobs or internal SAN technology

10 Analyzing various Wait States to eliminate excessively long Disk I/O queues, long Signal Waits for CPU time slices or excessive Memory contention

11 Fine tuning Stored Procedures, Triggers and Functions to meet Microsoft SQL Server Best Practices for Optimized Performance

12 Creating a checklist for future stored procedure and index development to highlight various features for inclusion in the ongoing Performance Maintenance

13 Installing and configuring a complete self-diagnosing Performance Management environment to enable current full-time employees to continue the process

14 Documenting all of the integrated components of this new PM environment so that each part can be fully understood and maintained by existing staff

15 Creating a Maintenance Plan running on a scheduled SQL Job Agent basis to perform the required database maintenance tasks and index optimizations

PROFESSIONAL EXPERIENCE

Confidential

Senior DBA, Developer and Designer

• Provided the usual SQL Server DBA services including an entire re-design for missing or inadequate SQL Server Maintenance Plans including other features like Index Optimization, Query Timeout Remediation, Performance Tuning of slow stored procedures, and the elimination of frequent Transaction Rollbacks which caused numerous Deadlocks and process Blocking system-wide.
• Optimized the entire batch data load processing for data scanned from Wi-Fi enabled Utility Meters for Electric, Gas and Water Utilities and fine-tuned their monthly Billing Cycle processing.
• Used Visual Studio 2013 and Team Foundation Server for Change Requests, Task and Bug Management and Source Control for remediating approximately 100 individual tasks and bugs.
• Introduced both the spBlitz and spBlitzIndex toolsets to diagnose and remediate several SQL Server configuration issues and indexing design issues which existed for several years on the current system. Installed an industry standard Maintenance Plan Job Creator and Scheduler because the current system had major fulfillment scheduling gaps present. Retrofitted TRY CATCH processing.
• Implemented the CONFIO Ignite Performance Tuning and Monitoring System on Production and UAT Systems to both detect and remediate various performance tuning issues which were causing bottlenecks and slow performance both in the OLTP systems and in the overnight SQL Agent scheduled jobs. Converted from READ COMMITTED to READ UNCOMMITED system-wide.
• Created Continuous Bi-Directional Data Synchronization triggers on various tables through the use of the Apex SQL Audit trigger maintenance system which is similar to Change Data Capture.
• Provided Database Architecture and DB Schema Diagrams as ERDs using the program from dbSchema.com. Provided SQL Server Documentation using the Apex SQL Documenter.

Confidential

Senior Database Developer and Designer

• Created data migration stored procedures to transfer data on a Point-In-Time basis from the existing SQL Server Portal to the new Provant ONE Portal. Used both SSIS Packages and the SQL Server Data Migration Wizard as well as Red-Gate.com's SQL Diff and SQL Data Diff Toolsets plus Apex SQL equivalent tools.
• Created Continuous Bi-Directional Data Synchronization triggers on various tables through the use of the Apex SQL Audit trigger maintenance system which is similar to Change Data Capture provided by MS SQL Server.
• Provided Database Architecture and DB Schema Diagrams as ERDs using the program from dbSchema.com. Provided SQL Server Documentation using the Apex SQL Documenter.
• Used both Visual Studio 2010 and 2012 and SQL Server Data Tools SSDT to implement changes in SSIS Packages and to upgrade several SQL 2008 R2 SSIS Packages to a new SQL Server 2012 instance.
• Introduced both the sp Blitz and sp Blitz Index toolsets to diagnose and remediate several SQL Server configuration issues, maintenance plan deficiencies or indexing design issues which existed for several years on the current system. Installed an industry standard Maintenance Plan Job Creator and Scheduler because the current system had major fulfillment gaps present.
• Implemented the CONFIO Ignite Performance Tuning and Monitoring System to both detect and remediate various performance tuning issues which were causing bottlenecks and slow performance both in the OLTP systems and in the overnight SQL Agent scheduled jobs.
• Implemented the REST API interfaces for both FitBit.com and FatSecret.com which required learning the inherent intricacies of OAuth 1.0 authentication methodologies and the use of JSON and XML parsers to process the Requested Responses followed by insertions into the SQL Tables.
• Provided the usual SQL Server DBA services including an entire re-configuration for the missing or inadequate SQL Server Maintenance Plans including Index Optimizationd on a weekly scheduled basis.
• Generated a complete SQL Server CRUD wrappers using CodeOnTime.com and ASP.NET 4.5 to Create, Retrieve, Update and Delete records for the existing set of over 200 tables which involved creating almost 900 stored procedures using a tool designed expressly for this purpose. This required almost 2,000 individual ASP.NET programs to allow Searching, Grid Browsing, Adds, Changes, Inquiries and Deletes as well as exports to .CSV, .XLS, Word Documents or PDF output file formats.

Confidential

Senior Database Developer and Designer SQL Server 2008 R2 and SQL Server 2012

• These 2 diagnostic tools identified over 250 essentially duplicated indexes with different names across the 1,500 tables in the 12 databases involved and suggested the addition of or changes to another 250 missing or inadequate indexes as well based on recent changes for Reports, ETLs and GUI enhancements.
• Installed the CONFIO Ignite Performance Monitoring System in order to identify the root cause of several severe bottlenecks and to remediate poorly written stored procedures created by 7 different development teams plus the client as well.
• Provided Database Architecture, Documentation, Programming and Design services for several year-end enhancements including the addition of the Mobile Phone with Opt-In data integration feature, several reporting back-end stored procedure modifications and the Aged Change Data Tracking System for the Pri-Med Online System.
• Changes to several SSIS packages were implemented to support these modifications or to enhance performance for other slow running DTSX Packages. Used both Visual Studio 2010 and 2012 and SQL Server Data Tools SSDT to implement changes in SSIS Packages and to upgrade several SQL 2008 R2 SSIS Packages to a new SQL Server 2012 instance. Introduced the sp Blitz and sp Blitz Index toolsets to both diagnose and remediate several SQL Server configuration issues, maintenance plan deficiencies or indexing design issues which existed as a result of the presence of 7 distinct vendor database implementations each with widely differing approaches to these critical SQL Server settings.

Confidential

Senior Database Developer and Designer SQL Server

• Designed and developed a virtual inventory procurement system with eCommerce using a SQL Server 2012 Cloud based backend which is comparable to Shopzilla.com, Rakuten.com or Wayfair.com but for electronic parts and components. The system required extensive enhancements and modifications to the VP-ASP eCommerce system which consists of over 5,000 individual programs and modules. The challenge involved converting a traditional physical inventory driven system into one which was able to obtain current inventory details in real-time from Arrow, Avnet, Mouser, Future, DigiKey, Newark and other similar providers of electronic parts and components.
• Using a Microsoft component called XMLHTTP it was possible to gather current descriptions, prices and availability in real-time and present the results as if the stock was already available and stocked in a warehouse. The eCommerce based in-line dynamic SQL was converted into parameterized stored procedures in order to enhance performance and multiple indexes were added to optimize data retrieval since the system was written to accommodate either SQL Server, Access or MySQL database backends in its current commercially available software versions. Performance tuning was achieved using the Confio Ignite commercial product in order to identify the slowest performing stored procedures on an ongoing basis.

Confidential

Senior Database Developer Netezza and SQL Server Enterprise Systems

• Designed and developed multiple enhancements to the Enterprise Customer Relationship Management System for a Fortune 100 client of Merkle, Inc. on a Netezza Twin-Fin Appliance. This was my first experience with the Netezza environment and I had to learn the subtleties and nuances of that development environment based on my own initiative and ingenuity. The CRM system utilized a pre-designed Enterprise Data Warehouse Schema consisting of 1,000 distinct tables and approximately 1,000 stored procedures. The CRM System gathered data from the last 5 years history of Sales Orders, Sales Order Details, Product Warranties and Sales Quotes for transactions from both individual customers and corporations in order to create profiles of buying patterns and buying power by decision makers as well as their responses to previous marketing campaigns and sales promotions using various delivery methods: eMails, Direct Mail, SMS Messages, Fax Broadcasts and Telemarketing. The areas of my focus included enhancements to the Decision Maker/Influencer matrix Response Attribution to Campaigns and Promotions Linking of Order Headers, Order Details, Sales Quotes and Product Warranties and the analysis of both Business and Personal Finance Contracts and Leases.
• Also introduced the dbVisualizer Client DBMS Management Studio Tool on a Company wide basis which is now replacing the equivalent Aginity Tool across the board for all Netezza and Oracle developers.
• Implemented the first Netezza to Excel automation features using the Netezza JDBC data connectors company-wide in order to optimize periodic reporting for both Development, Q/A, UAT and Production reporting purposes. Through the use of the dbVisualizer Command Line Interface CLI, it was possible to link the Tidal Job Scheduler to the creation of both the Netezza reporting tables and the fully automated batch export of that data from Netezza into new Excel Workbooks with multiple Tabs, one for each report. Report consumers were only required to open the newly created Excel Workbooks which were set for: Auto-Refresh Data on Open in order to view the newly generated reports on demand.

Confidential

Senior SQL Server Performance Tuning Engineer, Developer and DBA

• Utilized both Dynamic Management Views DMVs, SQL stored procedures, functions and third party software to improve the performance of the distributed SQL Server environment installed at various client sites across the globe as Performance Tuning Engineer.
• Improved performance by about 50 using several methods: a the installation of parameter driven index optimization routines which either REORGANIZED or REBUILT indexes based on their fragmentation levels, the table sizes and the date of the most recent index updates b the creation and updating of Index Statistics in order to allow query plans to be fully optimized c the addition of suggested missing indexes both transient and permanent in both permanent SQL Tables and temporary tables, as well as in Non-Indexed Views and in Table-Valued functions without a Primary Key.
• Redesigned stored procedures for overall performance including record set paging to comply with various Best Practices for avoiding table scans, inefficient joins and locking or blocking conditions. Added complex error handling using TRY - CATCH blocks with logging to Error Log tables. Created SQL Agent Jobs for database integrity checks and for scheduled backups both Full and Incremental for both system and user databases and log files in my role as DBA. Redesigned the disk subsystem for the SQL Server Standard Edition hardware appliances to comply with Best Practices for distribution of the .MDF and .NDF files, the Log files and the Temp DB across multiple distinct spindles.
• Introduced various Red-Gate products including SQL DB Compare, SQL Data Compare, SQL Backup Pro, SQL Data Generator, SQL Documenter, SQL Dependency Visualizer and SQL Find. Built a half-dozen different Windows 2008 R2 Servers with SQL Server 2008 from bare metal and introduced Marathon Technologies to incorporate the Xen-based EverRun MX Fault Tolerance on Industrial Defender systems. The EverRun product is equivalent to the Always On technology provided by Microsoft but at a significantly lower implementation cost because only a single MS SQL Server license is required for both machines joined in the individual component based virtual fail-over cluster equivalent. This Marathon Technologies EverRun virtual configuration allows for individual component failovers at the level of the Disk Controllers, the Power Supplies, the Cooling Fans, the Memory, the Mother Board, the Serial or Parallel Ports, the Ethernet Connectors, the local Disk Drives, etc. without affecting overall system integrity or operation.

Confidential

Principal SQL Server Developer and Performance Tuning Engineer

• Principal SQL Server Designer, Developer and DBA, specializing in the CONFIO Ignite SQL Server Performance Tuning and Monitoring System. Optimized and tuned approximately 100 existing SQL Server stored procedures and functions and created 50 additional stored procedures, triggers and functions. Added new indexes using both the Index Tuning Advisor and other methods. The Heywire.com SMS messaging system supported over 60,000 daily message texting users sending over 2,500,000 messages daily in a high-performance OLTP System with both a Reporting Services and Data Warehouse back end.
• Implemented a new Backup/Restore strategy and the archiving of aged messages, inactive users and unused mobile devices. Used multiple SSIS packages to load external databases as well as the Data Warehouse. Enhanced the existing reporting system to include several new data elements and tables then optimized performance of all reporting. Designed several new Ignite performance tuning metrics including the Rate of Change of Transactions per Second Volume, Round Trip Messaging Traffic Timing and various Blocking or Locking details.
• Also implemented a structured approach to stored procedure design that included Transaction Wrappers, BEGIN TRY thru END CATCH processing, Rowlock and NoLock handling and other features including a migration to TRANSACTION ISOLATION LEVEL READ UNCOMMITTED which resulted in a 40 performance improvement overall. Introduced the toolsets from Red Gate, Apex SQL and BI Express for all developers.

Confidential

Senior SQL Server SSIS Developer and Architect

• Designed and developed an integrated Telephone Call Rating System which processed call detail records received from Bell Canada and TELUS on behalf of customers of Granite Telecommunications using MSSQL Server 2005/2008.
• Created SSIS packages to import, parse and process Call Detail Records against existing tariffs including international calls to destinations utilizing almost 20,000 international dialing prefixes for multiple vendors for both landlines and mobile lines. System was comprised of 15 SSIS packages, 30 stored procedures and over 6,000 lines of transact SQL statements. Source files were in both CSV and Structured Data File formats as well as in Oracle Master File tables. System was completed on time with 100 Call Rating accuracy based on the UAT testing matrix. Code migration to include domestic USA International Long Distance Call Rating using the Verizon Dialing Prefix Master File is being planned. Replaced a system which originally took 25 person-years to complete for domestic USA carriers. Created Project Plan in Excel migrated to MS Project and used MS Team Foundation Server.

Confidential

SQL Server Architect and Developer

• Designed, programmed and implemented a SQL Server Trigger-based Change Tracking System for Replication of only changed and monitored columns in selected tables between servers. This system propagated monitored changes from relevant OLTP Tables into the Data Warehouse in near real-time using a combination of Triggers, SQL Agent Jobs and Stored Procedures.
• Created a customized ETL system using SSIS Packages for integrated corporate reporting with the parent organization, Skillsoft, Inc. Optimized query performance across the board using the Index Tuning Advisor and eliminated both redundant and seldom used indices across all 3 tiers: Development, UAT and Production.
• Introduced the ApexSQL product suite for replicating both structural DDL consistency and master file data content consistency across all 3 tiers as well. Redesigned the Subscription Caching Sub System to produce a 50 performance improvement and the complete elimination of the caching table which had grown to almost 100,000,000 rows over 10 years and outlived its originally designed functionality.

Confidential

SQL Server Developer and DBA

• Designed, developed, programmed and implemented an internet-based eCommerce application suitable for the sale of any product or service with secure checkout and multiple payment option requirements. The site is at and it is the first website in the world, to be fully enabled and certified for the new Microsoft Bing Shopping Service, the Microsoft Bing Search Service and both the Google and PayPal Checkout Services with integrated interfaces while also providing monthly product feeds and sitemap extracts for 10 different major shopping and/or web spidering services. The system uses a Microsoft SQL Server 2008 remote backend, running on a Windows 2008 web server under IIS 7.5 with extensive use of ASP 3.0, XML, Soap Services and the XMLHTTP object for remote data access and Soap Messaging. The system uses a combination of parameterized SQL Stored Procedures, SSIS Packages, SSRS Reports, Transact SQL and in-line SQL through extensive use of ActiveX Data Objects including selective use of the Stored Procedure Command Object. Maintained Project Plan in Excel and used MS Team Foundation Server.

Confidential

Senior Solutions Architect for Microsoft SQL Server and SharePoint Server on VMware

• As part of the Service Program Development team, my responsibilities included configuration and optimization of SQL Server 2005 and 2008 as the departmental DBA as well as configuring SharePoint 2003 and 2007 on EMC CLARiiON and Symmetrix SAN based storage arrays for OLTP and batch performance, offline backups and simultaneous replication throughput. Environments included both virtual VMware and physical implementation environments.
• Created a tool to validate all existing hyper-links present within an entire directory of Microsoft Word documents using invisible Word Automation and implemented the Microsoft XMLhttp Object for background validation of Intranet or Internet based hyper-links with detailed logging of results.
• Began development of a new proprietary SQL Performance Management tool for SQL Server performance monitoring and measurement in order to diagnose and correct critical performance related issues for clients on SQL 2005 or SQL 2008 systems. Focused on several metrics in each of the major physical and virtual categories: Disk I/O, Memory Usage, CPU Utilization, Stored Procedure and Query Performance, Index Optimization with Query Plans, Storage Array Configurations and Physical File Layouts. This tool was designed to monitor over 600 different SQL Performance Metrics and export of data to produce Excel Pivot Table Graphs.

Confidential

SQL Server Developer and SQL Performance Tuning

• Used the Idera, Inc. 3rd party SQL Diagnostics Manager tool for SQL Server Performance Monitoring and metrics measurement in order to diagnose and correct several critical performance related issues on 32-bit systems.
• Focused on several metrics in each of the major physical and virtual categories: Disk I/O, Memory Usage, CPU Utilization, SQL configuration settings, Stored Procedure and Query Performance, Index optimization and Query Plans, Storage Array Configurations and Physical File Layouts. After gathering statistics for a 10-day period, several graphs and reports were produced and analyzed to facilitate ultimate resolution of issues. Primary Root Cause was determined to be inadequate sizing for Procedure Buffer Cache due to a default 32-bit 50 MB limitation for SQL Server 2000 in a 32-bit environment. After converting in-line SQL Queries to parameterized Stored Procedures and reviewing Query Plans, the percentage of SQL recompiles was greatly reduced improving overall OLTP performance considerably. Buffer cache hit ratio was restored to the 99.5 levels. Led the 5-person team as Project Leader assigned to resolving these performance issues