Last updated: 12/15/2015
Word Document Download: Click here

Professional Experience:

  • 2015-Present Ascension Information Services | Senior Database Administrator
  • 2014-2015 Liberty Tax Service | Data Architect / T-SQL & .NET Developer
  • 2012-2014 Liberty Tax Service | Technical Lead – Database Operations
  • 2011-2012 Liberty Tax Service | Database Administrator
  • 2010-2011 United States Navy | Retail Ordnance Logistics Management System Oracle DBA
  • 2005-2011 United States Navy | Fire-Control Technician Surface Warfare | Highest Rank: E-6

Community Involvement:

Education & Training:

  • Querying Microsoft SQL Server 2012 Databases – Exam 70-461 (2015)
  • Administering Microsoft SQL Server 2012 Databases – Exam 70-462 (2014)
  • Bachelor of Science in Computer Information Systems with a focus in Database Management – Summa cum laude with a 3.97 GPA (2014)
  • CompTIA Security+ Certification (2011)

As Microsoft SQL Server Production DBA:

  • Software / Configuration
    • Performed SQL Server in-place and side-by-side upgrades on all versions from 2005 – 2014.
    • Tested new SQL Server patches and updates while moving them up through multiple non-production and production environments.
    • Installed and configured SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Database Engine, and SQL Server Data Tools.
    • Standardized SQL Server Integration Services deployment, management, and processing with a central dedicated package store and assigned processing servers.
    • Administered SQL Server with locally attached and shared storage configurations.
    • Maintained database servers in multiple domains with a variety of one-way and two-way trusts.
    • Configured and administered SQL Server instances in both Microsoft’s Azure and Amazon Web Services.
  • High-Availability
    • Implemented and maintained multi-node Windows Server Fail-over Clusters on Windows Server 2008 R2, 2012, and 2012 R2.
    • Implemented and maintained SQL Server Fail-over Cluster Instances in active-active and active-passive configurations.
    • Implemented and maintained Always-On Availability Groups to include stand-alone SQL Server instance configurations and hybrid configurations incorporating SQL Server Fail-over Cluster Instances.
    • For standard edition SQL Server instances, implemented and maintained database mirroring.
    • Architected cross-subnet Windows Server Clusters for fail-over to remote data centers.
  • Disaster Recovery
    • Designed and implemented an automated database backup solution, with a tiered priority structure, for production databases ranging from very small to a sharded system of databases exceeding 2 TBs per shard.
    • Implemented and maintained log shipping for warm sight, tier 2, databases.
    • Automated database backup file testing on secondary servers by retrieving a random sampling of backup files each day via Central Management Server and log restore tests.
    • Coordinated enterprise wide backups with Symantec Netbackup.
    • Utilizing both DBCC repair and page level restore methods, recovered from 10+ database corruption incidents to include corruption to mission critical systems such as Team Foundation Server (TFS) source control.
  • Data Distribution / Migration
    • Maintained a complicated replication architecture utilizing transactional, merge, and snapshot replication.
    • Performed 200+ database migrations while performing side-by-side upgrades, archiving, and resource management / consolidation.
  • Capacity Management
    • Coordinated space allocations and data migrations in an infrastructure with multi-tiered storage configurations.
    • Monitored and responded to disk growth and capacity including projecting future capacity requirements.
  • Data Integrity / Security
    • Secured and managed the use of linked servers.
    • Acted as approving authority of security requests for all database servers and defined role permissions.
    • Implemented Transparent Data Encryption (TDE) on high-valued, enterprise edition, servers and maintained encryption key backups.
  • Monitoring / Performance
    • Monitored 140+ non-production and 60+ production database servers with a combination of Solarwinds, Red-Gate’s SQL Monitor, and Idera’s Diagnostic Monitor software.
    • Utilized built-in dynamic management objects (DMF/DMV), SQL Trace, and Extended Events for custom performance and event monitoring.
    • Established an enterprise wide method of auditing Data Definition Language changes to database schemas and ETL’ed the data to a central auditing server to be viewed via SSRS reports.
  • Development
    • Designed database solution for automated backups, index / statistics maintenance, DDL auditing, file retention and server side tracing.
    • Designed and developed PowerShell script for disaster recovery (fail-over), maintenance, and daily task automation.

As Data Architect / T-SQL & .NET Developer

  • Business Intelligence
    • Designed and developed a financial data warehouse for a large heathcare organization.
    • Principal report writer using SQL Server Reporting Services for Population Health and Meaningful Use metrics (healthcare, external data submissions).
  • Data
    • Architected mission critical data tier utilizing Always-On Availability Groups and cross sub-net clusters.
    • Performed code reviews and performance tuning / analysis of 8 database projects with over 2,000 user objects.
    • Performed data analysis and data modeling for major schema refactors.
    • Developed Extraction, Transformation, and Loading (ETL) SSIS processes in Business Intelligence Studio (2008) and SQL Server Data Tools for Business Intelligence (Visual Studio 2012 and 2013).
    • Developed PowerShell driven processes for automating SSDT database project deployments and custom pre/post deployment tasks.
    • Integrated with Microsoft Release Manager for release template deployments and multi-environment coordination.
    • Worked in an Agile environment utilizing Team Foundation Server (TFS) for source control and work item management.
  • .NET
    • Developed WCF services acting as the business layer beneath the presentation and application layers. Also, developed within a centralized data access layer where I contributed to development standards for efficient access of the databases.
    • Developed with C# (.NET 4.0, 4.5, 4.5.1) in Visual Studio 2012 and 2013.