As a seasoned Staff Database Reliability Engineer (DBRE) specializing in Microsoft SQL Server, I possess a wealth of experience in designing, implementing, and maintaining highly available and scalable SQL Server database systems. With a deep understanding of the inner workings of SQL Server, I am committed to delivering optimized solutions that meet the specific needs of each project.My expertise in SQL Server includes performance tuning, query optimization, high availability and disaster recovery, backup and recovery, security, and automation. I am well-versed in SQL Server administration, monitoring, and troubleshooting. Over my career, I have supported production environments running all versions of SQL Server from 2000 to 2022, including pre-release collaboration with Microsoft as part of their Early Adopter Program.

BostonSQL is a user group for SQL Server and other Microsoft Data Platform technologies. We provide a venue to grow, strengthen, and educate the SQL Server community in downtown Boston.Our mission is to foster a community where data professionals can help one another through networking, education, and sharing our experiences.All data professionals are welcome, including developers, DBAs, architects, report writers, BI professionals, or any other job title. During our meetings, we provide a chance for attendees to connect, share, and learn. You have the opportunity to network with other attendees, share war stories, eat pizza, and receive training from both local speakers and big-name database celebrities.

• Tasked with improving database reliability and performance aspects of our primary SQL Server infrastructure• As part of 50-person team, worked heavily with DB Infrastructure & DB Operations sub-teams to improve stability & operational efficiency• Built out documentation defining standard specs for different server classes of our SQL Server fleet, allowing our hundreds of servers to be categorized for purposes of building standard configurations & supporting different SLOs based on the server class.• Migrated disparate troubleshooting docs & KB docs from multiple sources into a consolidated troubleshooting book, allowing infrastructure team to be• Worked with multiple teams to determine proper scaling of infrastructure to evaluate proper server sizes for standard operations, and “scaled up” configuration for use during Holiday, WayDay, and other major sales events.• Lead technical resource for database incident response—participating by both leading incident response with dozens of actors, as well as performing technical troubleshooting during and after incidents, and post-incident root cause analysis & remediation to prevent recurrences.

• Responsible for identifying, executing, and promoting product strategies that position SentryOne as a leader in providing software tools that enable Data Performance Management for Microsoft technologies• Assist with maintaining long-term roadmaps focusing on solving pervasive market problems for our customers• Maintain a well-groomed backlog of detailed requirements for development & testing across product offerings• Maintain a high level of personal industry involvement and education in order to recognize gaps in product offerings as well as future product opportunities• Work with the technical documentation & product marketing groups to promote product functionality & benefits• Review marketing materials and adjust where needed to best position the product• Serve as a community driver for SentryOne, helping conceive and execute strategies to drive awareness of SentryOne in the data community through online & in-person channels

• Planned & executed an upgrade from SQL Server 2008 to SQL Server 2017, including a move from Failover Cluster Instances to Availability Groups• Through aggressive performance tuning, reduced CPU utilization across entire production environment→ Reduced CPU utilization on primary SQL Server instance from 60% to 18%→ Consolidated three SQL Server instances to a single instance, reducing SQL Server licensing costs • Worked with development team to implement best practices around connection pooling, parameterization of queries, caching, and proper use of isolation levels• Implemented source control for all schema & code, allowing the company to easily synchronize databases across production & non-production environments

SQLSaturdays are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers.

• Service Architect for SQL Server & Microsoft Data Platform for both Azure & on-premises infrastructure• Worked with business teams to develop server architecture to meet project requirements, including HA/DR, business, and application needs• Primary contact for relationship with our DBA Services vendor for monitoring & staff augmentation• Developed key metrics and reports to show Total Cost of Ownership for SQL Server environment, including server-level cost reports used for departmental cost show back• Introduced Power BI to reporting environment to help facilitate executive-level dashboards

