Chad L. Casutt

***** ****** **. *** • Mansfield, TX 76063 • Phone 801-***-**** • ac0zgf@r.postjobfree.com OBJECTIVE

Full-time opportunity as a Database Administrator

Mission Statement

I am a career minded individual that works for the common good of the organization. I am dedicated to achieving company goals while abiding by its standards. I have a broad knowledge of the IT world from many different industries and I have found that there is always room for improving the process. As an experienced Database administrator, former developer and currently a manager, I strive to improve the environment that I work in, eliminate repeated errors, and bolster moral while doing it. EXPERIENCE

Work Experience

• Administered 500+ SQL Servers worldwide on daily basis

• Manage 100TB + SQL Server/Informix/Sybase Data/Oracle

• Developed Stored Procedures, Views, Tables, User Defined Functions, DTS/SSIS Packages

• Developed SQL Server Encryption Certificates and policies

• Manage Aggregates, Volumes, LUNs, Clones, Mirrors, Snapshots, LAN management on NetApp

• Create Reports with various report writers, XML/XSL, SSRS and HTML

• Worked with every version of SQL Server from 4.2 – 2016 Management Experience

• Yearly reviews

• Hiring/dismissal

• Disciplinary

• Enforce Change Control Process

• Uphold company vision while achieving team goals

• Yearly Budget

• Manage teams in Canada, India, and Philippines

Knowledge/ Skills/ Abilities

Operating Systems: Windows-NT/2K/XP/2003/2008/2012 r2; NetApp Data ONTAP Network Services: HTTP, DNS, FTP, DHCP

Networking: TCP/IP, Switches using Cisco

Hardware: IBM, Dell, HP, Compaq

Database Management: Microsoft SQL Server, Oracle, Sybase, Informix Data Management: SNAP Manager SQL, SNAP Exchange, NetBackup, Backup Exec, ArcServe, SQL Lite Data Monitoring: Idera, Solarwinds, Nagios, ApexSQL, Foglight for SQL Storage: NetApp FAS940, EMC Clairion, Direct Attached, FusionIO Programming Languages: Visual Basic, COM, DCOM, ASP, vb-script, Powershell Reporting: Wired for OLAP, Lawson Report Writer, Crystal Reports, Crystal Info for Essbase, SSRS Education and Employment History

Heritage Auctions, Dallas,TX Mar ’17 to May‘17

Database Development and administration. Reviewing and promoting code to production as well as development. Including tables, stored procedures, triggers, views, functions, SSRS Reports, and SSIS Packages. Always-On, VM Ware, Windows Clustering

Technologies Used:

Database: MS SQL Server 2008 R2 - 2016, Oracle 11g,12c Software: Visual Studio, JIRA, Solarwinds, SQLLite, Powershell, vb Script, Nagios Optum – United Health Care, West Valley UT; Database Developer Administrator Contractor, Nov ’16 to Feb ‘17 Database Development for SQL Server/Oracle. Optimize scripts and environment for performance. Tested and pushed for releases. Used: SQL Server 2012, Oracle 11g/12c, Beyond Compare, Toad for Oracle Database Development, Agile SCRUM, Rally Software, Java compiler tools. Optimized VM Ware to use with Database Servers.

Technologies Used:

Database: MS SQL Server 2012, 2014, Oracle 11g,12c Software: Visual Studio, Version Control with Subversion, Beyond Compare, TOAD for Oracle, SQL Plus, Rally ALM for Agile Developers

Teleperformance USA, SLC UT; Database Administrator Manager/SAN Administrator, Jul’06 to Sep’16 I manage a team in the Philippines and in India. The environment consists of Transaction, Reporting, and Data warehouse servers with some databases exceeding 1.6 TB. With multiple clients having different requirements there is a need to adapt to different software and hardware. Daily tasks include SAN administration, Server Clustering, HA availability, Reports, ETL Development, Training, Backups, Restores, Performance tuning, replication, server optimization, installs, database encryption, database mirroring, log shipping, maintaining current Disaster Recovery solutions, creating schedules for team members, reviews, disciplinary actions, Hiring and dismissals. Technologies Used:

