SUMMARY:

• Extensive experience in the design, development, performance tuning and implementation of Confidential SQL Server Web or Enterprise Client - Server systems using parameterized stored procedures, triggers, functions and in-line SQL Queries.
• Specializing in SSIS packages, database architecture, system design, coding and implementation from SQL Server 2000 to SQL Server 2008 R2 and both SQL Server 2012, 2014 and SQL 2016.
• Recent experiences with integrating the FitBit.com, FatSecret.com, NutritionIX.com and iHealth.com REST API Web Services using both ASP.NET and Java Script client rendering objects.

TECHNICAL SKILLS:

• SQL Server 2000 through SQL Server 2016 Database Design
• Development and DBA tasks. Active Server Pages (ASP 3.0)
• IIS 5.0 through IIS 8.5
• HTML
• SQL Server SSIS Packages
• PowerShell 3.0
• 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 using Report Builder 3.0 and SQL Server SSIS Packages plus SQL Full-Text Search Services. Expert in the Confio Ignite SQL Performance Monitoring and SQL Tuning package from Solar Winds called Database Performance Analyzer

PROFESSIONAL EXPERIENCE:

Confidential, Somerville, MA

Microsoft SQL Server DBA and Developer using SQL Server

Provided interim SQL Server DBA and Developer functions for almost 900 SQL Servers with over 5,000 unique SQL Server databases running either Business Critical or Mission Critical operations. Completed the following projects: 1) Created a new Central Management Server installation with almost 900 SQL Servers by SQL Edition from 2005 to 2016 to allow individual queries and PowerShell Scripts to be executed against between 1 to 100 SQL Servers at once. 2) Wrote a unique stored procedure which generated the XML code blocks required to create and update the msdb tables used by the Central Management Server. 3) Designed and coded a unique Failed SQL Server Backups automated processing and reporting system which discovered the SQL Servers with recent failed backups within the previous 24 hours as determined by the Confidential Policy Management System.

Confidential, Marlborough, MA

SQL Server DBA and Developer using SQL Server

Developed a complex data conversion program using SQL parsing functions like CHARINDEX, INSTR and SUBSTRING to migrate Time and Attendance data recorded on the existing TimeTrax time clock system of the acquired company to the vendor used by Confidential which is Kronos. As part of a company acquisition, a migration had to be completed to allow data to be parsed from a TimeTrax Excel report into SQL Server 2014 Standard Edition so it could be imported using the Kronos data import API already in existence.

Confidential, Cambridge, MA

SQL Server DBA and Developer using SQL Server

Performed a complete migration from an existing SQL Server 2008 R2 64-bit system to a SQL Server 2014 64-bit Enterprise system including migrating the Relational Database Engine, moving SQL Server Integration Services and existing SSIS Packages to the SSISDB Catalog and migrating the Report Server including 25 existing reports. Existing SQL Agent Jobs were also migrated and modified where required as new packages were developed or enhanced. Configured the entire schedule of Backup and Maintenance jobs for the new server including Database and Index Maintenance Jobs based on the Hallengren Maintenance system.

Confidential, Southborough, MA

SQL Server DBA and Developer using SQL Server

Served primarily as a SQL Server DBA with primary responsibilities for a typical DBA role: Backups and Restores both Full and Differential, System Migrations and Refreshes among various environments Production, Development, User Acceptance Testing, System Integration Testing and Quality Assurance.

Confidential, Burrillville, RI

SQL Server and Website Development - SQL Server

Executed a complete Small Business Administration Loan application for a local start-up gymnastics facility including Pro Forma 3-year Quarterly Profit & Loss Statements, Cash Flows and Balance Sheets.

Confidential, Quincy, MA

SQL Server DBA and Developer - SQL Server

