Shayne Cooper Email & Phone Number

Stuttgart, Baden-Württemberg, Germany

• Extensive technical experience with designing, building, installing, configuring, and supporting SQL Server 2016, 2014, and 2012. • Hands-on experience with SQL Server Availability Groups, database mirroring and replication. • Strong understanding of database structures, theories, principles, and practices. • Adept at database tuning and troubleshooting utilizing native tools. • Planned and coordinated the migration of data to a newer version of a database management system.

Ogden, Utah

• Participated in technical working groups for the development of standardized security solutions for the SQL Server infrastructure across the enterprise. • Provided consulting, technical expertise and problem resolutions for application programs and system interfaces connecting to current versions of Microsoft SQL Server. • Managed security on instances and databases to include users, roles, securables and permissions. • Monitored audit log space consumption, database backup performance and retention, and maintenance job completion statuses.

Clearfield, Utah

• Provided administration expertise on Microsoft SQL Server versions 2008 R2, 2012, and 2016. • Monitored SQL performance utilizing Solarwinds Database Performance Analyzer and native SQL tools. • Optimized performance of commercial application stored procedures and queries by implementing and tuning plan guides. • Standardized maintenance jobs and tasks for index rebuild / reorganize, statistics updates and dbcc commands

• Performed SQL Server 2014 and 2016 installations and upgrades including SSAS, SSIS, SSRS and FullText and Semantic Extractions components on virtualized Windows Server 2012 R2 servers. • Employed RedGate SQL Monitor, SQL audits, triggers and database mail to monitor and report on DDL events, security changes and server health. • Implemented Change Data Capture and SSIS packages to replicate data between environments without trust relationships. • Created functions, stored procedures, and SQL Agent jobs to automate backups of availability group databases.

Pocatello, Idaho Area

• Served as SQL server subject matter expert and mentor for DBA team members. • Installed and configured SQL Server 2014 instances utilizing multi-subnet AlwaysOn High Availability spanning datacenters, Windows Server Failover Clustering and stand-alone servers.• Migrated SQL cluster dependent drives between SANs. • Implemented security controls pursuant to DISA’s SQL Server 2012 STIG. Administered SQL Server instances on virtualized Windows server platforms in different security enclaves.

Millington, Tn

• Designed and implemented SQL Server 2012 solutions with instances that utilizes AlwaysOn Availability Groups with multiple secondary replicas and multi-node SQL Server failover clusters on Windows Server 2012 R2 platforms. • Converted legacy DTS packages to SSIS packages and optimized data and control flows of existing SSIS packages. • Assisted development team with creation, modification and performance of stored procedures, user-defined functions, views and data element definitions. • Monitored SQL Server 2008 instances in the production, test and development environments to ensure availability and optimal performance.

Kabul, Afghanistan

North Charleston, Sc - Spawar System Center Atlantic

Millington, Tn - Navy Personnel Command