Led a high-performing team to achieve project goals and deliver exceptional results for the CVS Aetna Medicaid unit. Actively managing a mix of SQL 2014 – 2019 systems. Manage databases to ensure data integrity and availability for business operations achieving 99.99% uptime. Responsibilities:• Manage a team of 8 DBAs from daily activity to project activitieso Provide opportunities for team members to expand their knowledge through individual assignment and/or projectso Provide technical guidance and/or resolve technical issues that others can’t remediateo Manage tasks / incidents within Service Now• Provide appropriate sizing, resourcing and configuration design of database servers on all RFPs• Integrated diverse systems to streamline processes and increase efficiency.• Managed multiple projects simultaneously to ensure deadlines were met and deliverables were of high quality.• Optimized SQL queries to improve database performance and enhance data retrieval speed.• Participate in strategic planning sessions• Managed vendor relationships from the technical aspectso Cognizant (QNXT) and IMA (Dynamo) on identifying troublesome queries, implementing additional indexes and deploying updated queries provided by the vendor.• Successful implementation of a new Oklahoma Medicaid plan up to 450k membership enrollment• Upgraded 50 production SQL 2016 systems to SQL 2019 in support of a mission critical application upgrade within a 4 month period using PowerShell Scripting• Participated in Audit compliance reviews• Actively support more than 90+ production database systems with 900 TB of data• Facilitated numerous SQL Server version upgrades from 2014 to 2019• Worked with various business areas to ensure successful migration to the Azure cloud. • Major QNXT Upgrade to 5.9 R2 and completing it successfully early.• Manage snapshot and transactional database replication• Manage an High Availability systems utilizing Microsoft’s Always-On technology

Manage mixed SQL Server 2014 / 2016 environment for the Aetna Medicaid Unit. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements. Responsibilities:• Supported more than 90+ production database systems• Facilitated numerous SQL Server version upgrades from 2008 to 2016• Implemented / maintain snapshot and transactional database replication throughout all environments• Manage an High Availability systems utilizing Microsoft’s Always-On technology • Designed the infrastructure and implemented IBM Virtual Data Pipeline software with an initial setup of 8 virtual appliances. Currently at 45 appliances within an ingestion of 150 TB of data and 750 workflows.• Managed numerous QNXT application upgrades starting with version 5.1.6.6.• Managed numerous Dynamo / DAG application upgrades• Worked closely with various Medicaid vendorso Cognizant (QNXT Vendor) on identifying troublesome queries, implementing additional indexes and deploying updated queries provided by the vendor.o IMA (Dynamo / Appeals & Grievances) on identifying troublesome queries, implementing additional indexes and deploying updated queries provided by the vendor.• Improved/resolved technical issues surrounding the backup/recovery strategy• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency using DMVs, SQL Profiler, and SSMS • Responsible for monitoring and making recommendation for performance improvement and this involved index creation, index removal, index modification, file group modification and adding scheduled jobs to re-index and update statistics in databases

Manage SQL Server 2008 R2 environment for CMS on the CDAT (Central Data Abstraction Tool) project . Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements. Responsibilities:• Installed and administered Two-Node cluster Active/Passive on Windows 2008 R2 on SAN environment. • Extensively worked on Dynamic Management Views in SQL Server.• Rebuilding / Monitoring the indexes at regular intervals for better performance.• Recovering the databases from backup in disasters and implementing Point-in-Time Recovery solutions.• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency using DMVs, SQL Profiler, SSMS, Database Engine Tuning Advisor (DTA) and Spotlight.• Implemented the snapshot isolation levels on numbers databases.• Responsible for monitoring and making recommendation for performance improvement and this involved index creation, index removal, index modification, file group modification and adding scheduled jobs to re-index and update statistics in databases.

Managed SQL Server and Oracle environments for the NASA Shared Service Center. Provided support for multiple agency-wide applications including Disaster Recovery planning, execution, database security, 24x7 support and database upgrades. Responsibilities:• Installed and administered all SQL Server databases / Oracle 10g / 11g instances and environments• Automated hot backups using Oracle RMAN.• Managed the migration of SQL Server 2000 through SQL 2012.• Participating in the Oracle 10g to 11g upgrade.• Rebuilding / Monitoring the indexes at regular intervals for better performance.• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency using DMVs, SQL Profiler, SSMS, Database Engine Tuning Advisor (DTA) and Spotlight.• Responsible for monitoring and making recommendation for performance improvement and this involved index creation, index removal, index modification, file group modification and adding scheduled jobs to re-index and update statistics in databases.