• Database: MS SQL Server 7.0, 2000, 2005, 2008, 2008 R2, 2012, 2014,2016 – Oracle 8.0, 9.0 - Informix 11, MySQL 4.0, 5.5 - Cache

• Reporting: SQL Reporting Services using SSRS, SQL Analysis Services using SSAS

• ETL: Microsoft DTS packages, Microsoft SSIS packages Data2Logistics, Murray UT; Database Administrator/SAN Administrator, June’03 to Jul’06 I maintained large amounts of data for transactional as well as reporting. I Managed the NetApp SAN along with normal Database Administrator tasks which included, keeping disaster recovery solutions up to date, backups, restores, re-indexing, performance tuning, replication, server optimization, log shipping, database mirroring, training, installs, ETL, and reporting. Technologies Used:

• Database: MS SQL Server 7.0, 2000, 2005 – Oracle 8.0 – Fox Pro

• Reporting: Crystal Reports 7.0

• ETL: Microsoft DTS packages

Consonus, West Jordan UT, Database Administrator, Mar'03-Aug’03 While on contract I created disaster recovery solutions as well as scripts to help them maintain them. Migrated existing servers from SQL Server 7.0 to SQL Server 2000. Additionally I created SQL Server clustering and backup jobs for new servers.

Technologies Used:

• Database: MS SQL Server 7.0, 2000, 2005 – Oracle 8.0 STSN, Taylorsville UT, Database Administrator, Mar'01-Feb’03 I maintained along with 2 other DBA’s 500 plus database servers around the world. All data from those servers updated the primary cluster server in Salt Lake City. Updates had to be pushed monthly with changes to database objects, this was done via DTS packages and scheduled jobs which downloaded the newest DTS package and scripts and then applied them. Upon failure we the updated them manually. Daily tasks included backup, restores; server installs and rebuilds performance tuning, server optimization, clustering, ETL development, and Reporting.

Technologies Used:

• Database: MS SQL Server 7.0, 2000 – Oracle 8.0

Modus Media, Orem UT, Database Administrator, Aug'00-Feb’01 While on contract at Modus Media, I maintained existing server which included backups, restores, performance tuning, server maintenance, migration to newer versions, and production pushes. Technologies Used:

• Database: MS SQL Server 6.5, 7.0 – Oracle 7.5, Sybase 11

• Reporting: Crystal Reports 7.0

Dentrix, American Fork UT, Database Administrator, Dec'99-Aug’00 I maintained SQL Servers requiring high up-time. Daily tasks included backups, restores, performance tuning, server maintenance, Loads from agent software which pulled from Btrieve database. This also included regular rebuilds of the Btrieve database

Technologies Used:

• Database: MS SQL Server 7.0 – Btrieve

Modis Solutions, Salt Lake City UT, Programmer/Database Administrator/Analyst, Mar'98-Dec’99 Modis solutions formerly Berger & Co is a consulting firm. While staffed for them I went on various contracts to provide needed services for the companies. Some of daily tasks included but are not limited to database administration, application development, report building, report modification, data transformation, and employee training.

Technologies Used:

• Database: MS SQL Server 4.2 – 7.0, Oracle 6.5 – 7.6, Sybase 4.2 – 11, Informix, DB2, Dbase 3 – 5, MS Access, Fox Pro

• Programing languages: Visual Basic 5 – 6, Pascal, TCL, MASM

• Reporting: Visual Basic for Applications, Crystal Reporting, Lawson Report writer, Crystal Info for Essbase, Wired for OLAP

Collegiate Experience

College of Eastern Utah, Price UT, Associate of Science, 1994 Colorado Technical University, Colorado Springs, CO, BSBA May ‘08 Certifications

Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition – July 2004 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition – July 2004 Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure – July 2004 Basics of Accounting and Finance, Colorado Technical University – July 2007 Business Fundamentals, Colorado Technical University – October 2007 Project Planning, Colorado Technical University – October 2007 Business in the Global Environment, Colorado Technical University – November 2007 Human Resource Development, Colorado Technical University – November 2007 Sales and Marketing, Colorado Technical University – November 2007 Other Mentions

Microsoft Training SQL Server 6.5 - Berger & Co Training Denver CO Trilogy Backbone Training – Trilogy Austin TX

Contact this candidate