Kenmore, Washington, United States
An experienced Database Administrator with proven technical, leadership, and communication skills. Able to apply creativity, vision, and technical skills to design, develop and/or support database systems. Adept in collaboration with other infrastructure teams, application support teams, developers and end users. Exceptional ability to multitask and support multiple priorities in dynamic environments.
+ Currently working full-time remotely, from Central Washington. + Deployed several traditional SQL Server Clusters, and AlwaysOn Availability Groups with SQL 2012/2014/2016. + Standardizing the platform, developing consistent configuration and maintenance across a SQL Server infrastructure including SQL 2005/2008r2/2012/2014/2016. + Providing support for very rapid development by multiple development teams. + Providing design, support for database disaster recovery solutions. + Delving back into Oracle, providing project support. + Initiated into the world of AWS and Azure, with both Oracle and SQL environments.
Roles as both a SQL Server DBA and a transition to MySQL for part of this tenure.
+ Led virtualization efforts of SQL Server with the use of the VMWare platform. Developed templates used globally. Worked closely with the Windows Server team to determine limitations and where value is greatest for virtualization. + Led the implementation of SQL Clustering to provide local high availability for specific applications. + Implemented a variety of technologies, including SQL Mirroring, SQL Replication, Linked Server, EMC SRDF/A replication, and SQL Log Shipping. + Participated in the design of nearly every SQL Server systems in Starbucks supported by IT. This included the architecture and design of the point of sale store systems and the Starbucks.com platforms. + Provided project leadership in many SQL sustainment projects, including upgrades, migrations and consolidations. + SQL Leadership in disaster recovery planning sessions and exercises.
+ Coordinated the Oracle server migrations involved in a primary data center move. + Primary support provider for the SAP HR system, requiring monitoring and support for performance, application patching and development. + Implemented and evangelized the use of RMAN as a backup solution. + Supported a number of support systems, including Remedy, Control M, and a custom store site management system. Routine development and tuning work was necessary for success. + Architected and deployed a new Control M platform, with local hardware redundancy as well as a disaster recovery standby (via Oracle Data Guard). + Provided project leadership in many Oracle sustainment projects, including upgrades, migrations and consolidations.
+ Member of a 3 person DBA team with 24x7 support of a production Oracle ERP system, along with several subsidiary database applications. + Supported a number of test and development systems, along with requisite cloning processes. + Implemented a quarterly database/application recovery exercise, and initiated a group to perform gap analysis of disaster recovery capabilities. + Managed and supported several small upgrade projects.
+ Provided back-end database efforts to support the cingular.com website. Included: - Automation of manual processes through stored database objects (packages/procedures). - Data validation scripting and objects. - Creation and support of a development database. + Created documentation for an undocumented legacy system. + Data modeling and provided recommendations for database structure. + Provided initial design and development of a data purge process for the production order database. + Provided general Oracle database support/assistance/education as needed for peers and developers.