• Identified BLOB storage relocation opportunity for a 40% (~4TB) reduction of OLTP size with a small development investment resulting in potential direct cost savings of approximately 15K annually without additional BLOB growth • Championed use of polyglot persistence strategy using non-relational storage platforms (S3, Redis, SQS) for direct cost savings or indirect savings through performance improvements • Identified gaps within static code analysis toolset and proposed gated check-ins for database layer objects as source of agile coding standards document to close the feedback loop in DevOps process • Provided developer training on T-SQL standards and performance through various channels • Documented design, performance and security revisions required in whitepapers for development teams to facilitate remediation • Responsible for project roadmap and vision for DBA team aligning with strategic initiatives and influencing long term development direction • Identified performance breakers and costly annual maintenance agreements with prior monitoring vendor • Proposed and implemented SentryOne to satisfy performance visibility requirements for seasonal operations • Implemented LiteSpeed for backups using S3 as storage device for cost reductions • Reduced SQL Server licensing footprint by 25% in year 1 by identifying redundant or unused workloads • Worked with team to facilitate datacenter shutdown through migration and shutdowns of legacy database servers • Worked with team to develop/implement plan to forklift 20+TB of data from on-prem to AWS with zero data loss • Reviewed and recommended adjustments to instance sizing and EBS volume types for optimal CPU/memory ratio given workload characteristics and cost constraints for SQL Server workloads • Implemented migration plan for primary application OLTP database from SQL Server 2012 to 2017 in 4 months • Educated developers during code reviews and demonstrating updated T-SQL syntax

• Joined a team of two DBAs in maintaining and developing in house software solution “BlueShip” built entirely in Azure infrastructure• Enhanced implementation of 2014 availability group with more stable cluster configuration resulting in less risk of production outage• Proposed and implemented SQLSentry (SentryOne) resulting in greater insight in performance characteristics• Proposed and implemented LiteSpeed for backups facilitating point in time object level recoveryo Implemented automated daily restores as a secondary integrity check to ensure recovery capabilityo Backup solution was architected with geo-redundant storage to ensure minimal data loss in the event of a loss in datacenter availability• Reduced size and growth rate of database by implementing page compression and migrating image data onto blob storage outside of the database• Improved the daily index maintenance from an average of 1 hour nightly to under 15 minutes nightly average with proper fillfactors and compression• Provided principal SQL development support for project to convert from legacy billing system to an integrated billing system within the “BlueShip” product• Advised on patch management strategy for Windows and SQL Server systems with emphasis on a monthly patching cycle as a best practice• Maintained library of CodeSmith templates for generating commonly used T-SQL stubs and SQL Prompt snippets resulting in countless hours of development time recaptured• Collaborated on a standard SQL Prompt style with Red-Gate resulting in multiple hours in saved development cost• Identified cost reduction opportunity by volume licensing Office 365/Windows 10 and provided principal cost justificationo Volume Licensing project would lead to 100K savings annually as proposedo Project would lead to a substantially more secure enterprise following implementation as proposedo Project would lead to technology standardization further improving cost savings with time

• Responsible as member of DBA team for 11+TB of production data across 650+ databases spanning 2000 to 2014• Investigated reports of server issues promoting root cause analysis whenever possible to avoid issue recurrence• Primary technician in multiple Microsoft escalationso Case involving 2012 poor cost estimates query, main root cause found to be cost estimation mechanism in 2012, recommendation was to upgrade to 2014 and move database compatibility to 120o Case involving deadlocked scheduler that caused HADR server not to fail over, root cause was noted as a disk subsystem issueo Case involving frequent stack dumps, root cause confirmed as KB2828833 by Microsoft Support in agreement with analysis• Investigated instances of high file latency metrics that were out of upper bounds hardware using xperf/wpa with partial root cause determining that filter drivers were suspected• Investigated high ASYNC_NETWORK_IO waits, root cause determined an improperly configured JDBC driver• Performed index analysis using maintenance routines that provided logging for analytics on common metrics• Evaluated disk throughput on new and existing hardware using SQLIO and DiskSpd• Advised hardware purchasing teams on ideal SQL configurations• Implemented partitioning on data warehouse to facilitate maximum disk throughput• Fostered relationships with internal teams to facilitate troubleshooting as needed for full root cause analysis• Routinely handled code reviews providing code improvement suggestions for sub-optimal routines• Developed a POC inbound 834 file parser with SSIS using CozyRoc components dynamically configured though a framework database• Created SSIS package that facilitated consolidation of multiple SSIS packages into more dynamic solution• Created set of stored procedures allowing configurations to be migrated between frameworks using XML with primary key values being reseeded but relationships remaining consistent within respective environments

