| 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