Bryan Cooper Email & Phone Number

Redmond, Washington, Us

Migrated Databases for High-Profile Profile Healthcare Product• Migrated databases from MySQL to Azure SQL with no data loss and minimal downtime• Designed the new solution with a focus on security, uptime, and performance for an optimal customer experience• Disabled public access, utilizing only private endpoints• Employed managed identities for application authentication• Implemented Entra ID for individual authentication and leveraged Privileged Identity Management for just-in-time, time-bound access• Utilized Failover Groups to minimize downtime during failovers• Leveraged Availability Zones to maximize uptime• Used SQL Server Migration Assistant and Azure Data Factory for data migration• Developed and tested a detailed runbook to ensure success• Drove continuous performance optimizations to improve customer experience and contain costs• Achieved cost reductions while significantly improving uptimeData Retention and Compliance• Automated copying of data to cold storage using Azure Data Factory for long-term retention, redacting sensitive data• Utilized Azure Function Apps on a scheduled execution to purge data outside the retention periodCost-Containment and Reduction• Conducted regular capacity reviews• Implemented Serverless to reduce costs• Recommended capacity reduction for over-provisioned servicesTrusted Advisor to Engineering Teams• Provided guidance on architecture and best practices• Advised on tenancy modeling• Assisted with copying data between Azure tenants• Offered expertise in performance tuning

Burlington, Ma, Us

Migrated databases for our flagship healthcare product from on-premises SQL Server to Azure SQL with no data loss and minimal downtimeDrove continuous performance optimizations to improve customer experience and contain costs• Improvements supported exponential customer growth while improving uptime and keeping costs flat• Pivoted database from frequent outages to 100% uptime for over a yearImplemented solutions to meet High Availability and Disaster Recovery requirementsImplemented monitoring to warn of emerging problems before customers were impactedSecurity hardening to align with best practicesStandardized and scripted database deployments, significantly streamlining the deployment process of our flagship product to 5 international locationsAdoption of Serverless, Elastic Pools, and Hyperscale technologies to reduce data costsAutomation of processes using Azure Pipelines to reduce labor and inconsistenciesImplementation of Availability Zones to meet uptime goalsContributed to the Data Engineering playbook to establish best practices across the divisionDocumentation of procedures and policies to ensure optimal and consistent outcomes, and to facilitate successionMentoring of junior engineersCapacity management, providing a balance between cost optimization and required resourcesFacilitation of Data Engineering Committee to share knowledge and collaborateLead a data quality evaluation for a key data set, providing a status and recommendations for improvements

Boise, Idaho, Us

• Building and optimizing SQL Server and PostgreSQL installations• Implementation of backup and restores• Establishment of Disaster Recovery using log shipping• Documentation of procedures for re-use by team members• Creation of restores for pre-production environments from flash storage• Developed a method to change the primary key on a billion-row table without downtime• Partner with development to ensure optimal data solutions

New Plymouth, Id, Us

Key database professional administering solutions for a high-traffic website• Design and implement successful database solutions that integrate with legacy systems• Develop and tune stored procedures for optimal performance• Empower management through the creation of self-service reporting• Use of SSIS to share data and integrate with partner companies• Provide replication solutions to ensure scalability• Excellent rapport with developers, working as a team to provide the best solution

Boise, Idaho, Us

Administer all aspects of computer, network, and telecommunications systems including analysis, purchasing, installation, support, troubleshooting, end-user support, database administration, and network administration.

Boise, Idaho, Us

Database design, creation, maintenance, tuning, query optimization, SSIS, DTS, replication, backup. Assist developers in creating and optimizing stored procedures. Migration of databases from Sybase to SQL Server.

Boise, Idaho, Us

2005 - 2006: Member of the Fab Software Support team. Deliver training on manufacturing software for the help desk; created troubleshooting guides to assist the help desk and 2nd-level support in solving problems; setup monitoring of critical systems to provide early warning of problems and reduce production downtime. Provide 3rd-level and 24x7 oncall support. Development of T-SQL code to troubleshoot and provide information to customers.2000 - 2005: Member of the Process Management software team developing and supporting applications providing critical data for accurate wafer fabrication by manufacturing tools. Provide services such as project management, systems analysis and design, database design, SQL coding and query optimization, and triggers. Participate in all phases of the Software Development Life Cycle. Recognized as the go-to person for all things database-related.1994 - 2000: Member of the Planning software team developing and supporting factory floor scheduling, and tool capacity and utilization applications. The primary team member for database design and stored procedure development and optimization. Utilized some data warehousing concepts to speed up data retrieval.1991 - 1994: Member of the Fabrication software team developing and supporting the Manufacturing Execution System (MES) and equipment tracking software.

Cheney, Wa, Us

Bachelor Of Science - Bs, Information Technology

Computer Science

Associate Of Science - As, Computer Science