Principal Consultant Resume
3.00/5 (Submit Your Rating)
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.
