AutoNation Corporate Headquarters — Fort Lauderdale, FL 2019-Present
Senior Database Administrator
Advanced database administration for large enterprise with 250 SQL 2008-2019 Server environment across two national data centers featuring 14 FCI physical machines as large as 2TB/128 cores, multiple AAG clusters, and 200+ VMWare VMs, Azure footprint features 14 Azure SQL Databases, 2 Azure Managed Instances, 20+ VMs. AWS footprint features, PostGres RDS, 2 SQL Server RDS, 8 Aurora/MySQL Instances, and 40+ VMS. NoSQL footprint features 6 MongoDB clusters in Atlas and Snowflake cloud frameworks. Standardized and stabilized a previous hectic environment. Conduct intensive performance Reviews at three levels: leveraging DMVs to identify slow queries, High CPU, high read queries, at the execution plan level and at the best practice procedure statement level. Identified dozens of issues, brought alerts down to real issues and not noise alerts. Migrated 40+ physical and virtual productions servers to new storage array, typically new storage provisions and log shipping to the same server for minimum cutover time. Daily duties typically involve creating new PowerShell scripts to scan/review/deploy fixes across the DB enterprise.
- Facilitated migration of 45 servers and domains as part of large scale merger; consolidated servers in VM hosts as vmotion, or side-by-side migration builds.
- Automated reporting for 200+ initiatives generated automatically in multi sheet excel documents, complete with code suggestions.
ENVISION PHYSICIAN SERVICES — Sunrise, FL 2017-2019
Senior Database Administrator
Spearhead end-to-end database administration for large enterprise with 200 SQL Server environment across five national data centers, as well as Azure and AWS cloud frameworks. Conduct intensive code reviews to identify issues, ensure adherence with best practices, optimize performance through numerous metrics, as well as manipulating code to function in high recount environments. Oversee SSIS development, while documenting database and SSIS/SSAS packages, and migrating database/SSIS packages to TFS.
- Facilitated migration of 45 servers and domains as part of large scale merger; consolidated servers in VM hosts as vmotion, or side-by-side migration builds.
- Automated reporting for 200+ initiatives generated automatically in multi sheet excel documents, complete with code suggestions.
COMMUNITY CARE PLAN | SOLSTICE BENEFITS —Sunrise, FL 2016-2017
Senior Database Administrator
Handled full-scope database oversight in SQL2014/SQL2016 environment, while supervising Dev Ops DBA and SSIS development. Managed documentation of all databases and packages, as well as handling migrations for code and SSIS packages into TFS. Evaluated code to warrant alignment with internal and external standards, and implemented performance metrics to streamline performance.
Instituted performance and process improvements by undertaking critical tuning initiative to modify existing production procedures and modify/add indexes. Ascertained and eliminated deadlocks, while performing in-depth assessments of code.
- Conducted execution plan analysis, as well as overseeing deadlock CML shredding, TSQL enhancements, SQL automation, and suite of exception reports created for ensuring coherence with DBA best practices.
- Drove automation of numerous SSIS packages to free up resources for other projects.
- Generated two orders of magnitude performance gains due to effective implementation of tuning process.
HOSPITAL PHYSICIAN PARTNERS — Hollywood, FL 2013-2015
Senior Database Administrator, Senior Developer
Drove full-cycle database management and development to ensure data consistency, integrity, and security. Elicited and analyzed business requirements and programmed multiple multi-tiered platforms to facilitate subsequent fulfilment. Provided quality support for WCF/WPF XAML application, with focus on back-end DLL’s and WCF services. Oversaw operations of Legacy support websites written in ASP.NET, and managed customized migration of various data sources, including customer-specific and geographical data.
- Daily enhancements of various applications to comply with business improvements and requirements.
Additional Experience as Senior Database Administrator, Senior Developer at Housing and Development Software Inc. | Network Administrator/Senior Web Developer at US Installations Inc. | Web Developer at Carroll Enterprises, Inc. | Network Hardware and Software Technician and Help Desk Analyst at Berkshire Bank