Served as an interim back-fill SQL Server DBA while the incumbent took a leave of absence to get married overseas. Provided the usual backup and restore activities using Dell Lite Speed 7.5 and introduced several stored procedures to both install SQL Server Statistics calculations and then schedule their periodic re-calculation on a weekly basis with a 20% sampling size, using SQL Server Job Agents. Created a stored procedure to prune very large Application Log files (25,000,000 records) in real-time with minimal impact to current eCommerce transactions to include only the most recent 90 days of activity. Performed a migration analysis to measure the impact of moving a SQL Server Reporting Services instance from one machine to another with more disk space and extra computing power available. Created new SSIS packages and performance tuned several existing SSIS packages. Performed root cause analysis to determine why various SQL Server Jobs either failed to run entirely or encountered fatal errors in execution.

Confidential, Cambridge, MA

Senior SQL Server DBA, Developer and Designer - SQL Server

• Provided the normal SQL Server DBA functions including a re-design for SQL Server Dev and Prod Maintenance Plans for Backups and Restores
• Features like Index Optimization, Query Timeout Remediation, Performance Tuning of slow stored procedures and the reduction of deadlocks and process blocking through Indexing and other modifications to stored procedures were also implemented
• Provided Database Architecture and DB Schema Diagrams as Entity Relationships Diagrams (ERDs) using dbSchema.com toolsets

Confidential, Marlborough, MA

Senior SQL Server Developer, DBA and Designer - SQL Server

• Provided the normal SQL Server DBA services including an entire re-design for SQL Server Maintenance Plans including features like Index Optimization, Query Timeout Remediation, Performance Tuning of slow stored procedures, and the reduction of deadlocks and process blocking through Indexing.
• Provided Database Architecture and DB Schema Diagrams as ERDs using dbSchema.com.
• Provided SQL Server Documentation using both Red Gate Documenter and the Apex SQL Documenter.
• Created over 25 Diagnostic Reports using SQL Stored Procedures with HTML and CSS formatting
• Used SSIS as the primary ETL toolset including BCP to import literally thousands of individual pipe-delimited rows into the SQL Staging Tables. Worked on the SSRS Reporting Interface to produce some data verification and validation reports as well.

Confidential, Boston, MA

Senior DBA, Developer and Designer - SQL Server

• Provided the usual SQL Server DBA services including an entire re-design for SQL Server Maintenance Plans including features like Index Optimization, Query Timeout Remediation, Performance Tuning of slow stored procedures, and the reduction of deadlocks and process blocking through Indexing.
• Optimized both SQL Server 2012 and .NET 4.0 System Performance and System Maintenance for both the Accenture and Avanade Insurance Policy Management Systems which included Underwriting, Billing, Client, Accounts Receivable and Accounts Payable modules using AppDynamics.com for .NET.
• Introduced both the sp Blitz and sp BlitzIndex toolsets to diagnose and remediate several SQL Server configuration issues and installed missing indexes which improved performance by over 50%.
• Implemented the Confio Ignite Performance Tuning and Monitoring System on Production, Test and UAT Systems to both detect and remediate various performance issues which were causing bottlenecks and slow performance both in the OLTP systems and in the overnight SQL Agent Scheduled Jobs running various SSIS packages.

Confidential, Wellesley, MA

Senior DBA, Developer and Designer - SQL Server

• 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.
• 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 data import cycles using SSIS packages.
• 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 SSIS jobs.

Confidential, East Greenwich, RI

Senior Database Developer and Designer - SQL Server

• 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. 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.
• Provided the usual SQL Server DBA services including an entire re-configuration for the missing or inadequate SQL Server Maintenance Plans including Index Optimization on a weekly scheduled basis.

Confidential, Boston, MA

Senior Database Developer and Designer - SQL Server

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

Confidential, Providence, RI

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

Confidential, Marlborough, MA

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 Confidential on a Netezza Twin-Fin Appliance.

Confidential, Foxboro, MA

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.

Confidential, Cambridge, MA

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.

Confidential, Quincy, MA

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 Confidential 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

Confidential, Norwood, MA

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, Confidential . Optimized query performance across the board using the Index Tuning Advisor and eliminated both redundant and seldom used indices across all 3 tiers.

