SUMMARY:

My career has primarily been centered around data: developing and administering databases, architecting corporate data/storage pipelines, Installing Flash and Object Storage Arrays, Sales Engineering of Flash Storage devices and arrays, and managing Fiber Connected Storage Area Networks.

TECHNICAL BACKGROUND:

Software: Confidential & Linux Utilities, Visual Studio, SSDT/SSRS, Power BI Desktop, MS Office Suite

Server OS: Windows Server 2016/2014/2012/2008/2003/2000 , ESXi 5.0 - 6.5, CentOS 5.6 - 7.2, SLES 11, Ubuntu 14.04/16.04

Hardware: Intel Based PC's and Servers (x86/x64), IBM & Hitachi Mainframes

SAN: EMC CX3 Series, HP EVA Series, Confidential ION, Confidential PCIe Flash

Databases: SQL Server 6.5 - 2016, MongoDB 3.6/4.0

Public Clouds: Confidential Azure, AWS EC2

Languages: C#, TSQL, PowerShell, ASP.NET, BAL

EXPERIENCE:

Confidential

Principal Database Consultant

Responsibilities:

• Installing, configuring, and patching Confidential SQL Server 2014 and 2016
• Upgrading Database Software from SQL 2012 R2 to SQL 2014 and SQL 2014 to SQL 2016
• Researching and resolving complex deadlocking issues through the use of SQL trace flags, logged output, and SQL profiler output
• Developing datacenter migration plans to move to new co-location facility while achieving zero down time
• Analyzing query plans to optimize long running queries and remove performance bottlenecks primarily by using actual execution plan output
• Refactoring Database File/Filegroup layout to adhere to best practices and distribute IO across multiple files
• Designing, documenting and implementing remote synchronization procedures through AlwaysOn or Log Shipping as appropriate for the business requirements
• Troubleshooting DBMS errors and opening support cases as required
• Developing, documenting, and testing a Disaster Recovery plan that enabled a client to use Azure SQL instances to achieve a quick and low-cost RTO with no data loss
• Building an Azure virtual infrastructure to support DR requirements
• Establishing regular database maintenance including both CheckDB and index rebuilds to ensure integrity and optimum performance
• Analyzing and modifying SSIS Packages to both improve performance and standardize logging
• Building Power BI Dashboards that reported from on prem, Azure and AWS cloud data sources

Confidential

Sales Solution Architect / Professional Services Engineer

Responsibilities:

• Serving as Trusted Technical Advisor to both my Account Executives and Customers
• Specializing in identifying and engaging customers with database performance issues
• Speaking at SQL Server events as one of the primary SE/SQL Server resources
• Providing extensive Pre-Sales and POC support through product demonstrations, customer meetings, trade shows, and technology seminars
• Delivering sales results of 148% of hardware and 251% of software quotas in FY13
• Designing and implementing solutions that leveraged our products to solve customer IO latency or throughput problems
• Delivering database performance analysis utilizing custom scripts and ad-hoc analysis of both the database and server
• Providing Server IO Performance Analysis on Linux, Windows, and ESXi based servers
• Serving as Subject Matter Expert (SME) for our ION Accelerator Flash Array in the Western US
• Scripting using Bash and PowerShell to assist customer POC’s and for ad-hoc work as needed
• Developing a web-based POC Tracking System used by all Sales Engineers Worldwide to record POC details and activity. The system provided our Sales Operations and Executive Management visibility into the POC pipeline, including deal size, status, partner, competition, and other pertinent information. The POC Tracking System utilized C# for the code-behind, the .Net framework for web services, and MS SQL Server 2012 as the DBMS

Confidential

Senior Solution Engineer

Responsibilities:

• Analyzing performance characteristics of our SQL clusters and SAN, presenting performance and capacity analysis and recommendations to Executive Management on server and SAN purchases to support growth
• Analyzing and correcting SQL performance issues including max threads conditions, excessive blocking, transaction deadlocks, memory starvation, cluster failures, misconfigured indexes, etc.
• Reconfiguring our EMC SAN to distribute high IOPS workloads across faster tier storage
• Writing PowerShell scripts to automate SQL Server processes
• Developing a BI solution to deliver metrics on processing throughput, storage consumption, and core utilization to determine our COGS, task efficiency, storage depletion rates, and other pertinent KPIs
• Developing a click stream BI pipeline to pull and transform data from IIS logs, load a Data Mart, and provide metrics on image utilization and trending by Bing Maps’ web front end
• Writing SSRS Reports to provide management with utilization metrics
• Training Developers on T-SQL coding best practices and helping re-write resource intensive T-SQL
• Virtualizing SQL Server, Analysis Services, and Reporting Services on Hyper-V for selected workloads
• Planning and migrating database and SAN racks to new data center location
• Analyzing SQL IO workloads in all MSN data centers to make HA architecture recommendations
• Scripting and implementing MSN’s global SQL Server farm upgrade from SQL 2005 to 2008
• Developing a series of tools and interfaces using C#, PowerShell, and ASP.NET to support site operations
• Implementing soft NUMA and TCP port mapping to segregate batch and OLTP workloads
• Designing and building a series of staging databases, Data Marts, ETL processes and SSRS Reports to deliver metrics on site utilization, hardware performance, and configuration data drawn from IIS logs, SCOM data feeds and load balancer statistics to help Management monitor activity and plan for growth
• Troubleshooting performance problems including mirroring latency, query and IO performance, high CPU, etc.

Confidential

Senior Database Administrator

Responsibilities:

• Designing physical DB architecture to support integrating existing systems with new business processes
• Designing and building a virtual SQL DevOps build pipeline to support automated build & testing
• Architecting and building two active/passive clusters to improve availability for our primary SQL Servers
• Implementing transactional replication across non-trusted domains
• Developing SSRS Reports to provide management with database performance trending information
• Automating DB maintenance and backup processes, analyzing and correcting performance problems
• Coding and optimizing stored procedures
• Building automation to move data from both internal systems and external feeds to support our OLTP systems, Confidential Dynamics, and other back-office systems

Confidential

Senior Database Administrator/SAN Engineer

Responsibilities:

• Defining and tuning disk groups to support high speed image I/O, SQL I/O, and near line image archives
• Designing a new storage architecture to support 4x site traffic without corresponding SAN cost growth
• Upgrading SAN Storage Processor, switch, and host HBA firmware
• Implementing both controller-based replication and host-based replication as required
• Developing an on-going SAN & SQL performance metric collection process to analyze for capacity planning
• Writing and tuning stored procedures for both new development and existing system maintenance
• Implementing SQL 2005 SP2 and migrating selected systems from SQL 2000 to 2005
• Setting-up transactional replication to synchronize legacy systems
• Supporting Data Warehouse refactoring for changing LOB activities
• Installing and patching SQL Servers and the OS with security updates and service packs