For a Canadian based manufacturing company, migrating and upgrading a SQL 2014 Server to SQL 2022 and performing an in-place upgrade of their Syspro8 ERP SQL Server. Maintenance.

For a top 10 law firm:For four years in a row I've provided training, advice, and mentorship to their DBAs on their SQL Server 2019 EE two node availability group clusters running on VMWare. I've worked with them to implement page compression as well as upgrading to SQL 2019, index tuning, ETL job tuning, and replication tuning.

For a software company that provides SaaS solutions hosted in Azure:I was contracted to provide root cause analysis, solution(s) as PoCs, and documentation/training for performance problems on Azure VMs hosting SQL Servers and Azure SQL databases. Configured and tuned snapshot and transactional replication between Azure VMs and Azure SQL databases in an elastic pool. Configured read-scale clusterless domain independent availability groups on Azure VMs.

For a FinTech startup:"Responsible for all things data". Upgraded, managed, monitored, tuned, and rightsized six AWS RDS SQL 2022 instances, including Multi-AZ AGs. Implemented SQL native backups to s3 and created a long-term retention policy for end of month backup storage in Glacier. Implemented Windows Active Directory (AD) authentication to RDS. Guided developers in the best ways to design databases, tables, views, and columns including remediating past inefficiencies. Right sized data fields from global sizing as nvarchar(max). Identified and removed duplicate and inactive data from OLTP systems. Created data imports and exports to a datalake using AWS Glue, Python, and SQL queries/stored procedures. Reviewed and approved/rejected (with instruction for corrections) of all developer PRs (Azure DevOps) that touched AWS RDS SQL Server databases. Reviewed and tuned stored procedures. Reviewed, dropped, added, and altered indexes for best performance. Provided documentation via ADO. Participated as a key member in initial SOC 2 compliance certification.Reduced AWS RDS, storage, and s3 costs by about 70% while also increasing performance.Using Azure Data Studio, Azure DevOps, Active Directory, AWS SQL RDS, AWS Glue, AWS CloudWatch, Grafana, GitHub, JetBrains, Kubernetes, SSMS, S3, Terraform, Visual Studio Code.* Domain Administrator, AWS Administrator and Azure Administrator

For a global investment management company:Used Terraform and PowerShell with GitLab to build Windows Server 2022 clusters for SQL Server 2017/2019/2022 Enterprise Edition with four node availability groups with multi availability zone listeners for migration to AWS EC2 instances while establishing and implementing best practices. Prototyped and benchmarked tested AWS FSxN (NetApp) shared storage. Used SQLIO, CrystalDiskMark, and SQLQueryStress for storage and query performance tests. Used SAN snapshots and Rubrik for backups and lower environment refreshes. Implemented jobs for availability group sync and index maintenance.Troubleshot performance issues like high CPU and blocking and deadlocks on on-prem SQL failover cluster instances with availability groups (FCI+AG) and made recommendations for implementing indexes and database options like read committed snapshot isolation (RCSI) to reduce and eliminate the issues. Implemented gMSA accounts. Implemented an AWS SSM OS patching solution for on-prem Windows Servers running SQL Server.Participated in weekly sprint planning and backlog grooming meetings. Deployed and managed DBA related as well as infrastructure related source code in GitLab repos. Approved developer merge requests in their GitLab CI/CD pipelines. Used various other tools like SQL Sentry, LogicMonitor, JIRA, and Confluence.

