COMPETENCIES INCLUDE: Business Relations: Vendor Management, Technical Interface for Clients, PCI/SAS70/SOX, Regulatory Compliance Management Technology: Microsoft SQL Server, Clustering, MySQL, MongoDB, Data Warehousing, ETL, SANs (EqualLogic, NetApp), VMWare, Hyper-V, SSRS/ SSIS/DTS, Powershell, Ruby, Clones, Windows OS, Linux (RedHat, Ubuntu) Analysis Services, Active Directory, Nagios, Orion, SCOM, Confluence, SharePoint, Desired State Configuration

Senior Manager, IT Production Services, Database and Infrastructure @ Database and Infrastructure responsibility for a 24x7 IT production environment supporting real-time payment processing systems. Environment spans 5 datacenters, over multiple geographical locations. Included is management and oversight of all IT Infrastructure, Database Operations, Data Layer Architecture and Data Delivery. Note: All duties from previous role as DBA Manager continued in this role. • Management and oversight of all datacenter infrastructure server and SAN systems. Includes:  -Multiple VMWare farms for production and back-office systems  -All SAN and NAS storage, enterprise-wide  -All physical machines, including HA database clusters  -Datacenter build-out and management • Ensured customer SLA and up-time requirements were met • Introduced and hosted the daily company-wide Standup—an operations-focused open meeting concentrated on solving current issues, operational challenges, current IT projects, and upcoming code deployments. Typical attendance ranged from 30 to 40 participants, with all groups represented--from developers to business owners. • Merged and integrated storage and DBA teams to improve transactional performance through coordinated vertical tuning and monitoring. Increased efficiency of snapclones by creating collaborative engagement between SAN engineers and DBAs • Implemented IT workflow tool (Trello) for planning, tracking, and visibility of Infrastructure and DBA projects • Daily management of two separate teams, with two technical leads (including staff in Atlanta, GA and Dundalk, Ireland) From August 2012 to May 2013 (10 months) Manager, IT Production Services, Database Team @ Responsible for the overall management, security, robustness, stability and policies governing the global 24/7 production database services. Manage team in addition to serving as an individual contributor. No external or internal SLA infractions in 3 ½ years. • Ownership of all data servers in Production, UAT, QA and Development environments, in one local and three remote datacenters. Included HA clusters, standalones, virtual and physical • Provided services and SLAs to internal business owners. Includes: Finance, Marketing, Engineering, DevOps, Risk Management, Security and QA • Designed and built-out HA data layer in three separate remote production sites • Designed and implemented data layer for enterprise-wide Disaster Recovery solution between remote production sites • Successfully migrated all production databases from standalones to clusters over a period of eight months • Implemented virtual SQL Servers for back office support databases • Significantly reduced resource consumption on production data servers through methodical and routine performance tuning of database code; designed and built-out production performance testing lab; worked closely with Engineering and QA to implement enhanced database code • Conducted code reviews and onsite SQL training for developers. Established official SQL Coding Guidelines and Best Practices documents for SSIS development • Extensive implementation of EqualLogic and NetApp snapclone technology for data delivery to business groups within the corporation. • Designed, developed, and deployed a data warehouse to support marketing efforts From September 2009 to August 2012 (3 years) Senior DBA @ • Performed functional and performance testing for production database code drops; responsible for testing of all fraud detection code • Participated in monthly production maintenances and after-hours code deployments; worked closely with production DBAs to verify functionality and performance of post-deployment code • Reduced total testing time for code drops by introducing database snapshots as an integrated part of QA testing. • Researched, tested and oversaw production data server upgrades and database migration from SQL Server 2000-2005. • Designed and executed test plans against three separate storage vendors using SQLIO and Iometer; built database to capture, aggregate and analyze test data; presented test results to management to guide purchase decisions. • Regular collaboration with remote development and QA teams • Conducted root cause analysis for production database incidents and problems. • Synched company databases across Development, Integration, and QA environments • Provided performance tuning feedback to developers. Extensive use of JMeter, Fitnesse, SQLQueryStress and custom load-testing scripts • Installed first cluster in QA environment; assisted with installation of first production cluster; wrote documents on Windows and SQL Clustering still in use in production From February 2008 to September 2009 (1 year 8 months) DBA/Developer @ • Responsible for daily, weekly and monthly maintenance cycles on 8 database servers, 50+ databases. Includes off-site backups, transactional backups, replication, log file maintenance, and index maintenance. • Designed and developed a publish-on-demand import system utilizing File Transport Protocol, SQL Server DTS and integration with Google Maps API. Application allowed graphical representation of client retail outlets based on address/zip lookup. • Optimized clients’ databases through SQL query optimization, normalizing data structures, indexing, and routine profiling • Created import ETL processes that import, process and distribute client records in a timely, accurate and secure manner. Export ETL processes created for client sales affiliates, distribution centers, offline database reporting and other ERP systems. • Gathered business requirement reports and use cases for physical/logical data modeling. Designed and developed OLTP databases for online e-commerce clients. • Designed and developed data structures for CRM, invoicing, and data warehousing modules. • Integrated online merchant payment services (Cybercash, Verified by Visa) with web application and databases. From November 1999 to January 2008 (8 years 3 months)

Master of Arts (MA) @ Oregon State University Tom Chisholm is skilled in: RHEL7, Ubuntu, Puppet Enterprise, Microsoft SQL Server, Databases, CentOS, Data Warehousing, ETL, SSIS, Enterprise Software, Performance Tuning, SSRS, Database Design, Data Modeling, High Availability