• Support large production databases (up to 10 TB) in a SQL Server Always On Failover Cluster environment • Migrated SQL Server Always On Failover Clusters to new servers • Migrated on-prem SQL Server Databases to Azure Managed Instances and PaaS SQL Databases • Migrated MariaDB Databases from AWS to Azure • Addressed issues with Always On replicas and rebuilt replicas if needed • Maintained SQL Server DR standby databases and robocopy log shipping and restore processes • Analyzed performance issues using execution plan, wait stats, Query Store, DPA, and in-house collectors • Assisted developers with fixes and performances improvements for release scripts • Updated monitoring jobs with new functionality, bug fixes, and adjustments to avoid unnecessary alerts • Created monitoring jobs to take action on high concurrent blocking to prevent performance impacts • Created process including jobs, validation, and templates for client exit data extract and destruction • Created PowerShell AD reports and script templates for security Risk Management analysis • Updated data obfuscation process for dev refreshes to significantly reduce overall execution time • Completed script release, data load, data extract, profile deletion, database refresh, and other user requests • Updated database logins / users / roles to address security audit findings • Performed monthly release deployments and maintenance patching failovers • Maintained data file and server space – performed regular analysis / submitted expansion requests as needed • Trained new employees on environments, common requests, and release deployment process • Created training documentation and maintained team documentation

• Developed new and maintained existing ETL processes and MicroStrategy reports• Performed daily health checks for 3500 audits and multiple SQL Agent jobs consisting of 400 steps • Eliminated backlog of 400 failing audits within first 6 months• Performed tuning on new and existing ETL and reports for significant performance gains• Developed T-SQL tables, views, procedures and functions for DW and ETL• Created MicroStrategy objects: tables, facts, metrics, attributes, prompts, filters, reports, users, groups• Developed awk script to process Bulk Export files to remove Idx columns

• Collaborated on design / development of custom Change Data Capture, star schemas, ETL packages (including initial template), and cube configuration for Clinical Data Marts using Oracle PL/SQL (source), T-SQL, SSIS, and SSAS (target DW)• Participated in Data Warehouse planning / analysis stages including requirements gathering workgroups, core team meetings, data quality discussions, BI training• Developed custom Oracle procs, functions, views, mvs to return complex datasets for data extracts / custom reports using PL/SQL, SQL WITH Clause, Analytical Functions, and date / time dimension tables for snapshot row creation• Developed custom Crystal Reports using conditional formatting/suppression, dynamic fields, flexible parameters including options for date windowing (Previous Day, Last Full Week, MTD, YTD, etc.) and flexible formatting to allow scheduling within BusinessObjects Enterprise• Performed data merge / migration for high profile Learning Mgmt System implementation including coordination of data cleanup efforts• Wrote data extract spec, coded and executed data extract as a revenue generating project for an external vendor• Assumed ownership of asthma registry project, re-coded data extracts to provide more complete data and improved query performance• Supported existing production reports / custom objects to include report enhancements, perf. tuning, bug fixes, object alterations • BusinessObjects Admin tasks including User, Group, Folder creation, rights configuration, publishing / scheduling of reports• Assumed leadership of emergency Oracle DB recovery efforts after permanent loss of 3 data files – successfully rebuilt 3 damaged tablespaces, recovered data from remaining data files of affected tablespaces• Submitted documentation to justify DB resource improvements to provide a more stable, recoverable environment• Created and tested Unix shell / Oracle SQL scripts for automated DB backup• Provided backup DBA support as needed

Manager of Oracle DBA Team: September 2007 - January 2008Oracle DBA: April 2006 - January 2008• Manager for global team located in US, India, and Brazil: responsible for team meetings, performance reviews, training and mentoring, client escalations• Team Lead for Project Delivery DBAs: responsible for coordination of projects and schedules, interviewing of prospective employees, mentoring of team members• Acted as Primary Point of Contact for one of the major, high-visibility internal applications groups• Coordinated DR efforts to verify and recover hundreds of databases after a loss of power to an entire floor of the data center, affecting many clients• Received Recognition Award for the FGG Database Migration Project• Received Recognition Award for Quickly installing and configuring servers for the GOIS Resource Scheduler rollout• Received Recognition Award as a Key Contributor on the Service Center Migration Team• Provided physical database administration support for Oracle 7, 8i, 9i, and 10g databases on Windows and Unix• Administered databases in Windows clustered environments using Oracle Fail Safe, including failover and adding and removing resources to and from cluster groups• Installed, upgraded, patched, and migrated Oracle 9i and 10g databases• Tested, implemented, and re-established hot standby and Oracle Data Guard• Participated in annual internal DR exercises; created new and updated existing DR documentation• Performed database backups, recoveries, clones, and refreshes• Documented upgrade and patch procedures and Data Guard implementation / conversion procedures• Created DBA Pool Task Management web-based application screen mock-ups, outlined application logic, and defined user procedures

• Worked with Oracle On Demand to support IQ’s Oracle 9i Databases and Application Servers• Assisted with development of web-based client applications using HTML, JSP, and iFrame• Created and implement new PL/SQL procedures including data archiving procedures• Debugged and enhanced existing PL/SQL and SQL code• Coordinated upgrades, patches, and database maintenance tasks• Installed and configured BusinessObjects Enterprise Report Server• Utilized database management tools including Oracle Enterprise Manager, Toad, Oracle Designer, and SQL Developer

Manager of Database Services: June 2002 - March 2005Oracle DBA: August 2000 - March 2005• Distributed new projects and assignments and organized team projects• Conducted team meetings, team member annual reviews, interviewed prospective employees, and trained new team members• Maintained, tuned, recovered, migrated, and installed Oracle 7, 8i, 9i, and 10g• Implemented, maintained, and performed activation and switchover of standby servers using Data Guard and script based solutions• Tested and successfully implemented the Amcom schema in a Replication environment• Migrated databases – Oracle 7 to 8i, 9i, and 10g, Oracle 8i to 9i and 10g• Assisted in development of a more efficient schema including a revision of database setup and sizing• Designed and implemented data specifications to standardize initial loads for new customers• Created Shell, SQL, PL/SQL, SQL Loader, and import/export scripts for initial/periodic database loads and cron/menu driven reports• Designed custom Crystal Reports, authored application specific Crystal Reports training manual, and conducted classes for customers and employees• Prepared Statement of Work, Scope of Work, and quotes for incoming service requests• Tested, documented, and implemented alternative solutions including Data Guard and Toad• Explored alternate scripting methods and languages including Perl

• Supported Amcom applications running on Oracle 7 and 8i on SCO Unixware• Specialized in VRU setup, troubleshooting, and customization• Created and compiled VRU training documentation, and trained customers and employees on VRU maintenance and customization• Analyzed debug output files• Edited and customized screen configuration files• Worked on a daily basis with SCO Unix, VI editor, Oracle 7.3 and 8i, SQL Plus, Oracle Data Browser and Query Builder, pcAnywhere, Procomm Plus, Telnet, FTP, Connect Care