Randall Haag

Greater Twin Cities, MN, USA 612-***-**** adzwb7@r.postjobfree.com

SQL Server DBA

SQL Server Database administrator with extensive experience in improving database performance, with an eye toward improving the end-user experience. Outstanding career background in security and data protection policymaking and implementation. Primary mentor to offshore DBA team, ensuring they can effectively monitor and address issues during off-hours.

CORE COMPETENCIES

Performance Tuning

Protecting Data Assets

Documenting & Mentoring

Cost Management

Problem Solving

Strategic Planning

Project Management

“Own the Issue”

MS SQL

Powershell

Automation

Azure Virtual Machines

Professional Experience

Accenture MortgageCadenc LLC Minneapolis, MN 2007 to Present

Senior SQL Database Administrator

Oversaw daily operations for over 350 Sql Servers, containing more than 8,000 databases.

Point person on the team for finding and fixing performance issues, including rewriting several queries deemed by developers as “impossible to improve”.

Perform database performance evaluation using Dynamic Management Views, execution plans, Performance Monitor, Query Store, extended events, profiler, and customized alerts.

Establishing database security protocols, using industry standard least privilege practices.

Spearhead proactive performance monitoring protocols, catching issues before they become an issue to the client.

Providing consultation on establishing and testing High Availability and Disaster Recovery configurations.

Ensure company assets are protected through regular testing of backups, performing point-in-time restores

Provide guidance to the team, notifying them of SQL patching issues.

Maintain the script library for the Data Management group, ensuring the team will be able to respond to issues or tasks in a timely, efficient, and consistent manner.

Responsible for documenting to outside auditors our SQL Database processes, ensuring our clients that we are in compliance.

Primary person responsible for replication configuration, maintenance, and troubleshooting

Responsible for upgrades, maintenance, performance tuning and troubleshooting for a key reporting system.

Create, maintain, and modify key client reporting system, using SSIS and change data capture (CDC).

Provided key research and strategy for migrating databases to Azure VM’s.

Effectively communicate procedures to the offshore team. Able to write effective documentation, with clear steps and examples throughout.

Consistently met or exceeded project goals, often with extremely tight timelines.

Point person for implementing, maintaining, and improving performance of the Geek Squad customer service database (Best Buy Co., under Accenture management of BBY’s IT dept).

Education and Credentials

MBA, University of St. Thomas St. Paul, MN

Completed an intense MBA program in accounting, while working full-time.

Bachelor of Journalism, University of Nebraska Lincoln, NE

Completed degree with an emphasis in radio and television broadcasting.

Contact this candidate