For a large logistics company:Using Terraform with Atlantis and GitHub to build Windows Server 2022 Azure Edition clusters for SQL Server 2019 Enterprise Edition with availability groups with multi-subnet listeners for migration to Azure VMs while establishing and implementing best practices. In cases where migrations had already been performed on Windows Server 2016, performed rolling cluster upgrades to eliminate the need for downtime. During the rolling cluster upgrades I was able to use Azure VM instance types and sizes which were priced lower yet more performant for the SQL Server workloads. Corrected SQL Server licensing. Used optimal disk sizing plus striping to further increase performance and availability. Implemented backup to URL as block blob using private endpoint, container level SAS, backup striping and backup encryption using Azure key vault for EKM. Also assessed and recommended sizing changes to reduce costs with Azure SQL Database and Managed Instance (PaaS). Modernized SQL Server deployment, configuration, and maintenance tasks using PowerShell. Configured AppDynamics and Datadog for monitoring and alerting. Identified and remediated problems with gMSA accounts. Monthly savings to the company:$5k Azure SQL DB & Managed Instance monthly savings (50% cost reduction)$100k Azure VMs for SQL Server monthly savings (65% cost reduction)$400k SQL Enterprise Edition and SA licensing 3-year prorated monthly savings (HUGE cost reduction)Provide ongoing troubleshooting and query tuning support for OLTP and data warehouse databases on SQL 2017 and SQL 2019 EE with AGs and readable secondaries.Troubleshoot performance issues like high CPU on Azure SQL DB making recommendations for sizing and implementing new indexes and maintenance. Upgraded compatibility level to SQL Server 2022. Use various other tools like JIRA and Confluence.

Insurance/Reinsurance:Lead a project / trained offshore DBAs from Accenture to migrate and upgrade 600+ SQL servers from SQL 2012 - SQL 2017 to SQL 2019 via remote automation using PowerShell / posh cmdlets like DBATools / DBAChecks with an estimated time savings exceeding 30k DBA hours compared to the initially planned manual migration. Established and implemented best practices for clusters, availability groups, servers, and databases that included security, data compression (page compression), gMSAs (group managed service accounts), and TDE (transparent data encryption) with EKM (extensible key management) using Azure Key Vault. Performance tuned SSIS packages and queries for developers.This project was completed under time and under budget as a direct result of the automation I was able to implement.

Consolidated and upgraded mission critical legacy physical and virtual SQL Servers while implementing high availability (HA) and disaster recovery (DR).Provided operational support through assessment, configuration, optimization, tuning, and patching of SQL Server 2012 – 2019 enterprise and standard standalone instances, Always On Failover Cluster Instances (FCI), and Always On Availability Groups (AG) on physical and VMWare virtual servers.Assisted development teams with table, index, stored procedure, and T-SQL design and performance tuning.Supported multiple and various advanced SQL Server transactional replication topologies.Developed maintenance and backup strategies for multiple VLDBs across the organization including one database that exceeded 20 TB after implementing page compression.Managed and maintained table partitioning.Implemented, managed, and maintained transparent data encryption (TDE).Supported SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).Configured alerts in Solarwinds including writing queries for custom alerts.Technologies and Skills used:• Oracle Virtual Box• HyperV• Projectplace• Okta• Jira• ServiceNow• Solarwinds Orion• VMWare

For a risk management company:Provided server assessments and tuning recommendations for SQL Server 2019 availability groups running on AWS EC2 instances. Provided automation for lower environment database refreshes using PowerShell.

Multiple very small projects:Provided server assessment and recommendations and IT staff training and configured data load jobs, database maintenance jobs, server object sync, and backups for a SQL 2019 two node AOAG cluster on AWS EC2 instances. Implemented page compression and built and rolled in a new cluster node.Provided performance tuning recommendations for an AWS RDS SQL Server database.Trained a DBA to implement table partitioning on a SQL 2017 DWH on an Azure VM for improved performance of data loading and maintenance.

For a large bank:Assessed and delivered best practices, maintenance, and performance tuning recommendations for a SQL 2017 on-prem VMWare distributed availability group consisting of two Windows clusters with Always On availability groups across two data centers.Assessed and delivered best practices, maintenance, and performance tuning recommendations for a SQL 2012 on-prem bare metal Windows Failover Cluster instance with mirroring to a DR node and multiple transactional replication publications to Azure SQL databases in an elastic pool.Repaired, tuned, and maintained SQL transactional replication from on-prem servers to Azure SQL DBs (PaaS).Assessed and delivered best practices, maintenance, and performance tuning recommendations for Azure SQL databases for a mobile banking app.Performance tuned tables, stored procedures, and queries making recommendations to developers to reduce blocking and eliminate deadlocks.Configured alerts in SolarWinds including writing queries for custom alerts.Used Dynatrace.

