Sql Server Database Administrator

Mark Thornton, Senior Database Administrator

Sammamish, 98075, Wa, 425/443-0319, *********@*****.*** SUMMARY Dynamic Senior Database Administrator with over 20 years of experience managing SQL Server environments. Proficient in Azure migrations, performance tuning, and implementing advanced database solutions, including Always On and replication strategies. Successfully supported over 1000 SQL Servers at Microsoft, contributing to significant improvements in uptime and efficiency. Proven track record in enhancing disaster recovery processes and optimizing database performance. Eager to leverage expertise in data management and cloud solutions to drive exceptional results in a remote role. WORK EXPERIENCE

03/2016 – Present SQL SERVER DBA, MICROSOFT REDMOND Monitored and supported approximately 1,000 SQL Servers for the XBOX gaming platform across development, testing, and production environments.

Participated in a 24/7 on-call rotation to address immediate database issues.

Executed daily SQL DBA functions, including patching, troubleshooting failed jobs, managing security concerns, mitigating service outages, and optimizing replication, Always On, mirroring, log shipping, and clustering. Currently overseeing the migration and upgrade of SQL Server 2014 and SQL Server 2016 on-premises servers to Azure IaaS VMs running SQL Server 2019 and Windows 2019.

Provisioned Azure VMs, load balancers, disks, NICs, storage accounts, and availability sets through various techniques, including PowerShell, ARM templates (JSON), and Azure CLI.

Engineered and refined PowerShell and CMD scripts to automate DBA tasks.

Orchestrated code and schema changes across all environments to ensure database integrity and performance.

Created and optimized PowerShell scripts to automate the provisioning of Azure resources (VMs, load balancers, storage accounts, etc.) required for Always On availability groups and clustering.

Developed and modified PowerShell scripts to manage disk allocation and configuration of new VMs in Azure.

Gained substantial experience in implementing log shipping, mirroring, replication, and Always On configurations.

07/2014 – 03/2016 SQL SERVER DBA, MICROSOFT REDMOND Implemented code and schema changes in Production, Development, and Test environments for MS Universal Store (XBOX).

Supported and maintained SQL Server 2008 servers configured for transactional replication and log shipping.

Executed monthly Microsoft security patches for approximately 200 primary, secondary, and disaster recovery SQL Servers using PowerShell scripting.

04/2013 – 07/2014 SQL SERVER DBA, ECOVA SPOKANE

Supported internal business applications utilizing SQL Server 6.5, SQL Server 7, SQL Server 2008 (R2), and SQL Server 2012. Provided extensive support, including monitoring performance, analyzing production code rollouts, troubleshooting process issues, generating SSRS and SSIS reports, conducting log shipping, and performing disaster recovery analysis.

Demonstrated proficiency with SVN, SQL Sentry for tracking disk space, CPU usage, and memory performance, as well as developing backup strategies.

Installed and patched SQL Server while promptly addressing daily client requests.

09/2012 – 04/2013 SR. SQL SERVER DBA, COINSTAR BELLEVUE Managed SQL Server production databases utilizing versions 2005, 2008 R2, and 2012.

Oversaw administrative functions across all supported SQL Server environments.

Conducted performance tuning, troubleshooting, and disaster recovery activities.

Facilitated SQL code rollouts, data modifications, DDL changes, log shipping, transactional replication, and modifications to SSIS packages. Acquired experience with SQL clustering in an active/passive multiple-node environment.

Familiarized with SCOM, Litespeed, Spotlight, and SQL Sentry SQL Server support tools.

04/2009 – 09/2012 SQL SERVER DBA, SANMAR ISSAQUAH

Performed SQL Server production DBA duties utilizing SQL Server 2000, 2005, and 2008.

Managed administrative functions in development, testing, staging, and production environments.

Engaged in performance tuning, troubleshooting, and disaster recovery planning.

Oversaw the SQL code rollout, data modifications, and schema changes. Executed log shipping and SSIS operations.

Developed skills in database clustering.

04/2008 – 04/2009 SQL SERVER DBA, ONVIA SEATTLE

Played a key role as one of two DBAs managing SQL Server administration tasks for a small online company.

Executed core responsibilities such as refreshing lower environments

(Development, Build, QA, Staging).

Worked with SQL Server 2000 and some SQL Server 2005 instances. Handled log shipping, Full Text Indexing, and transactional replication. 10/2006 – 04/2008 SQL SERVER DBA, ONVIA SEATTLE