• Responsible for building all new SQL Servers implemented in the environments from Development to Production• Responsible for maintaining 4 in-house developed production database servers with a total of 8 databases totaling approximately 300GB• Developed new SSIS packages to replace DTS packages wherever possible• Supported SQL Server versions from 2000 to 2012• Implemented SSIS packages to pull data into access files for customers to be made available by SFTP• Responsible for performance tuning slow running queries in production environments• Responsible for advising development about best practices surrounding performance and security for SQL Server• Investigated process crashes and memory leaks, escalating to Microsoft for resolution as needed• Advised management about hardware purchases when needed• Responsible for an additional 10 production SQL Servers supporting various front end applications ranging from Sharepoint to a Cisco phone system• Responsible for all SQL Servers supporting all phases of software development life cycle• Developed T-SQL conversion scripts for data migration as part of a new client acquisition• Implemented data aggregation tools to collect data about production SQL Servers to further assist troubleshooting and trend analysis• Routinely analyzed indexes for optimization opportunities and pruning• Implemented automated custom alerting for application events to avoid human intervention when possible• Implemented SQL Server best practices wherever possible• Developed custom scripting component for SSIS package for custom vendor flat file layout• Implemented database mirroring for warm site DR

• Completed project to parse log files imported into a database to determine, error, demographic information, and time of error for HL7 based interface system utilizing T-SQL stored procedures• Created SSIS package to pull information from disparate systems regarding security related logs• Create ad hoc T-SQL reports to retrieve clinical data in EHR system• Investigate stored procedure errors to determine root cause, cleanse data when necessary• Investigate upgrade to vendor index maintenance scripts• Investigate root cause of system crashes caused by EHR system on development environment• Monitor SQL Agent jobs and investigate failures to determine root cause• Evaluate indexes to determine duplicates in vendor system• Designed SSIS package to pull health data from EHR to be used for automated completion of research study applications• Create T-SQL scripts for use in identification of duplicate or new indexes between Test and Producation systems during upgrades

• Install SQL Server 2008 on new servers• Assisted Sr DBA with investigation of feasibility of moving SQL backups off SAN storage to lower cost NAS storage• Write SSIS packages for integration work• Implement DTS packages for integration work• Create new active directory accounts upon request• Document changes to environment• Wrote PowerShell scripts to audit Active Directory for stale logins (logins older than 90 days)• Use windows debugger to determine root cause of blue screen crashes• Implemented silent installs within deployment image when possible• Attend required training events• Train co-workers in new technologies as part of department training initiative• Research of complex software problems• Investigate crash dump files to determine root cause• Install and configure SQL Server on new servers• Write PowerShell scripts to automate repetitive tasks• Analysis of SQL Server query history to determine table structure of vendor application• Escalate calls for service to proper groups• Analyze web traffic following web filter changes• Participate in on call rotation• Write T-SQL queries for identification of unique records across composite key columns• MicroStrategy user administration• Administer Websense hosted e-mail and web filtering solution• Analyze performance logs using PAL to determine cause of performance problems

• Managed 10 precints on August 24, 2010 for Florida's Primary Elections• Diagnosed issues with voting equipment in the field during election, escalated issues if neccessary• Participated in pre-election testing and reprogramming of voting machines to allow modem uploading of results after voting ended• Assisted with absentee ballot procedures• Assisted with technical support following election• Assisted with duplication board procedures• Programmed cell phones for roving technicians used during elections

• Maintain master images of workstations• Create and maintain groups for Active Directory• Implement groups for student and staff accounts• Implement disk quotas for student and staff accounts• Implement bi-weekly backup schedule with monthly full backup• Investigate and implement GNU licensed lab management software (iTALC) for all classrooms• Maintain privileges for students in Active Directory• Request new staff members to be added to Active Directory• Request transfers for existing district employees when moving to Simmons Career Center• Receive transfer requests for district employees moving from Simmons Career Center• Migrate staff and student folders from Windows Server 2000 to Server 2003• Condense applications from 2 servers to reside on one Windows Server 2003 machine• Phase out Windows Server 2000 from school• Write up maintenance requests for repair on equipment beyond normal repair capabilities• Deploy software and PC images to workstations through Altiris• Create scripts to perform routine maintenance (defrag, delete profiles for student computers, etc) to be scheduled and deployed via Altiris• Monitor virus intrusions through Symantec Endpoint• Maintain inventory of all equipment and room assignments• Check-in and check-out books for students and teachers• Repair library materials as needed• Keep records of all software installed on network workstations• Keep records of all calls for workstation repair• Instruct students on basic to intermediate PC repair• Instruct students on basic to intermediate troubleshooting• Inspire students to perform at their highest level of academic ability• Bring inappropriate content stored on server to the attention of the administration for proper disciplinary action• Bring security breaches to the attention of administration for proper response• Locate missing or misplaced equipment• Etch asset numbers on new equipment

• Install and maintain equipment based on Linux kernel in Nielsen homes • Diagnose equipment communication problems using command prompt• Insert sensor into cable DVR boxes and DVD-R players to capture data• Install 802.11g wireless communications where PLM based communications fail• Solder sensors into Nielsen families audio and video equipment in special cases• Diagnose and repair any faults with equipment, prioritizing repairs based on workload• Use multi-meter to determine proper voltage for sensors• Install CAT 5 network cable in cases where normal communication methods fail