• Supported databases for internally-developed applications for broker/dealer-RIA with over $100B AUM• Successfully turned around project to upgrade from SQL Server 2008R2 to SQL Server 2014, including migration from Failover Cluster Instances to Availability Groups→ Leveraged existing hardware purchase and project goals to develop migration plan and execute migration• Implemented standardized backups, maintenance, and monitoring of all database systems• Worked with developers to identify and tune poorly-performing code• Mentored Junior DBAs, focusing on education and professional growth, as well as day-to-day prioritization

• Support high-availability (99.999% uptime) for $1.3 Billion e-commerce company—including e-commerce website, manufacturing, website hosting, and internal applications• Assist in zero-downtime database release process for three-week release cycle• Planned & executed multiple hardware migrations with zero downtime.→ Developed a method to update system tables directly, which allows hardware migrations without downtime to replication• Planned & executed performance tuning on production report server to reduce average CPU from 25% to 10%, allowing company to delay hardware upgrade by two years• Created internal enterprise-scale SSRS environment that included separate development & production sites with self-service deployment mechanism• Re-wrote performance monitoring code to improve reliability & scalability, making centralized collection more stable, and facilitating additions of new monitor metrics and new servers• Scripted routine tasks to increase automation and reduce repetitive manual tasks

• Ensure high availability of large hosting environment, including 24x7 on call rotation→ Hosting environment consists of apx 100 SQL instances & 10,000 databases. → Median database size apx 20GB. Largest database apx 6+ TB.• Assist Oracle team in SQL performance tuning SQL & PL/SQL queries and procedures• Develop utility scripts & stored procedures for use in daily maintenance, troubleshooting, and operations• Act as fourth tier support for complex support issues for hosted clients, including performance analysis & tuning• Perform troubleshooting, resolution, and root cause analysis for database & application-specific incidents/events• Document policies, processes, and procedures, such as server build process and issue resolution • Completed project working with EMC² to implement Data Domain as backup device for all hosted databases

• Provided high-level technical support for Team Approach clients running Oracle Forms-based software and Oracle databases• Supervised 5 direct reports on Technical Support team, serving as a primary technical resource & product specialist for entire team.• Participated in planning & execution of strategic initiatives for Technical Support team• Developed, tested, and deployed bug fixes, data fixes, and bug fix backports to resolve client issues• Created SSRS reports for external and internal use, reporting on client tickets and Support Team metrics• Performed troubleshooting & optimization for performance issues—including performance-tuning of SQL & PL/SQL code, as well as index & database-level changes to improve performance

• Developed custom SSRS reports based on clinical data from inpatient Electronic Medical Record (EMR)• Provided high-level technical support for inpatient EMR• Worked closely with hospital SQL Server DBAs to ensure optimal performance for application & reporting

• Provided technical support for web-based digital service aggregator and comparison shopping products.• Responsible for ensuring Customer Care Team responded to and resolved e-mail and phone support issues in a timely manner.• Performed troubleshooting of XML-based, real-time integrations with DSL, Broadband, Cable, and Satellite providers.• Wrote and executed complex T-SQL queries for ad hoc reporting requests from clients.

• Provided advanced technical support for 35 client colleges/universities using the software suite• Worked closely with Chief Technical Officer and President in finalizing all product enhancement specifications• Liaison to Development Team for all support issues requiring escalation for resolution of software defects• Coordinated QA testing to ensure all modules/features are tested prior to software release• Worked closely with CTO to prioritize and coordinate developer efforts to maximize product stability• Analyzed performance statistics & SQL database profiles from Client systems; provide detailed reports for development team on performance

• Involved in over 30 implementations of Practice Management Systems and Electronic Health Records at college/university health services• Worked closely with clients to ensure smooth transition from old to new systems with minimal disruption of workflow and daily process• Streamlined deployment process to save resources during installation and training by developing standard guidelines, processes, and best practices.• Managed up to four implementation team members for all aspects of new software installations.• Worked with other medical system vendors to develop, test, and deploy HL7 interfaces between systems—including Quest Diagnostics, and other LIS and Pharmacy systems.• Worked with college/university IS groups for developing file-based interfaces for demographics downloads from, and financial uploads to university bursar systems—including SunGuard Higher Education, PeopleSoft, and SIS.