- Enterprise administrator/architect for hybrid data-processing, analytics infrastructure consisting of 100+ servers and 85+ TB data (HA/DR), spanning 4 data centers and two private clouds. - Led global Telemetry cloud project using MS Azure, HDInsight (HBase), EventHub, Time Series Insights, and hundreds of IOT endpoints. Resulted in annual savings of $500K+, faster processing and drastically improved data visibility.- Led year-long M&A data integration project, merging legacy Whiting/Oasis Petroleum data/systems/applications. Scope included 3 data centers, two Azure instances, 200+ DB servers, and numerous data warehouses.

• Production/Development DBA for 200+ databases and 20+ TB storage using SQL Server 2016/2017• Responsible for enterprise-wide HA/DR initiative using AlwaysOn, WSFC, and storage-level recovery• Project lead for numerous comprehensive ETL projects using SQL Server Integration Services (SSIS)

• Lead DBA for distributed SQL Server 2012/2016 infrastructure consisting of 25 HA server instances, two data centers, 75+ TB dedicated SAN storage, and extensive BI (ETL, analytics)• Designed and implemented enterprise-wide SQL Server platform migration, leveraging full HA (clustering, AlwaysOn) and CQRS (read/write separation) for 100+ databases and 30+TB total storage• Architected comprehensive SQL Server 2012/2016 SDLC environment (20+ developers/analysts) for multi-million-dollar SAAS application using dedicated instances, storage-level cloning, and TFS 2015• Led project to partition and archive numerous TB+ databases, thus decreasing maintenance windows by over 600% and increasing overall application performance by over 300%• Maintained corporate SOX compliance and PII sensitivity using TDE, cipher, and multi-layer-security

• Enterprise administrator for both SDLC and production SQL Server 2008 R2 environment, consisting of two physical sites, 10 server instances, 50 databases, and 2+ TB storage.• Responsible for development, management, and optimization of OLTP object and comprehensive business intelligence solutions, leveraging Integration, and Reporting Services• Held key role overseeing infrastructure projects relating to data services, including disaster recovery, storage, virtualization, and directory services design and scalability

• Responsible for SQL Server database and storage systems architecture, development, scalability, storage, and high availability for event-driven social media platform• Lead architect for distributed processing environment using SQL Server (OLTP/OLAP) and Attivio AIE• Coordinated development and implementation efforts for 15-person domestic/offshore team using strict change management and TFS/SPS

Presided over Systems, Database, Service Desk, and Data Center teams with 5 direct reports and 30 total team members.• Comprehensive overhaul of help desk operations, including software platform migration, ITIL training/integration, and service/organizational level agreements (SLAs)• Virtual infrastructure consolidation and upgrade, consisting of 25 physical servers running vmWare ESX/ESXi, 2 NetApp SANs (10+TB total storage), and 80 guests running Windows Server• Orchestrated RDBMS remediation initiative (30 SQL Servers / 56 DBs), consisting of enterprise backup compression/consolidation, storage relocation, platform migrations, role separation, business continuity, and data security• Led initiative to strengthen DR plan and data center operations for two physical sites and 120 grocery stores across South Carolina and Georgia.

• Responsible for the planning, implementation, optimization, and maintenance of company-wide SQL Server 2000, 2005, and 2008 OLTP and BI environments.• Headed project to physically and logically relocate SQL Server infrastructure from Cleveland, OH to corporate headquarters in Santa Ana, CA. • Led initiative to institute high availability for all production database resources, including the installation, testing, and certification of two isolated disaster recovery sites. Leveraged technologies such as active/active clustering, multipath SAN connectivity, full network redundancy, transactional replication, log shipping, and Double-Take synchronization.• Headed organization-wide SQL Server 2000 (x86) to 2005 Enterprise (x64) migration project. Coordinated functionality/load testing efforts, rollback strategies, documentation/diagrams, and developer training. Overall performance was increased dramatically for dependent applications.• Designed and instituted detailed SDLC process and supporting infrastructure for ongoing database development and production releases. • Implemented and optimized SQL Server Reporting Services 2008 as the sole replacement for legacy 3rd-party database reporting solutions.• Satisfied several auditing initiatives by designing and overseeing the rollout of multiple local and distributed asynchronous Service Broker conversations.• Managed large scale data conversion for a major application rewrite project. Tasks included database and SSIS package design and deployment.• Established naming/coding conventions and best practices documentation for all database developers.

• Designed, implemented, and optimized SQL Server relational databases for use with proprietary applications. Tasks included normalization, constraints, index architecture, procedural logic, security, and performance tuning.• Served as lead technical trainer of various on-site certification programs. Topics ranged from Microsoft Windows network administration to SQL Server implementation and design. Clients included Kent State University, Penn State University, and Malone College.• Supervised classroom/lab setup for certification and other technical courses. Leveraged multicast image deployment and scripted installations to facilitate a very streamlined process.

As a member of both the development and engineering teams, we implemented custom data-driven web-based document management solutions for clients both domestic and abroad.