We provide IT Staff Augmentation Services!

Principal Consultant Resume

Grantsville, UT

SUMMARY

  • Senior Database Professional with over 17 years’ experience in a variety of challenging environments
  • Expert in Database Performance Tuning, Data Modeling and SQL Development
  • Significant Experience on the Microsoft Business Intelligence Platform, including SSIS, SSRS, and SSAS.
  • Multiple projects setting up highly available systems utilizing Windows Clustering, Database Mirroring, Availability Groups and Log Shipping.
  • Developed and supported VLDB databases (4TB+) as well as supporting thousands of concurrent users
  • Led and mentored database teams on multiple projects
  • Frequent presenter at SQL Server events worldwide including SQL Saturday and User Groups.

TECHNICAL SKILLS

  • T - SQL
  • Visual Basic/VBScript
  • C#
  • VB.NET
  • HTML/ASP/JavaScript/CSS
  • Microsoft Windows (all versions)
  • Windows clustering
  • SAN Storage
  • Network Infrastructure
  • Windows PowerShell

PROFESSIONAL EXPERIENCE

Confidential - Grantsville, UT

Principal Consultant

Responsibilities:

  • Manage and support client database environments ranging in size from hundreds of servers to a handful as well as small databases to multi-TB databases (VLDB).
  • Tune and optimize stored procedures and indexes. Analyze the execution plans and tune accordingly (in both virtual and physical database servers).
  • Assist clients with management and tuning of various cloud infrastructures (e.g. Amazon and Azure) as well as migrations to/from cloud environments.
  • Implement Best Practices and stabilize client environments. This includes the implementation of maintenance routines to help maintain the environment.
  • Provide disaster recovery implementation and testing. Help clients define RTO and RPO for their business and data.
  • Implement and support high availability scenarios (clustering, Availability Groups, Mirroring) as well as distributed models (replication, log shipping)
  • Deal with large volumes of data and the need to provide high performing processes for various needs.
  • Train and develop DBA staff for clients.

Confidential - Boston, MA

Principal Consultant

Responsibilities:

  • Manage and support client database environments ranging in size from hundreds of servers to a handful as well as small databases to multi-TB databases (VLDB).
  • Tune and optimize stored procedures and indexes. Analyze the execution plans and tune accordingly (in both virtual and physical database servers).
  • Provide solutions to help improve process and save time for the team, such as building automation scripts to build and deploy SQL Server.
  • Implement Best Practices and stabilize client environments. This includes the implementation of maintenance routines to help maintain the environment.
  • Provide disaster recovery implementation and testing. Help clients define RTO and RPO for their business and data.
  • Implement and support high availability scenarios (clustering, Availability Groups, Mirroring) as well as distributed models (replication, log shipping)
  • Deal with large volumes of data and the need to provide high performing processes for various needs.
  • Completed SQL Server health checks on all database servers and provided clients with recommendations on remediation to bring the environment in line with Best Practices.

Hire Now