Brian Heady Email & Phone Number

- Design and implement ETL solutions for high volume integration projects using Visual Studio, SSIS and T-SQL - Optimize database performance through configuration, file layout, and index tuning - Develop and document enterprise standards for data systems - Instruct others how to use existing and new technology required by projects or standards - Consult with internal and external teams as new systems are planned to ensure compliance with standards - Create prototype and Proof of Concept implementations of data system components - Design, develop and build data related resources (databases, database objects, ETL processes and projects, queries and code) - Design and deploy AlwaysOn and AlwaysOn High Availability replicas and clusters - Monitor SQL Server performance including query performance, response time, disk usage, AlwaysOn transfer rates - Identify, troubleshoot and resolve database system problems including performance tuning and query optimization - Tune SQL Server performance as conditions require - Research production issues to determine root cause and propose solutions - Research, evaluate, and test new features in SQL Server and other technologies as they are released

- Design and develop resources including SSIS ETL projects, SQL databases, data tables, stored procedures, functions, reports, and ad hoc scripts for project requests - Identify, troubleshoot and resolve database problems including performance tuning and query optimization - Optimize T-SQL queries and scripts for performance based on query plan, cost, and index usage - Design and develop reports for projects and system monitoring - Review work of other teams to verify standards compliance - Document work as necessary for use of others - Create solutions based on Remedy system requests

Phoenix, Arizona Area

DAILY ADMINISTRATION• Create SQL and T-SQL Scripts for special applications and DBA functions• Write, debug, test and maintain MS Powershell scripts for database, system upgrade and maintenance tasks• Configure and maintain Fail-Over and Load-Balancing clusters hosting indexing and SSRS appsPROBLEM RESOLUTION• Identify, trouble-shoot and resolve database system problems including tuning and query optimization• Provide level 2 and 3 technical support• Resolve system outage and error conditions in production systems on rotating 24 hr. On-Call schedule DEVELOPMENT AND TESTING• SQL Server 2012 - Replication and HADR (MS Always-On) technology, research, test and compare to 2008• Assist in design, creation, evaluation and maintenance of test platforms for current and future DBMS needs• Work with Architecture and Development teams to optimize db solutions for in-house and 3rd party apps• Participate in data conversion efforts and ETL projects as necessarySYSTEM MONITORING• Build and monitor transactional replication in test and production environments• Monitor and maintain external data indexes (Apache Lucene)• Monitor databases using IDERA SQL Diagnostic Manager

Tucson, Arizona Area

- Lead Analyst at Tucson City Court - Architect of software and hardware systems. - Develop and maintain new VB & C# .NET and older VB6 applications. - Train and mentor other analysts. - Consult with State and other municipal government I.T. professionals. - Worked with Unix/Linux and Windows systems.- Implemented Electronic Citations process and interfaces with Tucson Police Department, and Hyland OnBase EDMS for Tucson City Court.Honored with 2006 Achievement Award from the Arizona Supreme Court for “Providing Access to Swift and Fair Justice” as a result of my contribution to Tucson City Court’s E-Citation Project

Tucson, Arizona Area

*Computer Service Department Manager* role - Designed and implemented entire service department structure and services including remote service delivery which resulted in first-time-ever zero complaints for campus-wide network card installation service - Hired, trained, and managed a team of 13 staff installers / technicians and 2 supervisors - Provided top-level technical support to staff and customers on wide-ranging hardware and software issues*Buyer* role - Served as Interim Computing And Technology Store manager during 6 week recruitment of new manager - Supervised and coordinated team of Ethernet NIC hardware installers - Researched and purchased all PC related computer systems and peripheral hardware for sale to and use by faculty, staff and students in an academic environment

Tucson, Arizona Area

- Coordinated all aspects of operations including; scheduling, ordering, staffing, staff training, evaluation and customer relations issues for the fourth busiest retail location nationally with gross sales over $4 million annually- Managed stock and retail merchandising.

Tucson, Arizona Area

- Hold 2nd degree Black Belt in Okinawan Shorin-Ryu Karate- Assigned and checked work, and evaluated performance for five martial arts instructors- Produced and edited 30 minute promotional video for the Gangbusters program- Instructed karate classes ranging in size from 1-on-1 to 200+ students aged 3 to 71Served as President of Gangbusters, Inc., a non-profit (501c3) organization affiliated with the school, recruited board members

Tucson, Arizona Area

- Managed and co-owned 3200 sq. ft. video rental store- Responsible for hiring, paying, supervising, evaluating, disciplining and firing entire staff of up to 12 employees- Maintained very high employee retention rate

B.S., Business Administration

Systems Engineering, Philosophy