• SQL database expert with over 12 years of experience in programming, analysis, administration, and architecture. Mastery of SQL Server 2000, 2005, 2008, and 2012. Experience in web application development using both C .Net and VB.Net.
• Microsoft Certified Technology Specialist, CompTIA Security , and Experts Exchange Master Certified in SQL Server 2000, 2005, and 2008. Defense Information Systems Agency Level I System Administrator certified. Top Secret with SCI TS/SCI security clearance.
• Selected by Mike Hotek, renowned SQL Server author, as Technical Editor for three upcoming SQL Server 2012 books by publisher Champion Valley Press.

Confidential

• Lead SQL Engineer responsible for directing all work on the central data system of a multi-billion dollar corporation with over 3500 locations across the U.S.
• High level TSQL development stored procedures, functions, triggers, DDL, Service Broker, etc. in both extremely high traffic OLTP and OLAP environments with over 30 million new rows of data daily.
• Performance tuning against multi-billion row tables in both relational and data warehouse environments. 30 TB in size
• Applied Scrum Agile SDLC model in all areas of work for fast, efficient completion of projects.
• Tightly integrated with development team to provide RESTful web applications using combinations of DBA developed stored procedures and Hibernate based queries while leveraging Maven for project and build management.
• Provided database side support and ongoing development of SONIC's custom supply chain and inventory management web application.
• Established a stable infrastructure by consolidating over 20 stand-alone servers to a 5 node failover cluster while upgrading from SQL 2000/2005 to 2008 R2.
• Implemented mandatory use of Subversion SVN source control repository.
• Designed and enforced development/staging/production promotion standards, change control documentation and change approval process.
• Implemented continuous integration and unit/regression testing using TeamCity along with mandatory peer review documentation using JIRA/Crucible to ensure stable and reliable releases.
• Creation and support of all aspects of SQL/Windows failover clustering including networking, OS, Active Directory Group Policy, hardware configuration, and SAN allocation.
• Member of the 6 person Brand Systems Technical Architecture Committee, which is responsible for determining and guiding the future of technology at Sonic.
• Standard DBA administrative tasks such as 24/7 support, replication, and disaster recovery.
• Performance monitoring using SQL Server Profiler and data management views as well as custom self-written automated reports.
• SharePoint 2007 and 2010 administration.

Confidential

• Responsible for 100 multi-site SQL Server 2008 R2 servers in support of the Department of Defense Enterprise Email project at the Defense Information Systems Agency.
• DBA lead of the largest data handover in U.S. government history.
• High level TSQL development stored procedures, functions, triggers, DDL, etc.
• Troubleshooting connectivity to SQL Server in an extremely secure environment.
• Guaranteeing security of servers in accordance with DoD guidelines and STIG documentation.
• Configuration of Windows, Active Directory, and SQL Server security policies.
• Utilized MSX, SQL Policy Based Management, and custom SSIS packages to monitor and secure servers across multiple physical locations.
• Implementation and support of Windows and SQL Server failover clustering.
• Site to site SQL failover utilizing log shipping, database mirroring, and transactional replication.
• Database support for Systems Center Operations Manager SCOM , Rights Management Server RMS , Blackberry Enterprise Server BES , Forefront Identity Manager FIM , and CommVault.
• Standard DBA administration tasks such as 24/7 support, replication, log shipping, failover clustering, disaster recovery, performance monitoring and performance tuning.

Confidential

• Designed, developed, and implemented an ASP.Net/SQL 2005 web application to collect, analyze, and report on federally mandated HUD HMIS data collected by users throughout Oklahoma.
• Developed a bar coded ID card application for use in area homeless shelters to simplify data entry into the central application.
• Developed a GPS tracking application with Google Maps to interface homeless transportation systems with the central application.
• Architecture of a highly normalized database using generalized federal mandates to meet federal regulations while allowing easy expansion for future application development.
• Decreased the amount of time required to enter a full client record from 20 minutes in previous software to less than 3 minutes.
• More than tripled partner agency participation by simplifying software and increasing HMIS customer support quality.
• Standard DBA tasks such as maintaining database backups, developing disaster recovery plans, and ensuring server availability in a 24/7 environment.
• Performed on-site visits with homeless service providers to craft an application that would meet their needs.
• Full time employee from Jan. 2005 August 2007. Converted from FTE to contractor in August 2007.

Confidential

• Developed ETL solutions in T-SQL, VB.Net and C .Net to convert aging record keeping systems for use with Global's 911 dispatch software.
• Converted highly sensitive and critical law enforcement data to SQL from many formats including AS/400, COBOL, FoxPro, Dbase, Text/CSV, and SQL.
• Standardized data conversion process by creating documentation and developing re-usable tools for data cleansing and extraction.
• SQL Server performance tuning and stored procedure evaluation/modification.
• Standard DBA tasks such as maintaining database backups, developing disaster recovery plans, and ensuring server availability.

Confidential

• Developed and maintained complex SQL queries, triggers, views, and stored procedures in a high traffic/high demand OLTP database environment.
• Partnered with marketing department to increase potential customer contact database from 300K to over 5 million records.
• Developed bar-coded mail delivery system and application to simplify removal of returned mail addresses from marketing database.
• Developed data farming application to gather new potential customer data from state license and competitor websites.
• Developed a query building application that tied TSQL with geolocation data and Microsoft MapPoint which enabled marketing users to create complex marketing contact lists without IT involvement.
• Data cleansing and de-duplication of marketing databases.
• Standard DBA tasks such as maintaining database backups, developing disaster recovery plans, and ensuring server availability in a 24/7 environment.