Dale Withroder Email & Phone Number

Olsburg, Ks, Us

Manhattan, Kansas

• Administer 7 instances of SQL Server (currently 2014/2016/2017). Installation, access control, security audits, replication, backup/recovery, maintenance, data classification, tuning, migration, upgrades.• Consolidate and migrate environment of 2 IBM DB2 servers and 12 SQL Servers (2008) to all SQL 2014 (now SQL 2017, looking forward to SQL 2019) by migrating to new VMs.• Consolidate environment of WebFocus, Automate, and SSIS to all SSIS.• Create/maintain 50+ ETL projects yearly to co-ordinate 20+ vendor applications/KSUF business processes with a running monthly 99.9% SQL agent job success rate.• Manage SSRS and Power BI to support BI team (1000+ reports and subscriptions) and create reports as needed.• Manage CRM applications to support applications team, with emphasis on problem solving/upgrading.• Mentor IT staff and power users on all things database, to include ETL, Power BI, Kimball style warehouse, and analytics.• Install and maintain 3rd party tools from Redgate, SentryOne (formerly Pragmatic Works), and SolarWinds.• Monitor SQL Server using Redgate SQL Monitor, SolarWinds DPA, and other custom solutions.• Investigate and resolve any problems that come up in SQL Server.• Work with contractors to investigate and resolve problems that come up in CRM and other applications.• Conduct monthly meeting with CRM stakeholders to discuss data and application issues and tackle problems.• Empower end users by granting higher (but appropriate) access in both the database and application layer, combined with one-on-one training.• Provide fast top-tier customer service to a staff of 130 for all database and CRM issues, closing 50 tickets per month. Document tickets fully with systematic instructions for issue resolution.• Work closely with network engineers to solve server-side problems and address needs like certs, new VM builds, firewall, VPN, etc.

• Administered 35+ instances of SQL Server (2005, 2008r2, and 2012). Access control, deployments to staging/production environments, replication, backup and recovery, maintenance, tuning, new installations, migrations.• Worked closely with project managers to keep all projects on time.• Created federal reports for US Department of Education (EDEN, CSPR, CDRC), teaming with data stewards and research staff.• Logical and physical architectural design of data warehouse (Inmon style).• Created/maintained data marts for federal reporting, KSDE research and evaluation, and KSDE data science initiatives.• Created/maintained 100+ SSIS ETLs yearly to support data warehouse, data marts, and federal reporting. Worked intensely with quality assurance staff to validate data loads.• Reviewed/approved all database designs/updates by development staff (14 developers, 80+ applications, and 200+ databases in production) to ensure master data management and data quality. Helped developers promote projects to QA and production environments.• Supported SSRS, SSAS, Sharepoint farm, and Team Foundation Server as needed.• Monitored SQL Server using Redgate SQL Monitor.• Provided fast top-tier customer service to a staff of 300+ and all Kansas school districts for all database related issues.• Work closely with network engineers to solve server-side problems.

• Developed/maintained websites using ColdFusion and .NET, to include ecommerce website with $1,000,000 revenue stream.• Worked closely with art staff to develop CD-ROMs for Mac/Windows platforms, for both catalog sales and outside clients.• Administered 2 instances of SQL Server (2000) and 1 instance of mySQL.• Created a basic data warehouse from SQL Server, iSeries, and mySQL database sources to support sales team.• Designed interactive web-based reporting tools to automate time-consuming excel spreadsheets for management team.• Mentored other programmers to solve problems with their applications.• Maintained Windows network with 6 servers in-house and remote servers with AT&T and MCI.• Managed data entry staff for projects as needed.• Wrote business cases to enhance IT decision making as needed.• Created Scope, Functional Requirements, and Detailed Designed Documents for projects as required.