SUMMARY:

Experienced SQL Server SME - Database Architect/ Project Lead / SQL Server expert DBA / Developer with broad industry experience.

CORE COMPETENCIES:

• Deployments and migrations to/from physical and VM
• Requirements Gathering, Full SDLC Management (including Agile/Scrum/Waterfall methodologies)
• Numerous Data Center migrations/consolidations
• Disaster Recovery planning
• Project management of SQL Server migration projects
• DTS and SSIS Package Development/Testing/Tuning/Rewriting (thousands)
• Architect for SQL 7 thru SQL 2016 projects
• Design/Development for SQL 7 thru SQL 2016 projects
• Testing for SQL 7 thru SQL 2016 projects
• Deployment for SQL 7 thru SQL 2016 projects
• Performance Tuning for SQL 7 thru SQL 2016 projects
• Clustering, Log Shipping, Replication, Mirroring, Always-On
• Data Warehousing (Design/Development/Testing/Deployment/Operational/Tuning)
• Deployment of Crystal Enterprise
• Team Lead for ERP deployments
• Team Lead for SFA and CRM projects
• Technical Lead for FDA monitored projects
• Author - SQL Server Security Policies for the Federal Reserve Bank of Boston
• Design and installation of the first Municipal WAN in the State of Massachusetts
• Numerous migration projects across nearly every combination of SQL versions

SKILLS/TOOLS:

• Project Management
• Logical /Physical Data Modeling
• SQL Server SSIS (all versions)
• HA - Mirrors, Log Shipping, Replication, Always-On, Clustering
• DR - planning, implementation and testing
• Performance Tuning
• Powershell
• Migrations
• OLAP, OLTP, Data Warehousing

PROFESSIONAL EXPERIENCE:

Confidential, Worcester, MA

SQL DBA/SME

Responsibilities:

• My role has been multi-faceted. Beginning with reviewing the architecture of all SQL Server and other database based system
• I have worked with inside and outside customers and integrators - pushing the envelope and culture to adopt, implement and support a new ‘best practices’ way of doing database.
• Ranging from enhanced DR and HA to the focus on performance, security and reliability for all Databases in the organization we have tackled the renewal of all systems on a VM platform.
• All database related services are being re-examined, from how we implement and manage access and security to how we tune, monitor and provide all around best of class services to our data systems.
• DBA representative for DR Team, Security Team, Enterprise Architecture Team, RCA Team, Monitoring Team, Change Control Team.

Confidential, Southborough, MA

SQL DBA/Architect

Responsibilities:

• Hired on as SQL Server Architect to design a replacement for their core business application.
• Client processes and manages Utility industry financed Energy Savings product rebate programs.
• Target channels and product segments span individual consumer purchases, bank financing underwriting, Furnaces, Solar Systems, CFL lighting, Energy Star rated residential and commercial products.
• Project scope includes multiple data input interfaces, outgoing interfaces, document management, work flow, data mart, claims processing, validation, payment processing.
• New system being designed to replace legacy systems.
• New system shares no ties with legacy system - nor constraints - new business processes being developed along with new data model.

Confidential, Wilton, CT

Sr. SQL DBA/Architect

Responsibilities:

• This contract requires multiple roles be filled. Responsibilities include rebuilding of the Operational DBA group.
• This has required the screening of new DBA Staff, redesigning all Policies and Procedures focused on drastically improving SLAs. Duties have also included playing catchup with large backlogs of DBA issues and service requests.
• Have shifted the group from reactive to proactive and drastically reduced the frequency of the on-call/off-hours emergencies.
• Served as clients sole DBA resource for 5 months.
• In addition to these responsibilities there was a project to migrate and upgrade all (400+ Instances) Production, QA and Development systems from much older OS and SQL Versions to a fresh fleet of SQL 2014 always-on servers.
• Migrations of older systems span all version of SQL utilizing combinations of Clustering, Log Shipping and Mirroring.
• Additional duties include consulting with Research and Trading business units to provide performance tuning, testing and design services.
• Additional services provided to Charles River and related financial systems.