Contributed as one of two DBAs managing SQL Server administration tasks within a small online company.

Central responsibilities included refreshing lower environments

(Development, Build, QA, Staging).

Mainly worked with SQL Server 2000, supplemented by SQL Server 2005. Converted a custom log shipping solution into standard SQL Server log shipping.

Established transactional replication to create a reporting database, replacing the previous custom log shipping method. Managed 'propping' code changes across all environments, including production.

Implemented Litespeed in the production environment to enhance backup file management.

07/2006 – 10/2006 SQL SERVER DBA (CONTRACT), PEMCO INSURANCE SEATTLE Oversaw day-to-day operations for approximately 50 SQL Server databases running SQL Server 7, 2000, and 2005.

Resolved job failures and performance issues related to SQL Server. Recommended enhancements to daily procedures concerning backup and recovery strategies, notifications of job failures, and overall administrative tasks.

Collaborated in a team responsible for implementing a sliding partition setup for a VLDB, enabling faster data archival using SQL Server 2005. Provided data to customers based on specifications using T-SQL coding. 04/2003 – 07/2006 SQL SERVER DBA, T-Mobile BOTHELL Administered over 100 production, test, development, and staging SQL servers using SQL 2000.

Performed essential DBA tasks, ensuring database backups and integrity checking.

Provided 24/7 support in accordance with service level agreements defined by the business.

Facilitated the rollout of new and hotfix application code, alongside SQL code reviews.

Managed on-call and secondary on-call duties, addressing code rollouts and system issues.

Participated in developing internal documentation outlining SQL DBA standards and procedures.

Responsible for installing SQL Server, Service Packs, and Analysis Services in both standalone and clustered environments. 03/2002 – 04/2003 SQL SERVER DBA (CONTRACT), Expedia.com BELLEVUE Administered internal database servers, managing test, development, and production SQL servers running SQL 2000 and 7.0.

Performed basic DBA tasks, ensuring database backups and integrity checks.

Delivered 24/7 support as per service level agreements established by the business.

Oversaw the rollout of new and hotfix application code, along with SQL code reviews.

Addressed on-call duties, including code rollouts and troubleshooting system problems.

Responded to internal customer requests encompassing ad hoc queries, permission issues, and backup strategies.

02/2000 – 03/2002 SQL SERVER DBA, CapitalStream SEATTLE Executed code releases (patches) and software builds related to SQL Server.

Administered daily operations, including backups, restores, DBCCs, application troubleshooting, performance tuning, transactional replication, log shipping, and disaster recovery measures.

Developed daily jobs for backups and DBCC operations using T-SQL as a standard for all production SQL servers.

Instituted a warm standby server for the production database via log shipping as part of a disaster recovery initiative. Managed administration tasks for QA, sales, development, and training environments.

Worked with SQL 7.0 SP3 and SQL 2000 environments, ensuring optimal performance.

Oversaw the production environment using Microsoft Cluster Server in an active/passive configuration, utilizing RAID 0+1 and RAID 5 in a SAN environment.

Created stored procedures and batch jobs to support internal operational needs.

05/1998 – 02/2000 SQL SERVER DBA, VoiceStream Wireless BOTHELL Executed daily DBA tasks involving login management, performing DBCC operations, and executing backups for SQL Server 6.5 and 7.0. Diagnosed production issues and offered strategic solutions. Managed the implementation of production enhancements and changes. Successfully upgraded the environment from SQL Server 6.5 to 7.0. Performed tuning tasks, including adding clustered and non-clustered indexes to production tables.

EDUCATION

1984 – 1988 Washington State University

B.S., General Science

Pullman

SKILLS SQL Server SQL Server 6.5

SQL Server 7 SQL Server 2000

SQL Server 2005 SQL Server 2008

SQL Server 2008 R2 SQL Server 2012

SQL Server 2014 SQL Server 2016

SQL Server 2019 Powershell

ARM templates (json) Azure cli

T-SQL SSRS

SSIS SVN

vSphere SCOM

Litespeed Spotlight

SQL Sentry Performance Tuning

Troubleshooting DR

Customer support Team player

AlwaysOn Availability Groups Transactional Replication Azure SQL Migration Database Monitoring

Backup and Restore Procedures Azure Data Factory

Communication Skills Self-Motivated

Azure Virtual Machines

Contact this candidate