Experience

TrueCommerce

• United States
• Information Technology & Services
• 300 - 400 Employee

• SQL Jedi

  • Jun 2017 - Present



Simple SQL Server, LLC

• E-Learning Providers

• Principal Consultant

  • May 2013 - Present

  Founded blog to give back to the SQL Server community I still rely on for skills development Sharpen my skills by learning each portion well enough to explain it in a simple format Create complex queries to return data in the most legible and usable format possible Present at SQL Saturday events, using my strengths to help train others Founded blog to give back to the SQL Server community I still rely on for skills development Sharpen my skills by learning each portion well enough to explain it in a simple format Create complex queries to return data in the most legible and usable format possible Present at SQL Saturday events, using my strengths to help train others



Plus+ Consulting

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

• Business Intelligence Consultant

  • Aug 2016 - May 2017



Buchanan Ingersoll & Rooney PC

• United States
• Law Practice
• 700 & Above Employee

• Lead DBA

  • Jun 2015 - Aug 2016



Opus - Hiperos Third Party Risk Management

• United States
• Software Development
• 1 - 100 Employee

• Database Administrator

  • Jun 2014 - Apr 2015

  DBA stuff. Lots of tuning, a little of everything else. DBA stuff. Lots of tuning, a little of everything else.



Millennium Pharmacy Systems

• United States
• Hospitals and Health Care
• 1 - 100 Employee

• Database Administrator

  • Sep 2013 - Jun 2014

  Increased Page Life Expectancy at least 100% on every Tier-1 server Decreased overall CPU usage by up-to 50% on every Tier-1 server Modifying indexing for both buffer pool management and query performance Rewriting queries to utilize set-based logic by eliminating scalar functions, subqueries, and more Transformed services from struggling with performance to offering reduction of hardware Assisting with disaster recovery plans using a lower-cost dual data center for near-zero downtime Planning Transparent Data Encryption for enhanced security from physical theft of hardware or backups



EDMC

• United States
• Education Management
• 700 & Above Employee

• Database Administrator

  • Oct 2010 - Sep 2013

  Perform advanced turning across multiple systems of both in-house and vendor databases Improve monitoring including performance, blocking, wait stats, and profiler tracing Resolve deadlocks through altering order of operations, tuning, and reduction of parallelism Reduce preventable pages and outages through trending and root cause analysis Engage Microsoft support for complex or mission critical issues and product bugs Create SSRS reports for change tracking, monitoring double-checking, and cross-team transparency Perform basic DB2 tasks including environment refreshes and communication with external support



RDX

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

• Database Administrator

  • Aug 2009 - Apr 2010

  Remotely administer SQL Server 2000, 2005 and 2008 on Windows 2000, 2003, and 2008 Maintain full, differential and log backups of databases in excess of 1 TB Take part in 24 / 7 / 365 on-call rotation for over 20 clients with 15-minute SLA Develop and deploy database and server monitoring scripts using T-SQL and VBScript Monitor SQL Server and Windows logs to proactively resolve issues Remotely administer SQL Server 2000, 2005 and 2008 on Windows 2000, 2003, and 2008 Maintain full, differential and log backups of databases in excess of 1 TB Take part in 24 / 7 / 365 on-call rotation for over 20 clients with 15-minute SLA Develop and deploy database and server monitoring scripts using T-SQL and VBScript Monitor SQL Server and Windows logs to proactively resolve issues



Elliott-Turbo

• Reports Developer

  • Mar 2009 - Aug 2009

  Converted Oracle Developer reports into Oracle Report Builder Updated Access databases to meet new business requirements Developed new reports using Oracle Report Builder and TOAD Converted Oracle Developer reports into Oracle Report Builder Updated Access databases to meet new business requirements Developed new reports using Oracle Report Builder and TOAD



Case Cutlery

• Programmer Analyst

  • Apr 2008 - Jun 2008

  Created stand-alone and SQL Server backed Microsoft Access databases Transitioned reports from Crystal Reports to SSRS pulling from a data warehouse Debugged SSIS transfer from Oracle ERP transactional system to SQL data warehouse Created stand-alone and SQL Server backed Microsoft Access databases Transitioned reports from Crystal Reports to SSRS pulling from a data warehouse Debugged SSIS transfer from Oracle ERP transactional system to SQL data warehouse



Quality Rolls

• Database and Network Administrator

  • May 2000 - Apr 2008

  Developed databases for all aspects of the business using Microsoft Access and SQL Server Acted as sole full-time IT employee for three locations over two states Administered email systems, including upgrade to Exchange 2007 and SPAM filter implementation Oversaw WAN, VPN, and VoIP implementation based on Cisco routers and T1 connectivity Inbox360 – Computer Programmer – Williamsport, PA – September 2001 – May 2002 Developed stand-alone and SQL Server backed Microsoft Access databases Debugged existing JavaScript and HTML code