Confidential

SQL Server SME

Responsibilities:

• SQL Server SME on team of senior Confidential System Architects, Analysts and Engineers.
• Project focused on evaluating and managing production system performance and stability.
• Evaluate and tune systems to manage projected 500% increase in projected sales volumes thru SaaS ERP/Order System.

Confidential, Waltham, MA

SQL DBA

Responsibilities:

• SQL Server 2014 Performance Tuning / Scalability / Evaluation Project.
• This client, a major provider of on-line sports entertainment was experiencing severe spikes in transaction volumes which were resulting in serious faults and bottlenecks to their systems.
• A full system level evaluation was performed and combinations of code and system configuration and support efforts were modified to yield better performance during peak times.

Confidential, Burlington, MA

Sr. SQL DBA

Responsibilities:

• Short term project to evaluate current SQL Server 2008 R2 Clustered Active/Active database systems .
• Deliverables includes report recommending hardware and configuration r for migration to SQL Server 2012 Active/Passive replacements.
• Also delivering project plan outline for migration tasks associated with above report.
• Rapid company expansion has required the revisiting of all database architecture and ETL processes.
• Data volumes too large for current designs to maintain.
• Responsible for redesigning the Commercial line of business’ Billing and ETL architecture/process.
• Company expansion due to expanded Dental Insurance mandates in Healthcare reforms driving significant expansion of Commercial sales for the company.
• Pressures on primary billing systems only expected to increase dramatically over the next 12 months.

Confidential

Sr. SQL DBA

Responsibilities:

• Hired to fill multiple roles for client. Member of multiple Scrum teams performing a variety of design, code and development roles.
• Also member of the DBA team performing a variety of enterprise architecture, change control, systems management tasks and duties. SQL 2008r2 and SQL 2012.

Confidential, Boston, MA

Responsibilities:

• Hired as part of a two man team to triage and evaluate core ETL components of the client’s main product line.

Confidential, Norton, MA

Responsibilities:

• Hired at tail end of the first phase of a two phase project to integrate company’s ERP/Warehouse systems with parent companies systems. Phase 2 cancelled without notice

Confidential, Merrimack, NH

Energy Industry Service Provider (DBA Consultant)

Responsibilities:

• Contracted to evaluate in house designed ERP/CRM system database.

Confidential, Boston, MA

Responsibilities:

• Returned engagement. Part of 7 member team focused on company infrastructure.
• Team charged with defining and setting standards in technology and design methods for existing products as well as future offerings.
• Team also responsible for defining and setting quality standards and best practices for ETL, Web Services, Architecture/Scalability.
• Goals set for the team include Zero Down-Time SaaS and Client Hosted System Upgrades, Scalability - higher performance design and processes, aggressive reduction in Data Warehouse load and update times.

Confidential, NY, NY

Responsibilities:

• Brought in to backfill the DBA position on the clients eBook publishing/distribution and sales project (EMS)
• Scholastic has been a traditional printed publisher of books - this project was on a fast track to shift the company from traditional publishing to electronic publishing.
• The prior DBA suddenly left the company and I was hired to jump in and take over the database design and coding for this project.
• Worked remote, interfaced with management in NYC as well as developers across the globe and the US.
• Responsible for all database design, redesign, coding related to SQL - stored procedures, tuning of prepared SQL and tuning/redesign of existing code and schema.
• This phase of the project went live the week.
• Scholastic now runs their first ever electronic book store - leading Scholastics shift from traditional publishing to electronic publishing.

Confidential, Boston, MA

Responsibilities:

• Trouble-Shooting and debugging SQL Server procedures and ETL processes related to clients core product line.
• Daily interaction with client’s customers, QA departments, Build Managers.

Confidential, Nashua, NH

Responsibilities:

• Contracted to Design and Develop a single SSIS Package which the client’s Hosting group will use to migrate old version of clients Hosted Data Warehouse to newest version of Hosted Data Warehouse.
• Confidential pushing major product upgrade from their SkillPort product version 7 to 7.1 (utilizing major Architecture changes to Data Warehouse portion of product).

