Experience

Database Administrator International Data Science 2012 – Present
  • Build and maintain Windows Failover Clusters, each supporting several clustered instances of SQL Server 2014 and 2005
  • Investigate server event logs and cluster logs to resolve errors and warnings
  • Monitor SQL Server installations to analyze trends and respond to emergencies
  • Manage backup infrastructure to ensure database backups are consistent, reliable, and are retained according to business requirements
  • Responsible for configuring and maintaining certificate based mirroring between SQL Server databases, as well as snapshots created from specific mirrors
  • Configure and support log shipping where needed
  • Gather requirements and develop T-SQL code to support the needs of diverse teams and internal departments
  • Provide system architecture recommendations to guide equipment purchasing on new initiatives
  • Troubleshoot performance problems using Profiler, Performance Monitor, Extended Events, and Event Notifications within SQL Server
  • Provide documentation on server configuration and database solutions
  • Configure transactional replication to reduce network query traffic
  • Perform SQL Server migrations and server consolidations
  • Analyze query plans and DMV data to produce efficient indexes and queries

 

Developer DBA Catalyst Repository Systems 2010 – 2012
  • Mentored employees on SSIS and T-SQL development techniques and best practices
  • Analyzed application T-SQL code in real-time and provided tuning recommendations to optimize resource consumption and shorten query execution time for the flagship application
  • Conducted performance tuning on existing T-SQL stored procedures, dramatically improving ETL speed, efficiency, and reliability
  • Implemented CLR stored procedures to interact with web services, start processes on Linux machines, query Active Directory, perform file system tasks, etc. as required
  • Designed and authored customized Nagios checks using both VB script and T-SQL procedures
  • Built and maintained complex service broker applications for use in ETL processes and server maintenance
  • Gathered requirements for, authored, and tested stored procedures, user-defined functions, and triggers to meet evolving business needs
  • Performed on-call duties on a rotating schedule

 

Database Administrator Intela, LLC 2008 – 2010
  • Performed SQL Server and MySQL database installations
  • Troubleshoot, tuned, and maintained production SQL Server and MySQL databases
  • Implemented high availability MySQL replication environment
  • Automated tasks via SSIS, T-SQL, perl, shell scripting, and batch scripting
  • Developed stored procedures for processes in OLTP system
  • Generated and maintained PHP and ASP sites for data reporting and system monitoring
  • Created ETL solutions using SSIS for daily data imports
  • SQL Server and MySQL schema design and implementation
  • Administered MySQL replication involving multiple production machines in proprietary lead generation system
  • Built PHP and ASP code to store data captured via live data feeds
  • Maintained consistent backups of databases and total system infrastructure
  • Produced entity relationship (ER) diagrams documenting layout of lead generation data
  • Wrote documentation on stored procedures, table details, and SSIS packages

 

Senior Systems Analyst Intela, LLC 2007 – 2008
  • Implemented monitoring systems, providing real time monitoring and critical alerts
  • Assisted in maintaining and expanding infrastructure
  • Setup and helped maintain mailing infrastructure on Linux platform
  • Managed relationships with internet service providers (ISPs)
  • Served on Intela’s Compliance Team as the IT representative
  • Identified and resolved system problems remotely and at data center
  • Setup proprietary applications on servers both remotely and at colocation facility
  • Acted as technical liaison to Intela’s email marketing team

 

Email Systems Analyst Intela, LLC 2006 – 2007
  • Responsible for substantial portion of primary revenue channel
  • Analyzed customer data to drive marketing decisions
  • Documented procedures for reference and new employee training
  • Prepared weekly and monthly executive email marketing revenue reports