Oversaw the design and implementation of data, application, and infrastructure solutions across the organization.Established and led the Enterprise Architecture Steering Committee that guided the transition to Product Verticals and clarified the roles and responsibilities of each team.Spearheaded the migration of our on-premises systems to AWS cloud services, leveraging modern and scalable technologies.Evangelized the adoption of ephemeral environments and other best practices to improve efficiency and quality.Collaborated with the CPO, COO, CDSO, and other senior leaders to align our technology strategy with our business goals and vision.Contribute to development efforts in various technologies including Helm Docker Dotnet (C#, Powershell) Python (pandas, pyspark, boto3) Terraform AWS Services such as Lambda, Step Functions, Glue Jobs, API Gateway SQL Server on RDS, EC2, and K8sCurrently involved in integration and coordination efforts after our acquisition by GoodRx such as merging InfraOps and Devops teams, aligning engineering standards and practices, and fostering communication between equivalent teams.

Ensured availability of SQL Server clusters by analyzing workloads and adapting VM configurations to accommodate.Implemented SentryOne monitoring tool to provide observability, allowing us to tune and increase response times of the SQL Server instances.Managed Snowflake credit consumption and assisted with data ingestion and query practices.Implemented replication to allow for a Read-Only server to improve ETL performance from our OLTP systems to our OLAP systems.Managed and provisioned access to SQL Server and Snowflake instances.Defined and implemented controls to comply with HIPAA and SOX.Updated all systems to encrypt data in transit and at rest.Defined and implemented RPO and RTO standards.Created and maintained ETL pipelines ingesting and sending various datasets.Migrated database projects from FluentMigrator to DACPACs.Modeled data.Modernized engineering by defining and evangelizing data best practices, such as standard naming, normalization, fit-for-purpose data storage, and defined data of lifecycles.Implemented Infrastructure-as-code through custom PowerShell scripts.

Created SSIS packages to ETL data received from external venders such as claim information,eligibility, and payment information.Built a client application to dynamically load capitation files received from health plans. The application can handle different file types (.txt, .dbf. csv, excel, etc.) and can also handle changes to the files like additional columns being added or removed in some cases. It allows the client to also specify a crosswalk to translate data from taxonomy used by the heath plan to taxonomy used in-house.Performance tuned our capitation process, alleviating pressure on our AlwaysOn infrastructure while also shortening the runtime from 12 hours to 45 minutes.Found and corrected a major bug in the capitation process helping with the accuracy of the payments made.Created several alerting reports and debugging tools so that process managers could debug issues with the capitation process and correct them with minimal IT involvement.Created solutions to help the other developers with tasks such as creating audit tables and debugging long running processes.Created the batch geocoding process to geocode addresses stored in our system using the Bing API, while also normalizing the addresses.Researched and implemented a source control solution that matched our development style.Created monitoring and data collection that resolved issues with the AlwaysOn infrastructure that caused nightly outages.Managed testing and development of the internal call tracking application used by the member services department.Developed the database structures and did the testing for our new provider directory search portal. This included using geography types to calculate distance, parsing our imperfect provider data, translating to xml, and returning the data to the web front end.

Administration including Planning, Installation, Deployment/Implementation, Upgrade/Migration, Advanced Configuration of MS SQL Server 2000(retired), 2005 (retired), 2008/2008r2/2012Use of Native tools such as Performance Monitor, Profiler and external tools like SQL Sentry and Dell Spotlight for SQL Server Enterprise for performance monitoring and tuning of MS SQL Server 2008/2008r2/2012. Administration of OLTP environment with Extraction Transformations and Loading (ETL) using DTS packages or customized VB2012, PowerShell, CMD line batch scripts.Installation/administration of Cluster Servers for MS SQL Server 2008/2008r2/2012 Enterprise Edition hosted on MS Windows 2003/2008/2012 Server.Point of Contact for the Billing Support team and the BI team for performance optimization, code review, and indexing strategies to ensure the Billing and Data Warehouse SQL Server systems did not become overburdened. Monitored Transaction replication and Snapshot replication used throughout the environment to ensure that data was pushed quickly.Deployed code changes to production and troubleshot issues with deployment scripts.Advised on resolutions for blocking and deadlocking issues, helping design code to utilize locking properly to ensure that concurrency could be maintained on the systems.

Administration including Planning, Installation, Deployment/Implementation, Upgrade/Migration, Advanced Configuration of MS SQL Server 2000(retired), 2005 (retired), 2008/2008r2/2012Use of Native tools such as Performance Monitor, Profiler, and external tools like Idera Diagnostic Manager for performance monitoring and tuning of MS SQL Server 2008/2008r2/2012 residing databases on SAN storage. Set up SQL Server Databases in a lab environment and duplicate the functionality of the SQL Server in Development, Test/Acceptance and Production environment.Backup/restore, disaster recovery using native SQL Server commands.Administration of OLTP environment with Extraction Transformations and Loading (ETL) using DTS packages or customized VB2012, PowerShell, CMD line batch scripts.Configuration and Importing Data from Oracle Systems including R12 Servers (or other data sources) to MS SQL Server using Linked Servers on OLE DB Provider and SSIS.Planning, implementation, and administration of Log Shipping with MS SQL Server 2008/2008r2. Installation/administration of Cluster Servers for MS SQL Server 2008/2008r2/2012 Enterprise Edition hosted on MS Windows 2003/2008/2012 Server.