Applied Systems · 1 month ago
Senior Data Governance & SQL Server Optimization Consultant
Baltimore, MD
Full-time
Onsite
Senior Level, Lead/Staff
10+ years expApplied Technology Services is seeking a Senior Consultant to lead the Data Governance and SQL Server Optimization efforts for a NextGen EHR environment. The role involves conducting assessments, developing governance and retention strategies, and implementing database performance optimizations.
InsuranceSoftware
Responsibilities
Profile NextGen SQL Server environment including schemas, tables, data volumes, performance metrics, and configuration settings
Conduct a full database health check (indexes, queries, wait stats, tempdb, backup strategy, file layout)
Identify unstructured data storage mechanisms (BLOB vs. file shares) and quantify volumes
Review Cohesity backup capabilities and support instant-mount analysis
Conduct stakeholder interviews with IT, Compliance, HIM, and leadership teams
Classify 0–40 years of patient and document data by age, activity, type, and status
Develop retention policies aligned with HIPAA and Maryland medical retention laws
Identify all data suitable for archival storage and quantify reduction potential
Produce governance framework, archiving criteria, lifecycle strategy, and access model
Support business case development including ROI, risk mitigation, and cost/benefit analysis
Implement missing, unused, duplicate, and fragmented index changes
Tune slow/excessive queries and stored procedures
Apply configuration improvements (memory, MAXDOP, tempdb, file/filegroup optimizations)
Develop and deploy automated maintenance plans for backups, statistics, index rebuild/reorganize, DBCC CHECKDB, log management, and cleanup
Perform database cleanup, compression, and optimization tasks
Validate improvements and document before/after metrics
Deliver full assessment documentation, archiving analysis, database optimization report, maintenance plan documentation, and implementation roadmap
Provide rollback procedures for all changes
Conduct stakeholder briefings and technical knowledge transfer sessions
Qualification
Required
10+ years SQL Server DBA/consultant experience with proven performance tuning expertise
Strong background in SQL Server internals, DMVs, indexing strategies, and optimization frameworks
Experience with large healthcare datasets, PHI, HIPAA, and retention regulations
Familiarity with data governance, lifecycle management, and archival planning
Experience supporting EHR platforms; NextGen strongly preferred
Ability to work within strict maintenance windows, change control, and regulated environments
Preferred
Experience with Cohesity backup/restore environments
Experience with Redgate, SolarWinds DPA, or sp_Blitz toolsets
Prior work on large-scale archiving or data lifecycle initiatives
Benefits
Competitive compensation
Health benefits including Medical, Dental and Vision
Vacation and Personal Days
401K
Employee Assistance Plan
Continuous education and learning opportunities.
Company
Applied Systems
Applied Systems is a digital insurance agency that provides software for agency management systems.
1001-5000 employees
H1B Sponsorship
Applied Systems has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (9)
2023 (3)
2022 (5)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
CapitalGStone Point Capital
2018-10-16Series Unknown
2017-09-11Private Equity
2013-11-26Acquired
Leadership Team
Taylor Rhodes
CEO
Recent News
2025-12-17
2025-12-04
Company data provided by crunchbase