Experience

Solvaria

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Principal Consultant

  • Jun 2018 - Present

  Microsoft SQL Server, SQL, and ETL development/support for a wide variety of applications and customers. Microsoft SQL Server, SQL, and ETL development/support for a wide variety of applications and customers.



Experis

• United States
• Staffing and Recruiting
• 700 & Above Employee

• Senior DBA

  • Jan 2017 - Jun 2018

  Consultant providing Microsoft SQL Server development and support at a major insurance company. Consultant providing Microsoft SQL Server development and support at a major insurance company.



Enterprise DBA&SQL Consulting, LLC

• Richmond, Virginia Area

• Owner Consulting Company

  • 2015 - 2016

  Contracted by a major insurance company to upgrade their prescription medicine management system to SAP Sybase ASE 15.7. This highly available terabyte-level call center system has thousands of users using dot-Net, Java, and "C" based DB-Lib applications. Tested, improved, and tuned several hundred SQL Stored Procedures in the application prior to the upgrade. Found and fixed a large number of database corruptions. Developed new flexible maintenance scripts for database consistency checks (checkstorage), update statistics, and defragmentation (reorg) that can run online during production operations. After the upgrade, my contract was extended to provide general database administration and application developer support for Microsoft SQL Server Reporting Services and Sybase. I was the only contractor extended from the original team.



CarMax

• United States
• Retail
• 700 & Above Employee

• IT Principal DBA Analyst

  • 2009 - 2014

  Project Leader on CIO-sponsored enterprise database architecture redesign. Developed RFP for major RDBMS providers (Oracle, MySQL, Microsoft, IBM, Sybase). Evaluated cloud-based, distributed, and centralized architectures. Tested leading vendor, Microsoft, in proof-of-concept in a distributed architecture. Tested encryption and compression. Led negotiations with vendor and subcontractor to convert enterprise. Project Leader on new enterprise database architecture based on centralizing data using Microsoft SQL Server AlwaysOn technology. Led team in proposal and presentation IT Managing Board. Led project through CIO approval, funding, and procurement.Project Manager and Technical Leader in enterprise SAP Sybase 15.03 upgrade on 140 Linux servers. Developed concise and repeatable process for team to perform upgrades.Subject Matter Expert on enterprise Sybase 15.7 upgrade. Analyzed benefits of server and client upgrades. Proposed plan for budgeting. Performed 15.7 upgrades in test. Tested encryption and compression. Performed DBA training.Made business case to CIO and IT Managing Board to change the database enterprise architecture from HP-UX to x86/Linux (Red Hat)Project Leader on IT-wide crisis team to address application stability and performance that was significantly impacting company financial performance and customer satisfaction. Briefed CIO and Managing Board daily until problems were resolved. Developed new methods and acquired new tools for measuring performance and resource utilization. Identified database, application, system, and hardware changes. Trained team in tuning skills. Estimated $1M+ annual productivity savings. Developed ongoing and proactive practices to prevent future occurrence.

• IT Director

  • 2004 - 2009

  Managed Database Administration, Enterprise Data Warehouse, and Security Implementation teams composed of 20 associates and 1-5 contractors. Reported to the CIO.Managed the maturation of Data Warehouse through four generations of improvement. The latest generation, based on Teradata, is critical to virtually every business area in the enterprise and was able to support data growth greater than 50% per year. The Data Warehouse saves tens of millions of dollars annually in new and improved business processes and is key to CarMax's competitive advantage.Defined, built, and managed multi-terabyte Corporate Repository Operational Datastore that required major modifications to all CarMax systems. Added near-real-time data feeds which are critical to driving the business by providing more up-to-date information such as CarMax.com.Implemented Microsoft Reporting Services as the company standard reporting tool for tactical and strategic decision-making. System generates 500K+ reports/month. Prototyped Analysis Services. Managed SAS, Oracle, and other analytical and reporting tools. Led the identification and resolution of a major Sarbanes-Oxley and security deficiency that was tracked by the Board of Directors as one its top two IT priorities.



CarMax

• United States
• Retail
• 700 & Above Employee

• IT Database Manager

  • 1996 - 2003

  Founded CarMax’s Database group in company's startup phase. Implemented and managed database best practices that supported growth from a single store to 100 stores. Led team of 12 associates in Sybase, SQL Server, and Teradata technologies. During the company's dynamic growth, I reported to VPs from every area of the company and eventually the CIO. Database architect in four generations of IT Architecture improvement over life of company. Key contributor in designing and building all enterprise core foundation systems such as Financials/Peoplesoft, Credit, and CarMax.com. Leader in advancing Microsoft SQL Server and Teradata solutions to supplant Sybase. Principal member of management SWAT team used to resolve major problems. Evaluated, acquired, and managed infrastructure tools, including 24x7x364 proactive monitoring with automated system error correction.



Circuit City

• Technology, Information and Internet
• 700 & Above Employee

• Senior Systems Analyst

  • 1993 - 1995

  Leader in introducing and promoting Relational Database Management Systems and Client-Server architecture into an AS/400-based organization. Reported to IT Vice President and Director. Led development of large Merchandising Data Warehouse system that was key in the company's last 15 years. Principal DBA in development of Home Security, HVAC, AnswerCity Call Center, Credit Card and Banking Divisions among others. Evaluated architectures for proprietary DVD Divx system. Leader in introducing and promoting Relational Database Management Systems and Client-Server architecture into an AS/400-based organization. Reported to IT Vice President and Director. Led development of large Merchandising Data Warehouse system that was key in the company's last 15 years. Principal DBA in development of Home Security, HVAC, AnswerCity Call Center, Credit Card and Banking Divisions among others. Evaluated architectures for proprietary DVD Divx system.