• Team technical lead for performance tuning and automation• Lead efforts to optimize customer facing, back office, and decision support workloads• Lead efforts to automate management tasks via T-SQL, PowerShell, and Azure Automation• Provide operations al performance support for databases on virtual machines, Azure Virtual machines, Azure SQL DB and Azure Managed Instance• Liaison between Chiptle and multiple vendors• Primary liaison to internal application development team• Primary support for monitoring tools• Construct and deliver internal training• Provide architectural support for SQL Server upgrade effort• Identify and execute on optimization/cost saving opportunities in Azure

• Day to day management of SQL Server in support of web-based commerce• Responsible for daily maintenance including backup and indexing• Managed disk utilization across multiple environments• Identified performance tuning opportunities at the instance & query level• Index analysis and implementation• Primary contact between database and infrastructure teams• Primary contact for multiple software vendors• Supported physical and virtual servers• Supported DevOps deployment across multiple environments• Supported transactional replication

• Manage SQL Server Failover Cluster Instance• Manage Always On Availability Groups• Migrate databases• Configure SQL Server to best practices• Perform server assessment relative to best practice and performance• Perform index analysis and recommendation• Query and workload performance tuning• Implementation of recommended indexes• Monitor SQL Server using extended events• Manage SQL Server on physical and virtual servers• Provide guidance to clients in building SQL Server physical and virtual machines• Manage transactional replication• Configure transactional replication• Monitor client SQL Servers via SolarWinds Orion• Manage client disk space issues• Manage Reporting Services security

• Performed analysis of existing SQL Server environment relative to best practice & performance needs• Installed & configured SQL Server in virtual & physical environments• Implemented best practices for configuration• Used monitoring & baselines to adjust server settings to best fit workload• Identified performance tuning opportunities at the instance & query level• Implemented configuration & query changes to address performance issues• Performed & documented analysis of SQL Server environment• Created detailed installation and configuration documentation• Deployed AlwaysOn Availability Group high availability configuration• Deployed SQL Server Failover Cluster Instance• Prepared customer facing Statement of Work Documentation

• Initiated change to SQL server configurations to bring them to best practice• Initiated audit of Recovery Point Objective and Recovery Time Objective with database owners• Performed backup and restoration of database and transaction log files• Implemented scheduled index maintenance across all SQL servers• Implemented scheduled database integrity checking across all SQL servers• Created and managed mirrored SQL databases• Performed manual extraction of data from disparate data sources to load into SQL Server• Installed SQL Server 2008 R2, 2012 and 2014• Automation of tasks using VBScript and PowerShell• Create roadmap of productivity and infrastructure applications included in operating system image• Lead Windows 7 deployment project