Confidential, Providence, RI

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 system uses a Confidential 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.

Confidential, Hopkinton, MA

Senior Solutions Architect

• 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 Confidential 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.
• 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, Providence, RI

SQL Server Developer and SQL Performance Tuning

• Used the Idera, Confidential . 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.

Confidential, Westborough, MA

SQL Server Developer and DBA and Crystal Reporting Manager

• Served as interim Corporate Reporting Systems lead programmer/analyst and project team leader for all divisions including TJ Maxx, Marshall's, Home Goods, AJ Wright as well as the foreign divisions in Germany and the United Kingdom. Reporting System is based on Crystal Reports 9.0, using Transact SQL, SQL Job Scheduler and DTS Packages using Oracle, SQL Server 2000 and 2005.

Confidential, New York, NY

Senior SQL Server DBA and Developer

• SQL Server 2000 performance tuning and optimization assignment which involved a total re-organization of the data into Primary, Secondary and Tertiary File Groups to maximize disk performance, a re-design of several stored procedures to take advantage of both existing and new indexes using the Index Tuning Wizard and installation of Idera's SQL Diagnostics Manager and other tools in order to measure and monitor performance improvements over time.

Confidential, Quincy, MA

Senior SQL Server DBA and Developer

• Migration and optimization of several different multi-terabyte SQL Server 2000 applications for a major retailer (Stop and Shop, Confidential .) onto a new dedicated server under SQL Server 2005. Project relieved severe bottlenecks from data loads via Bulk Inserts and DTS packages, optimized analytical processing calcs and improved data retrieval functions

Confidential, Dorchester, MA

SQL Server Developer, DBA, DTS Package Designer and Data Architect

• Designed, programmed and implemented a customized Report Writing Engine as part of the acquisition of The Independence Community Bank of New York. Conversion of the legacy data capture, report generation and analysis systems from Access 2000 to SQL Server 2000 was accomplished by creating an equivalent to SQL Reporting Services and Crystal Reports. The Access 2000 Systems converted ranged from Enterprise Wide Transaction based systems for all Checks and Deposits, ATM Transactions and Branch Teller Activities.

Confidential, Boston, MA

SQL Server Database Administrator and Data Architect

• Managed the SQL Enterprise Optimization Project which improved performance across the board for SQL Server 2000 by adding indexes and optimizing stored procedures; for Confidential Web Components using Virtual Memory Swap Files; for the Enterprise Storage Systems using Diskeeper; and for Notes Agents by load-balancing and rescheduling and minimizing SQL Logins and Connections.

Confidential, Hartford, CT

Developed SQL Server 2000 applications using ASP 3.0, SQL Stored Procedures and the Cognos Report Net environment and installed a vendor’s DHTML/Javascript Menu System:

Confidential, Raynham, MA

• Developed a system and configured a new Domain and Website using an ASP-driven SQL Server 2000 Shopping Cart System for Confidential .

Confidential, Providence, RI

• Developed an integrated SQL Server 2000 System and website dedicated to Wholesale Distributors of Electronic Parts and Components.

Confidential, Ledyard, CT

• Developed a prototype of The PRISM System (Poker Room Interactive Seating Management System) as a proprietary application for the Confidential . Used Active Server Pages and SQL Server 2000 for the web component and Voice XML from Angel.com for the Interactive Voice Response Reservation components. ASP for the Pocket PC was utilized for the hand held WiFi transactions and inquiries. Enhancements made for both Foxwoods Resort Casino as part of an open Request for Proposal.

Confidential, Upper Saddle River, NJ

• Integrated an eNewsletter Membership Management System with a WYSIWYG Content Management System to create a Monthly eMail Newsletter Service for several Confidential Divisions. Uses Confidential ASP, SQL Server 2000 and Access 2000 to produce a web enabled interface for creation and transmission of eNewsletters to an opt-in subscriber list.

Confidential, Providence, RI

• Consulting assignments implementing modifications to several different Confidential SQL Server and Active Server Pages products and systems.