Wade Ungaro Email & Phone Number

Scottsdale, Az

• Completed in place and side-by-side upgrades on 75+ SQL servers (including Reporting Services, AnalysisServices and Integration Services) from SQL 2000, SQL 2008, SQL 2008 R2 and SQL 2012 up to SQL2014 and SQL 2016 for Developer, Standard and Enterprise Editions• Created Powershell script to script out all database objects and save them to Team Foundation Server which eliminated the need for backups of thousands of Dev\Test databases• Wrote reports for analyzing SQL jobs, disk space, performance and object details using SQL ServerReporting Services and Visual Studio• Added indexes to poor performing tables reducing I/O operations and latency• Worked to standardize all servers to use similar server settings and processes to make troubleshooting and administration easier in the future• Duties include all those listed for the SQL Database Administrator role as well

Scottsdale, Az

• Administer 120+ SQL servers with over 1500 production databases each holding data for CRM, Dynamics AX and many other home-grown applications• Process restores for production data using Native SQL backup and Commvault• Setup regular refreshes of data from production into test environments• Completed numerous upgrades of SQL versions from SQL 2000 up to SQL 2016• Worked with setting up SCOM and WhatsUp to alert for server up\down and performance issues• Created stored procedures for DBA related monitoring of our environments• Responsible for weekly deployments to Production from Dev\Test• Created documentation for many of our DBA related processes as well as tools we use for administration• Setup SQL Sentry monitoring for our most critical servers and use it on a daily basis to troubleshoot issues• Administer security within our SQL environments and ensure they are set to our standards• Monitor disk space, memory and CPU on all servers to allow room for growth and eliminate anyperformance issues• Tune queries to help speed up reporting and application processes• Continual updates of SQL Service Packs and Cumulative Updates as needed• Created standards for security setup, job descriptions and object creation• Setup and administered multiple Azure servers and Azure PaaS databases

Mesa, Az

Owned and managed an online children's boutique clothing store with my wife.

• Administered 30 SQL servers with an average of 10 production databases each holding data for JDEdwards, Axapta, Baan and other• Managed storage and performance statistics and audited security for each server• Created DTS packages to monitor backups of databases (~2 terabytes)• Processed restores for production data using SQL Enterprise Manager, Query Analyzer and through Veritas NetBackup SQL Agents• Performed weekly refreshes of data from production into test environments• Developed SQL processes and updated policies to ensure HP Openview monitoring tool was being utilized• Wrote and refined T-SQL code for changes to data• Responsible for Technical Lead duties: Change Management notifications, providing direction for documentation creation and organization, evaluated skill levels, ensured existing technical standards and processes were practiced, facilitated cross training and assisted others in troubleshooting• Created new monthly Quality of Service reports

• Responsible for allocating resources for customer specific duties• Maintained master schedule of team resources using Microsoft Project Server that showed resource availability for customer related activities• Responsible for the day to day delivery of service and maintenance of customer environments• Identified potential conflicts in the delivery of projects as well as facilitated the rescheduling of deliverables based on customer need and resource availability• Created and maintained numerous monthly metric reports for upper management that detailed work loads, trouble ticket assignments, and Change Management processes• Performed HR administration activities associated with the hiring and firing of direct reports• Participated in salary planning and compensation negotiations

• Conducted 3rd Level phone and email support for 20 customers• Successfully supported customer applications: JDEdwards, Baan, Citrix, Microsoft Office and others• Monitored networks, servers and application batch jobs for each customer• Effectively created, managed and assured accuracy of monthly Support Center reports for upper management and individual reports for other Support Center Representative

• Handled diagnostic support for five Midwest region office’s employees• Maintained LAN and WAN connections for each office• Responsible for all changes and updates on phone systems

• Provided second level phone support for 2000 + employees• Helped complete MS Mail to MS Exchange migration• IT Trainer for new employees on company IT policies, Intranet, email and any specific applications for the employee

• Provide direct phone support with customers for credit reporting software issues• Set up and maintained PCs and phone systems for new employees• Played major role in setting up new data center including racking, wiring and installations• Installed proprietary software for banks and mortgage companies to access credit reports

Cis, Computer Information Systems

General, General

Activities and Societies: Baseball Football Cross Country Soccer