Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Previous Career
Timeline
Generic

KEITH HAYS

Database Architect
Fairview,Tennessee

Summary

Dedicated, seasoned, and dynamic professional decades of technical experience providing an extensive background in designing and implementing overall SQL Server solutions armed with management tools, methodologies, and technologies expertise. Demonstrates expertise in technical design as well as in diagnosing, isolating, and resolving issues pertaining to data and database infrastructure. Possesses proficiency in articulating processes and procedures for instantiating, managing, monitoring, and tuning using analytical skills, tools, and techniques to investigate database issues and draw conclusions.

Overview

24
24
years of professional experience
2
2
years of post-secondary education
5
5
Certifications

Work History

Database Architect

HealthStream
Nashville, TN
12.2014 - Current
    • Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
    • Develops Multiple Solution Alternatives Based Upon Understanding of Key Business And technical Requirements
    • Collaborated with system architects, design analysts and others to understand business and industry requirements.
    • Researches, Stays Current With, And Understands Relevant Business and Technology Trends And applies Them to Current Company Needs
    • Creates, Designs, Integrates and Oversees Implementation of Physical And/or Logical Systems And models
    • Assesses Application, Environment, Network, Or Storage Issues and Makes Recommendations To improve Overall Performance
    • Ensures Systems Quality and Maintenance of Supporting Documentation
    • Advises on Problems and Priorities
    • Conducts Performance, Stress and Volume Testing as Needed to Predict Application Performance
    • Develops and Maintains Relational Data Definitions in Support of Customer Information requirements
    • Participates in Meetings Across Supported Lines of Business
    • Creates New Models And/or Makes Changes to Existing Data Stores
    • Coordinates and Works with Other Technical Staff to Develop Database Architectures, Coding standards, And Quality Assurance Policies and Procedures.
    • Writes and Oversees Database Documentation, Procedures, Definitions and Data Dictionaries
    • Establishes and Utilizes Data Modeling and Database Optimization Tools
    • Plans And Installs Upgrades Of Database Management System Software To Enhance Database Performance
    • Gathers, Defines And Refines Requirements, Leads Project Design And Oversees Implementation
    • Instituted automated deploys of SQL Server databases using DACPAC technology to reduce application deploy times from 9 hours to 15 minutes evangelizing to over 20 Agile development teams who adopted DACPAC technology and design standards associated.

Senior Database Administrator

HealthStream
Nashville, TN
04.2013 - 12.2014
    • Fulfilled all duties of Senior Database Administrator
    • Tested programs and databases to identify issues and make necessary modifications
    • Redesigned entire Enterprise SQL Server infrastructure from SAN Storage up including migration to enterprise class servers running Windows and SQL Server Clustering resulting in increased uptime from 95% to 99.999% annually
    • Set up and controlled user profiles and access levels for each database segment to protect important data
    • Coordinated with project management staff on database development timelines and project scope
    • Created and implemented database designs and data models
    • Wrote and maintained technical and functional specifications to document database intentions and requirements
    • Planned and implemented security measures to safeguard vital business data
    • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers

Solution Architect - SQL Server Technology

Gaylord Entertainment
Nashville, TN
04.2009 - 04.2013
    • Prepared and presented proposals, plans, and communication in partnership with enterprise architects and application teams
    • Performed comprehensive assessment on tools, models, process documentation, and training requirements for project deployment
    • Designed effective IT solutions specifically for top-tier Resort segment hospitality and entertainment organization
    • Supervised deployments and provided troubleshooting and user support.
    • Worked with internal customers to develop integrated solutions and lead detailed architectural dialogues to facilitate delivery of comprehensive solution.
    • Guided and influenced existing system owners on recommended upgrades and enhancements to integrated solutions.
    • Created and implemented innovative business solutions to support corporate objectives.
    • Also fulfilled all duties of Senior Database Administrator
    • Mentored junior Database administrators
    • Redesigned overall architecture to complete successful consolidation of 250 database servers with 1300 databases in 3 years to 24 servers with over 2000 databases without extra cost and loss of performance associated with virtual technologies

Senior Database Administrator

Gaylord Entertainment
Nashville, TN
04.2005 - 04.2009
    • Oversaw progression of upgrades to SQL Server environments as well as configuration of database software, associated database tools, and performance monitoring software
    • Performed all necessary database and infrastructure physical design as well as database upgrades while applying software patches to databases as per application and client requirements
    • Ensured suitable access of clients to their application owners and users
    • Applied best practices in developing, testing, and deploying enterprise disaster recovery plan along with robust database backup and recovery strategies
    • Recommended application level tuning changes for code, queries, and SQL objects, which may not have been performing up to optimum database performance standards
    • Facilitated intensive root cause analysis for database incidents and issues
    • Guaranteed conformity with standard security-related procedures based on established best practices
    • Executed and administered database clustering, failover, and load balance technologies based on SLA and OLA agreements
    • Closely monitored data activities, such as database status, logs, space utilization, extents, checkpoints, locks, and long transactions
    • Conducted extensive examination, pivotal in making effective recommendation for preventive maintenance
    • Utilized expertise in isolating and resolving database related issues through close interface with application vendors and client technical support teams
    • Created, controlled, and upheld SQL server database standards to sustain effectiveness of production, development, test, and staging environment for various groups, such as developer, quality assurance, and data analysis to assure availability of database server in 24/7 environment
    • Coordinated with project management staff on database development timelines and project scope.
    • Tested programs and databases to identify issues and make necessary modifications.
    • Set up and controlled user profiles and access levels for each database segment to protect important data.

