Experienced Senior SQL Database Administrator with over 20 years working across cloud, hybrid, and on-prem environments. I’ve led major SQL Server and MySQL projects in healthcare settings, focusing on performance tuning, security, automation, and high availability. Comfortable in both Azure and on-prem setups, I enjoy building reliable systems, streamlining processes, and helping teams stay ahead of issues with the right monitoring and tools in place. Strong background in migrations, CI/CD, and supporting fast-paced, data-heavy applications.
Hi, I’m
Lance Lugo
Senior Database Administrator
Yulee,FL
Summary
Overview
11
years of professional experience
2
Certifications
Work History
HealthAxis
Senior DBA
12.2023 - Current
Job overview
- Lead DBA for an enterprise-scale healthcare data platform spanning Azure SQL, Managed Instance, and on-prem VMs, handling HIPAA-sensitive data across production and DR environments
- Built CI/CD pipelines in Azure DevOps to automate deployment of T-SQL, ETL, and compliance refreshes across multi-region platforms
- Created custom PowerShell and T-SQL jobs to monitor Azure SQL, Managed Instance, and VM-based resources for CPU, memory, DTU/VCU usage, IO throughput, and growth trends
- Developed automated alerts and runbooks for proactive incident detection using Azure Monitor, Log Analytics, and Automation Accounts
- Designed and implemented resource usage dashboards in Azure (Kusto + Workbooks) to track compute/storage consumption and predict scale needs
- Worked closely with FinOps to forecast Azure spend, align workload scaling with budget goals, and right-size underutilized resources
- Engineered tagging and policy strategies to enforce RBAC, region affinity, and service-level requirements across dozens of resource groups
- Created centralized audit views that consolidate health checks, usage telemetry, and patch compliance for all cloud and hybrid SQL servers
- Built custom KQL queries in Azure Log Analytics to monitor query performance across Synapse Pipelines and Azure SQL workloads
- Automated storage growth tracking and capacity alerts across elastic pools, single DBs, and MI, minimizing unplanned downtime
- Owned Azure Security Center remediation for all database platform-related recommendations including TDE, audit log retention
DataLink Software
DBA Team Lead
02.2020 - 12.2023
Job overview
- Led a high-impact SQL Server migration from on-prem to Azure Managed Instances, moving 15+ TB of critical healthcare data.
- Consolidated over 50 legacy SQL Servers into 20 optimized Azure resources, reducing licensing and storage costs by 35%
- Designed and implemented Distributed Availability Groups spanning multiple Azure regions, ensuring high availability and cross-region disaster recovery across 10+ Availability Groups
- Migrated all on-prem SSIS workloads into Azure Synapse Pipelines, improving orchestration and scalability.
- Deployed and configured Astronomer (Apache Airflow) for enterprise-grade data pipeline orchestration, managing DAGs for ingestion, transformation, and validation across SQL, Snowflake,blob, and API sources
- Oversaw the planning, setup, and governance of Snowflake Data Cloud, including warehouse sizing, RBAC, encryption, storage tiering, and usage monitoring
- Successfully migrated critical SQL-based Data Warehouse workloads into Snowflake, optimizing query performance and decoupling compute from storage for flexible scale
- Developed security frameworks in Snowflake including role-based access, object-level privileges, and network policies for HIPAA/HiTrust compliance
- Created CI/CD deployment pipelines using Azure DevOps and Octopus Deploy, for DB refreshes, DDL and DML updates.
- Spearheaded the company’s largest client onboarding and database upgrade initiative — migrated production clusters from SQL Server 2016 to 2019 with zero downtime.
- In addition , I was also instrumental in deploying and configuring SQL Sentry for our SQL ecosystem. Identifying poor SQL and optimizing
Builder
Senior DBA
03.2017 - 09.2019
Job overview
- Managed 24/7 uptime across AWS SQL environments (multi-region)
- Consolidated and migrated 50+ servers to cloud using P2V and V2C strategies
- Built RedGate SQL Clone-based QA refresh pipeline for developers
- Optimized performance via Columnstore indexes and partitioning
- Created CI/CD deployment processes with Jenkins and Redgate SQL Deploy
- Provided SSRS dashboards for SQL health and KPI metrics
ChenMed
Senior Database Engineer
12.2014 - 03.2017
Job overview
- Managed full-stack database infrastructure (MySQL on CentOS, MongoDB, MSSQL)
- Led replication and sync of on-prem to AWS using MySQL/Mongo RDS
- Implemented Vormetric TDE encryption across MySQL and MSSQL
- Automated PHI de-identification via Cron jobs and DMSuite
- Built HL7 ETL pipelines, supported ICD9 to ICD10 conversion
Education
Grand Rapids CollegeGrand Rapids, United States
Bachelor of Arts from Liberal Arts/Computer Science
University Overview
Skills
SQL query optimization
undefinedCertification
MCDBA SQL 2000
Timeline
Senior DBA
HealthAxis
12.2023 - Current
DBA Team Lead
DataLink Software
02.2020 - 12.2023
ISSA CPT
04-2019
Senior DBA
Builder
03.2017 - 09.2019
Senior Database Engineer
ChenMed
12.2014 - 03.2017
MCDBA SQL 2000
06-2004
Grand Rapids College
Bachelor of Arts from Liberal Arts/Computer Science
Similar Profiles
Kailah PhelpsKailah Phelps
Member Service Team Lead at HealthAxisMember Service Team Lead at HealthAxis
Kailah PhelpsKailah Phelps
Contact Center Supervisor at HealthAxisContact Center Supervisor at HealthAxis
Amanda TyeAmanda Tye
Business Operations Manager at HealthAxisBusiness Operations Manager at HealthAxis
Michael AlvarezMichael Alvarez
Outside Operations at Tpc SawgrassOutside Operations at Tpc Sawgrass
Kayla MosherKayla Mosher
Restaurant Manager at Sixty East Italian Cucina and Martini BarRestaurant Manager at Sixty East Italian Cucina and Martini Bar