For manufacturing plants using Infor's MP2 platform:Assessed and upgraded multiple on-prem SQL Server and SSRS servers from SQL 2000 to SQL 2019 and implemented automated backups, maintenance, and alerting. Modified SSRS reports and subscriptions recovering a company from expired SQL Server evaluation edition installations.Assisted another company with SQL Server database recovery after a ransomware attack.

As the lead database administrator for a start-up, while responsible for all aspects of database administration including architecture, infrastructure, operations, maintenance, and costs, I was able to slash the company's annual SQL expenditures in Azure from nearly $500k to $100k, through cleanup, right sizing, reserved instances, and appropriate licensing. Maintained, upgraded, and performance tuned an environment that was 100% in the Azure cloud and included several Microsoft SQL Servers running on Azure VMs as well as Azure SQL Servers, Azure SQL databases, and one Azure Managed Instance.Built new Windows 2019/SQL Server 2017/SQL 2019 Azure VMs, including striped storage and all other necessary resources.Supported SSIS developers, web application developers, and PowerBI users through environment refreshes, code deployments, and performance tuning in an Agile environment.Technologies and Skills used:• Windows Server 2016 - 2019• SQL Server 2016 - 2019, replication, data compression, in-memory, column store, CDC• Data warehouse, ELT, OLAP, OLTP, SSIS, SSRS, PowerBI• Azure Site Recovery (ASR), Azure VM, Azure SQL Server, Azure SQL Database, managed instance, blob storage• DMA, DMS, PAL• Github• Jira• Powershell including Azure CLI and DBATools• Redgate toolbelt, Redgate monitor• Yardi

Responsible for the management, monitoring, and performance tuning of a fleet of almost 100 Microsoft SQL Server servers (across all environments) that ranged from SQL 2000 - to SQL 2017 Enterprise running on Windows Server 2000 - 2019 in a VMWare environment. These servers supported both multi terabyte high volume OLTP systems for medical claims processing and also BI and datawarehouse systems for reporting and analytics and included both Windows Failover Cluster Instances and Windows Failover Clusters with AlwaysOn Availability Groups. Supported log shipping.Built new SQL 2017 Enterprise Servers in Azure, including servers for SSRS, SSAS, and SSIS. These builds included servers with WFC and AOAGs.Technologies and Skills used:• Windows Server 2000 - 2019, WFC, WFCI• SQL Server 2010 - 2017 Standard - Enterprise, failover cluster instances (FCI), AlwaysOn availability groups (AGs), Log Shipping, Transparent Data Encryption (TDE)• Data warehouse, ELT, OLAP, OLTP, SSIS, SSAS, SSRS, PowerBI• Azure VM, blob storage• Redgate, Idera, FogLight• Delphix (data masking)• PagerDuty• PowerShell• ServiceNow

Managed a team of 7 DBAs across North America, Europe, India, and Asia. The team was responsible for the management of approximately 1000 SQL database servers with up to 1000 databases per instance in AWS. These servers and databases supported several of Infor’s SaaS solutions including M3 ( ERP ), InforOS, Ming.le, and ION.Used automation ( devops ) to deploy, configure, and maintain SQL Server AlwaysOn Availability Groups on Windows Clusters running on AWS EC2.Responsible for performance monitoring, tuning, and troubleshooting large multi-terabyte SQL Server databases including replication. Experienced with CDC and DMS.Technologies and Skills used:• Windows Server 2012 and 2016• SQL Server 2012, 2014, and 2016 Standard and Enterprise• Data warehouse, ERP, OLAP, OLTP• AWS CLI, EC2, EBS, S3, SSM, Step Functions, CloudFormation, CodeDeploy• AWS Aurora (Postgres RDS)• Jira• LogicMonitor• PagerDuty• Powershell• ServiceNow • Sumo Logic