Database Administrator & Developer

EFT SOURCE, INC
Nashville, TN
12.1997 - 01.2005
  • Provided keen oversight to database administration activities for Nashville Service Bureau that specializes in services and manufacturing related to payment card Industry.
  • Executed technical proficiency in VB6 and .NET languages as expert level developer.
  • Played lead role in developing custom CRM and Customer Ordering products used in card services area that facilitated card order communication between thousands of banks that use software for ordering their bank cards and PINs.
  • Created and implemented database designs and data models.
  • Managed systems and infrastructures by defining hardware requirements and planning storage capacity.
  • Eliminated downtime by accurately implementing SQL Server Clustering.
  • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers
  • Set up and controlled user profiles and access levels for each database segment to protect important data
  • Tested programs and databases to identify issues and make necessary modifications
  • Created and implemented database designs and data models
  • Wrote and maintained technical and functional specifications to document database intentions and requirements
  • Created scripts and processes for data integration and maintenance

Education

Studied - Psychology

TENNESSEE STATE UNIVERSITY (TSU)
08.1992 - 06.1994

Skills

    Technical Standard Development

undefined

Certification

Microsoft Certified Information Technology Professional (MCITP-Database Administrator) – SQL Server 2008

Accomplishments

  • Designed and instigated enterprise Business Intelligence (BI) at Gaylord, including SharePoint Integrated SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS) over a 2-year period culminating in multiple new permanent teams within the IT Department
  • Functioned as Farm Administrator for SharePoint as well as technical lead for Planview Enterprise PMO system; Numara Trackit Helpdesk System; Newmarket Daylight Sales and Catering – Industry standard; and BlueCube Workforce Management System
  • Took an active role as a voting member of the Architectural Review Board (ARB), which votes on all new systems entering the company for Gaylord Entertainment
  • Instigated the Creation of the System Architecture Collaboration group at HealthStream
  • Redesigned overall production SQL Server System at HealthStream to meet business standards
  • Led efforts in realizing $250K yearly savings in Microsoft support costs by moving all development, testing, and Cold DR systems to Microsoft Developer Network Platforms (MSDN) licensing
  • Boosted uptime on all critical line of business application database servers from 95% to 99.999% annually along with non-critical servers to 99.95% and maintained a maximum of 2ms response time
  • Administered the successful consolidation of 250 database servers with 1300 databases in 3 years to 24 servers with over 2000 databases without the extra cost and loss of performance associated with virtual technologies
  • Established enterprise-wide performance monitoring of SQL Server environments utilizing the Idera SQL Diagnostic Manager system to provide in-depth, real-time and historical performance characteristics as well as alerting and long-term planning ability
  • Adopted innovative ideas in conceptualizing and employing SQL Server Disaster Recovery design with a failover site greater than 850 miles away and with recovery point objective (RPO) and recovery time objective (RTO) constraint of 8 hours each, allowing for cross-subnet disaster recovery without synchronous replication or a stretched virtual local area networks (VLANs)
  • Achieved actual disaster recovery (DR) time in Business Continuity Testing for all enterprise SQL servers, including underlying network and SAN times of four hours and included zero losses of data
  • Planned and initiated SharePoint as an enterprise replacement for all existing Intranet sites at Gaylord
  • Established inclusive security policy for SQL servers to meet the highest level of confidence as well as PCI and SOX audit requirements
  • Received numerous IT “WOW” awards; nominated by colleagues for exceptional performance on a particular project or other endeavor
  • Obtained Gaylord IT Presidential Award; voted by IT directors for exceptional performance

Previous Career

Southdown Corp. § Brentwood, TN

General Manager 1994-1998

§ Managed all aspects of a multimillion-dollar restaurant business including P&L, hiring, training, and quality control for 30 to 45 direct reports including 3 Assistant Managers


Marriot Management group, Healthcare. § Nashville, TN and Lebanon, TN

Executive Chef 1991-1994

§ Managed all aspects of food service in conjunction with Dietitian teams for Humana McFarland Hospital and St. Paul’s Senior Retirement Center with 25 to 30 direct reports including Team leads at McFarland, and 5 to 7 direct reports including a Sous Chef (Assistance Chef) at St. Paul’s.

Timeline

Database Architect

HealthStream
12.2014 - Current

Senior Database Administrator

HealthStream
04.2013 - 12.2014

Solution Architect - SQL Server Technology

Gaylord Entertainment
04.2009 - 04.2013

Senior Database Administrator

Gaylord Entertainment
04.2005 - 04.2009

Database Administrator & Developer

EFT SOURCE, INC
12.1997 - 01.2005

Studied - Psychology

TENNESSEE STATE UNIVERSITY (TSU)
08.1992 - 06.1994
KEITH HAYSDatabase Architect