Doug Herring Email and Phone Number

• Lead a team of application support specialists who are responsible for the implementation and troubleshooting of all system applications across the company.• Approved payroll and set goals for team members as well as conducted performance reviews. • Reviewed and assisted in the selection of new cost saving and productivity increasing applications across the company.• Project manager on new application builds and designs with various outsourced development teams by implementing milestones, approving sprints, and keeping projects on budget.• Created analytics and reporting using SSRS and Entrinsik Informer systems that were used as controls across various departments and executive projects for the company to save costs while increasing productivity.• Implemented FreshDesk ticketing system to be used to track and audit tickets and built knowledge base for application support, BI reporting, Document creation, and company projects.• Reviewed and assisted outsourced infrastructure team with the implementation and configuration of Azure cloud services, servers, and Microsoft applications. • Implemented QA testing procedures and assisted with QA for new applications and technologies to minimize impact on production systems. • SQL Database administrator for the company that implemented time saving optimizations to queries and automated SQL packages to increase employee productivity along with customer SLA satisfaction.• Collaborated with executive team for decision making and implementation of change controls, system designs, cost savings, and productivity increases for the company.

• Deploy, Configure, and Maintain SQL Server 2008, 2008R2, 2012, 2016, 2017, and 2019 Instances across global organization.• Configure database encryption for protected data with regards to GDPR and best practices. • Configure and utilize SQL Server monitoring/alerting software with experience with Redgate and IDERA monitoring software.• Create automated SQL Server Agent jobs to run regular maintenance schedules and tasks like database statistic updates, data cleanup, database size maintenance, and backup strategies. • Maintain database replication across clusters and instances for reporting purposes.• Configure SQL Server High Availability infrastructure for various 3rd party software technologies.• Work with Dev Team of proprietary software for DDL and DML change requests including schema changes, primary keys, foreign keys, and bulk data updates/imports with emphasis on batching to limit effects on 24 hour production environments.• Consolidate data from multiple databases to a single database for cost efficiency and resource management.• Performed database upgrades to latest versions of SQL Server.• Performed database migrations to new servers and clusters. • Develop and maintain disaster recovery and backup strategies of large databases. • Help Dev team with Deadlock and blocking troubleshooting/resolution• Help create indexes and provide performance troubleshooting for production databases. • Create stand-alone test environments. • Design and troubleshoot SQL Server Reporting Services (SSRS) including migration and reports.• Deploy and Maintain Power BI environment with hooks into on site databases.• Experience in supporting various web application integrations• Manage user security for database connections from users and applications.

• Deploy, Configure, and Maintain SQL Server 2008, 2008R2, 2012, 2016, and 2017 Instances across multiple subnet infrastructure. • Configure and utilize SQL Server monitoring/alerting software mainly using Spotlight.• Database optimization using manual and automated monitoring.• Database migrations between servers and clusters. • Worked with on-premise and cloud server/database solutions.• Design disaster recovery and backup strategies.• Design and deploy change requests that involve DDL and DML transact SQL to update schema and perform bulk data update/inserts.• Configure SQL Server High Availability infrastructure for various software technologies• Worked with business intelligence team to provide access and troubleshooting for large data pulls and setting up reporting databases.• Manage user security for database connections from users and applications. • Learned about SAP database management in a Linux environment.

• Worked on SQL Server database projects that included SQL Server migrations and installs.• Helped troubleshoot SQL Server database performance issues and created optimization strategies. • Troubleshooted and resolved ODBC connection issues from workstations and applications to SQL server databases.• Helped build SQL server test environments with backups and restore operations. • Lead team to properly follow procedures and provide quality service in accordance to ITIL best practices. • Designed processes and documentation for distribution among teams to improve SLAs and performance.• Troubleshoot high priority and/or escalated issues within the business.• ITSM Admin for our Fresh Service ticketing tool and help configure and maintain this tool along with the inventory management system.• Worked with on-premise Exchange and Active Directory as well as Office365 cloud solutions for Exchange and Active Directory.• Developed scripts in PowerShell to simplify and provide streamlined solutions.• Create and deploy images for Desktop and Laptop builds.

• Helped provide direction, growth, and support of a hosted solutions infrastructure for proprietary application software, Microsoft office, and SQL Server databases.• Developed a deep business knowledge and expertise for product improvements and future consulting. • Collaborated with executive team to achieve goals toward customer and internal procedures/processes.• Helped develop new revenue sources for operations department.

• Performed SQL Server database migrations from old environments to new environments for customers who upgraded hardware.• Performed SQL 2008, 2008R2, and 2012 installations.• Performed SQL database upgrades from SQL 2000, 2005, 2008, and 2008R2 to SQL 2008R2 or 2012.• Used T-SQL to troubleshoot data integrity issues and to resolve through update and insert statements.• Lead technical support on critical and advance technical issues for customers.• Primary product SME on new product and first point of contact on issue management• Assisted QA with reviewing multiple in house proprietary product software suites.• Troubleshooting, Documenting, and Resolving new defects and issues for development team using an in-house bug tracking software.• Provided expertise and support to customers to be within industry best practice compliance for data security. • Provided billable revenue with customer consultation and support as well as with handling after hour emergencies.

• Performed installations and troubleshooting of Microsoft SQL server 2005, 2008, and 2012 including SQL Report Server.• Performed server moves of applications/databases, software enterprise upgrades, and after hours support to provide billable revenue for the support department.• Migrated customer databases from customer site to training environment and vice versa for training and implementation departments.• Experienced modifying reports in SSRS for our in-house proprietary software.• Technical Support of software enterprise and applications involving the real estate and title industry.• Maintain quality customer relationships through excellent customer service and by meeting SLA requirements.• Installation and troubleshooting of our Web based products through Microsoft IIS and .NET.• Take escalated/priority 1 calls and provided timely resolutions.• Lead new product testing and support in the support department as well as implementations and training departments.• Help train new support technician hires.

• Break down IT equipment for a company's move.• Set back up IT equipment at new site.• Test IT equipment to make sure everything is operational.• Troubleshoot connection issues at the physical layer such as monitor not displaying, IP phones not connecting, and computers not turning on.• Helped other team members with complications to complete the job.

• Create handcrafted beverages for customers. • Provide highest level of customer satisfaction. • Suggestive selling to raise store profitability.