Confidential, Boston, MA

Responsibilities:

• Contracted to address critical IT/SQL infrastructure issues including but not limited to, production support, development of disaster recovery and high availability. Hardware and systems documentation.

Confidential, Billerica, MA

SQL Database Management/Enterprise Architect/Project Management

Responsibilities:

• Managed multiple projects for client, including BPC, DR, HA for all internal applications/server. Systems included Great Plain, Data Warehouse and BO infrastructure, Sales Commissions System, Billing Systems and others.
• Responsibilities included, Business Requirement Gathering, Project Planning, Resource Planning and Scheduling, identification of deliverables and benchmarks.
• Existing infrastructure includes a mix of ESX VMs and Physical hardware.
• Some backend storage on Internal Server disks as well as older, NetApp storage. Initially found a mixture of Production and Non-Production systems using same hardware. Worked to segregate those to different servers followed by Backups to Replicating Disk (NetApp across CoLos in NYC and Boston).
• Secured new hardware and VMs at each CoLo to migrate and upgrade several production systems utilizing DR plans developed and tested.
• Documented a plan to provide HA via use of a combination of VMs and Clustered SQL Servers.
• BI initiatives for SQL Server 2005 Data Warehouse and BO Universes.
• Sox compliance for all SQL Server systems - company has just gone public requiring a fast track to compliance.
• Migration of SQL Server 2000 warehouses to SQL Server 2005 (including rewrites of DTS to SSIS ETL Packages)

Confidential, Waltham, MA

SQL DBA/Project Management

Responsibilities:

• Managed migration projects for Client.
• Client had the need to upgrade and migrate all production database systems to High Availability Clusters.
• The infrastructure includes a mixture of Replication and Logs Shipping for purposes of sharing data.
• Systems include 5 servers to be replaced with 2 single servers and 2 clustered (active/passive) servers.
• Migration to new hardware to include fully documenting all Replication processes as well as Log Shipping.
• Current systems are SQL2005 with the new systems moving to SQL 2008 on Windows 2008 - multiple multi-TB sized databases.
• DR and HA Plans produced and tested for all new systems and processes.
• Project also required the automation of numerous tasks via use of SSIS.
• Monthly custom database extracts generated for multiple clients in excess of 10 GB each.
• Processes evaluated for performance increases and code and process changes tested and implemented as needed.

Confidential, Woburn, MA

SQL DBA

Responsibilities:

• Client poised for tremendous growth but had serious performance issues with their SQL Server based business processes.
• Project is focused on several areas. First is to stabilize the current core SQL Servers and to them move on to identification of root causes for performance issues.
• Areas of analysis ranged from core Medical Coding systems through the BI infrastructure - use and design review of all ETL and Data Warehouse designs and processes.
• Business Objects environment also reviewed for efficiencies. Second area of focus has been the development of monitoring processes to document poorly performing code and tie back to originating application or interface.
• Also has included the implementation of performance tuning across numerous production systems.
• Third focus has been to define best practices for both Production Support of SQL Server systems as well as best practices for SQL Code review and performance testing of code.
• Some implementation of Load Testing also included. ETL processing included HL7 feeds.

Confidential, Waltham, MA

SSIS/Data Warehouse Developer

Responsibilities:

• Project has been to scale up and develop the next generation of the companies industry leading product.
• Product analyzes anonymous set-top box data from satellite and cable systems, adds in data obtained from other companies, including consumers' purchasing habits and locations, and updates daily via data warehouse and analytics advertising related data.
• Provides advertisers and client TV providers the ability to target their advertising over these systems.
• Development of several dozen SSIS packages - working under extremely tight deadlines
• Utilization of Partitioned tables for enhanced data loading and data archiving
• Provide database design feedback to development teams with respect to performance and scalability issues

Confidential, Westwood, MA

Database Systems Engineer/ Project Management

Responsibilities:

