Professional Skills

Languages
T-SQL
PowerShell
C#
PHP
Shell scripting
Batch scripting
Databases
SQL Server 2014, 2012, 2008 R2, 2008, 2005
SQL Server Clustering
MySQL 5.0 and Later

Operating Systems
Windows Server 2012, 2008 R2, 2008, 2003
Windows Failover Clustering
Windows XP, Vista, 7, 8
Linux

Software / Tools
SQL Server Integration Services
SQL Server Profiler
Service Broker
MySQL Workbench
Microsoft Office 2007, 2013
Dell LiteSpeed for SQL Server
BackupPC
Nagios, Performance Monitor
OmniAudit
SolarWinds Ignite

 

Accomplishments

  • Built an automated index maintenance tool capable of rebuilding or reorganizing indexes based on configuration settings, including database name and fragmentation level
  • Designed, developed, and implemented Automated QC framework (T-SQL) for an in-house ETL system, saving thousands of man hours in the first few months after launch
  • Built, implemented, and trained employees on a proprietary deployment tool (T-SQL, C#, PowerShell) capable of checking T-SQL code out from CVS or SVN and applying it to hundreds of SQL Server databases across the organization
  • Developed a C# application to dynamically create and execute SSIS packages to move data between SQL Server databases on separate instances
  • Reduced risk exposure by tightening SQL Server security and introducing certificate based signatures, allowing employees to perform work duties without over-providing access
  • Automated business processes within a heterogeneous environment consisting of SQL Server, Web services, and Linux servers