Migrated and upgraded all of the agency’s databases and database servers from SQL Server 2014 to Microsoft SQL Server Enterprise Core 2017 running on Windows 2016 Server/VMWare ESX. This includes 75 production databases up to 1 TB (VLDB) in size plus failover, test, development, and reporting servers. Responsible for all aspects of database management including server and storage configuration, installations, upgrades, data migrations, configuration, high availability, log shipping, failover, security, capacity planning, automation, alerts, maintenance plans, job scheduling, data transfer, data integrity, index tuning, performance tuning, query tuning, backups, restores, disaster recovery, documentation, and training. Used a variety of third-party, native, and custom tools and scripts for backup/recovery, deployment, maintenance, monitoring, troubleshooting, and tuning, including Spotlight, Idera, and Redgate.Approved and executed scripts for database changes and upgrades from various third-party application vendors as well as from internal development staff for custom in-house applications. Supported, installed, and upgraded a variety of custom and off-the-shelf database software applications including ESRI ARCGIS, DELTEK Costpoint, Microsoft Sharepoint 2016 both on premise and cloud, Trapeze RidePro, and CyberRecruiter. Used Active Directory to create and manage domain user accounts, OUs, and servers for SQL Server. Previously performed major consolidations/migrations/upgrades from SQL 2000 to SQL 2005, SQL 2005 to SQL 2008, SQL 2008 to SQL 2012, and SQL 2012 to SQL 2014.

Developed, upgraded, and maintained SQL Server 2000/2005 databases, in a Windows Server 2003 VMware ESX environment, including the development of tables, views, and stored procedures. Developed both TSQL stored procedures and CLR stored procedures written in C#.NET. Designed, developed, and maintained both DTS and SSIS packages. Responsible for all aspects of database management including automation, alerts, job scheduling, data transfer, performance and index tuning, backup operations, failover, recovery, snapshots, server moves and upgrades. Used ERwin to reverse engineer models of existing databases for documentation purposes. Developed a company-wide SharePoint 2007 intranet and SQL Server 2005 Reporting Services Solution. Developed and maintained a C# ASP.Net 3.0 internet web site. Upgraded a Crystal Reports reporting solution to Business Objects Enterprise XI and performed ongoing reports development and maintenance. Performed occasional maintenance and enhancements to Visual Basic, Access, Cold Fusion, and JSP windows and web applications. Supported IBM message queues, applications, and servers in a high-availability, 24/7 operation. Used Numara Track-it. Managed relationships and coordinated work with external vendors.

Developed multi-tier data aware intranet and internet applications, including web services and web parts, using ASP.NET 2.0 (VB.NET and C#.NET), XML, LDAP, SQL Server 2005 and/or Oracle 9i. Developed, configured, maintained, and used service-oriented (SOA) software factories for use in a Team Foundation Server environment. Created and used master pages. Developed SQL Server databases including SQL Server Reporting Services (SSRS), tables, views, triggers, stored procedures, and CLR stored procedures written in C#.NET. Used SQL Server Integration Services (SSIS) to import, export, and transform data between SQL Server and other disparate legacy data sources. Used SharePoint 2007 and SQL 2005 to develop an intranet delivered executive reporting

Designed, developed, tested, deployed, and supported multi-user, multi-tier, object-oriented applications written in VB .NET, ADO. NET, SQL Server, and Crystal Reports. Developed web-based, ink-enabled applications for tablet PCs using VB.NET, ASP.NET, ADO.NET, Crystal Reports XI, SQL Server, and XML. Created databases in SQL Server 2000, including tables, views, stored procedures, functions, and triggers. Performed data migrations from legacy databases to SQL Server using DTS and other technologies. Developed application documentation and user guides. Provided user training and second-level help desk support for in-house and third-party applications. Developed data flow diagrams (DFDs) and flowcharts for business process analysis and presentations. Developed and documented application and database development standards and methodologies.