Bennett Scharf
Sr Sql Database Administrator @City and County of Denver
Signup · Get unlimited contacts
WORK HISTORY
Sr Sql Database Administrator @City and County of Denver
Denver, CO, US
A combination of production, development, and project DBA duties in a large, highly-available, virtualized environment. Many of our mission-critical workloads include systems for public safety and first responders. There are approximately 125 SQL Server instances, with databases ranging as large as 3TB. • Built multiple 2016, 2017, and 2019 AlwaysOn availability groups to support the organization\'s most critical authentication, infrastructure, and security applications. Once built and tested, I worked closely with the application administrators to install, test, and troubleshoot the applications prior to go-live.• Participated in project meetings and ensured that the server builds met the project\'s recovery time and recovery point objectives.• Developed PowerShell and SQL Scripts to gather performance and configuration baselines and deploy configuration uniform changes across all SQL Server instances.• Diagnosed and fixed performance problems. Realized impressive performance gains, sometimes reducing runtimes from hours to minutes or from minutes to seconds. Identified and fixed issues such as out-of-date statistics missing indexes, parameter sensitivity (aka parameter sniffing) in code, and non-sargable predicates. Recommended code changes to developers. • Developed, maintained and fixed a wide variety of stored procedures, views, PowerShell scripts, and SSIS packages to solve a variety of business needs. Some of the more interesting systems and projects included Campaign Finance, Fiscal Transparency, video surveillance systems, a Traffic Cams.• Assisted teams with software rollouts, updates, and migrations.• Troubleshot a wide variety of production problems and participated on an on-call rotation.• Performed routine DBA tasks such as documentation, permission grants, restores, and refreshing lower-level environments.
EDUCATION
Metropolitan State University of Denver
Computer Science
Mohegan Community College
AS, General Studies
Excelsior University
Bachelor of Science, Computer Information Systems
SKILLS
ABOUT BENNETT SCHARF
SQL Server DBA with over 14 years of experience supporting production and development environments, software development teams, and software development projects of varying sizes. Excellent troubleshooting skills with fast, accurate diagnosis and resolution of issues. A team player known for a strong work ethic and the ability to communicate with both technical and business colleagues. Competencies include:• MS SQL Server Database administration, versions – 2022• Administration of the Microsoft BI Stack• Query tuning, index tuning and overall performance tuning• Troubleshooting, tuning, and support of Data Warehouses and large analytic databases• PowerShell Scripting and automation• Migrations, including version upgrades, hardware upgrades, and data center moves• Storage management and capacity planning• Performance monitoring, trending and reporting• Advanced troubleshooting including root cause analysis• High availability, disaster recovery and business continuity• T-SQL development• Robust, dedicated remote office facilities, including gigabit fiber and backup power.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.