• Managed multiple projects for client.
• This included numerous system migrations and upgrades, data center migration for all SQL Server database systems.
• Lead DBA for 2 man DBA team supporting primarily SQL Server 2000, 2005 and 2008 systems.
• Responsible for all support issues for production systems and newly deployed OLAP/SSAS data warehouse.
• Heavily involved with several key development projects with outside business partners utilizing replicated databases pushed across internet and vpn connections.
• Outside clients include major Asian partners in China and Korea as well as US partners in California and additional overseas partners in the UK and Russia.
• Have also been heavily involved with process improvement for management of all SQL Server QA management procedures.
• Developed improvements to the Life Cycle as it pertains to testing and validation of SQL Serve.
• Developed and deployed incremental improvements in Disaster Recovery and Preventive Maintenance within the current hardware and bandwidth constraints.
• Most recent project has been the migration of two geographically dispersed data centers to a new centralized data center.
• This has included the definition of hardware requirements and development of strategies and plans for minimizing application downtime given the current sets of technological and resource constraints. Technology includes both EMC Clarion and EMC DMX storage.
• Migrations of several applications from SQL 2000 to SQL 2005.
• Numerous SQL Cluster deployments and upgrades. Support of BI group along with additional help with SSRS report design. Key DBA resource for core engineering teams of current and new products.
• Support and development of the SSIS environment. Daily management of all ETL processes in Production.
• Responsible for the support of the Development and QA environments. BI Development of SSAS, MDX/Cubes.
• Establishment of a professionally run SQL DBA Group responsible for full ‘ownership’ of all SQL Server database standards and issue
• Central resource for all SQL Server development - stored procedures, functions, ETL processes etc.
• Development and implementation of SQL Server Standards - design and management
• SQL Server Analysis Services - MDX/Cube development
• Design and deployment of Disaster Recovery plans for all production database systems.
• Implementation of Performance and Reliability monitoring of all Product, QA and Development SQL Servers
• Migration plans for Data Center consolidation. Included but not limited to Server migrations, hardware relocations, development of new hardware requirements, acquisition of new hardware, server consolidations.
• Documentation and management of change control procedures for all SQL Servers
• Migration from Clarion to DMX EMC Storage
• Implementation and management of ODS and Data Warehouses
• Implementation of SQL Server 2008
• Technical support for Asian business partners in Korea and China.
• Technical support for business partners in UK and Russia
• Upgrades from SQL Server 2000 to SQL Server 2005 64 bit clusters
• Support of MSMQ Messaging layer running between Game Servers and Database Servers
• Provide 24/7 support for all production SQL Server systems

Confidential, Wilmington, MA

Database Systems Engineer

Responsibilities:

• Scalability issues addressed via combinations of Log Shipping, Replication (one way and merge), mirroring.
• Disaster Recovery plans (including but not limited to fail over server, clustering, backup planning)
• Identification of key monitoring statistics (performance monitor counters, profiler counters etc)
• Implementation of SQL Alerts for monitoring system performance.
• Database/Architectural work on production designs to meet new scale out needs for new phase of much larger clients.

Confidential, Waltham, MA

Project Manager

Responsibilities:

• Provided Subject Matter Expertise (SQL Server 2005) to development team charged with upgrading Security/Authentication layer of all Confidential ’s products.
• Provided SQL Server expertise in the development of extensive ‘stress tests’ and ‘load tests’ for all Confidential online products
• Various Performance tuning endeavors
• Worked with Microsoft Engineers to identify and address load specific bugs in the Microsoft SQL Server 2005 product. Resulted in the release of a significant ‘Denial of Service’ related patch

Confidential, Wilmington, MA

Database Architect/DBA

Responsibilities:

• Review and document current production systems.
• Prepare Hardware Requirements documentation for new and upscaled clients
• Development of a Data Archiving solution.
• Migration of design to SQL Server 2005 from SQL 2000.
• Migration and rewrite of DTS to SSIS
• Performance management via index maintenance and performance monitoring