Senior Data Governance & SQL Server Optimization ConsultantApplied Technology Services • Baltimore, MD, US
Senior Data Governance & SQL Server Optimization Consultant
Applied Technology Services • Baltimore, MD, US
11 days ago
Job type
- Full-time
Job descriptionClassify 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. 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. 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. Competitive compensation Health benefits including Medical, Dental and Vision Vacation and Personal Days 401K Employee Assistance Plan Continuous education and learning opportunities.
Job Description
Job Description
Can be a W2 or 1099 opportunity.
ATS requires a Senior Consultant to lead the Data Governance, Data Classification, Archiving Assessment, and SQL Server Database Optimization effort for a NextGen EHR environment. The consultant will conduct discovery, assess structured and unstructured data, develop governance and retention strategies, identify archivable data, and execute comprehensive SQL Server performance optimization and maintenance plan deployment.
Key Duties & Responsibilities
Discovery & Assessment
- 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.
Data Governance, Classification & Archiving Strategy
Database Optimization Implementation
Documentation & Knowledge Transfer
Required Qualifications
Preferred Qualifications
Full-Time Employee Benefits :
Powered by JazzHR
7oM4I0UQpu
Create a job alert for this search
Data Governance • Baltimore, MD, US
Similar jobs
Belay Technologies has been voted Baltimore Business Journal's (BBJ) Best Places to Work 2019, runner up in 2020 and a finalist in 2021!.
Belay Technologies is seeking a Senior Cloud Engineer to...Show more
At OmegaCor, our purpose is to empower our clients, staff, and community to achieve excellence.A key element of fulfilling this mission is providing high-value IT consulting services that align tec...Show more
Azure DBA / Senior Data Engineer (Remote).Azure DBA / Senior Data Engineer.This role focuses on building, administering, and optimizing secure, scalable data platforms using.Microsoft Azure, Power ...Show more
We are seeking a Senior Cloud & Kubernetes Engineer to support, optimize, and secure self-managed Kubernetes environments running on SIPRNet across VMware and Azure, hosted on RHEL servers with...Show more
Take the next steps to your professional success as Solerity is a recognized leader in providing Information Technology, Engineering Services, Program Management and Consulting Services to the U.S ...Show more
Athenix Solutions Group is looking for multiple Cloud System Architects for a large program in the Annapolis Junction, MD area.
The Cloud System Architects will provide support for implementation, t...Show more
Oceaneering Technologies (OTECH) develops, manufactures, and operates customized marine systems, shipboard equipment, subsea vehicles, and engineered solutions for commercial and U.Oceaneering Aero...Show more
Can be a W2 or 1099 opportunity.ATS requires a Senior Consultant to lead the Data Governance, Data Classification, Archiving Assessment, and SQL Server Database Optimization effort for a NextGen EH...Show more
A company is looking for a Data Governance Consultant to support enterprise data governance initiatives.Key Responsibilities Lead the planning and delivery of data governance initiatives, ensurin...Show more
This position requires full-time onsite work in Fort Meade, MD.Experience with cloud computing platforms, including AWS, Azure, GCP, and IBM Cloud.
Experience with cloud-based infrastructure, includ...Show more
Are you a Senior Database Engineer who is ready for a new challenge that will launch your career to the next level?.Tired of being treated like a company drone?.Tired of promise...Show more A company is looking for a Senior or Lead Data Governance Steward.Key Responsibilities Prioritize the accuracy, availability, accessibility, and protection of corporate data Promote the value of...Show more 
The Cloud Computing Systems Integration and Test Engineer is responsible for working within a fast paced, Agile team to support testing new innovation deployments.
This position will be expected to ...Show more
Southern New Hampshire University is a team of innovators.Individuals who believe in progress with purpose.Since 1932, our people-centered strategy has defined us - and helped us grow a team that n...Show more
Fort Meade, MD (Onsite / Hybrid).Work with teams to bring continuous improvement to DevSecOps processes and tools.Ensure work product meets user acceptance criteria.
Manage self-directed assignments.M...Show more
Cloud Engineers – Evergreen.Meade / Hybrid & On Site .Quotient is a leading provider of customized information technology solutions, specializing in systems integration, full-stack s...Show more
You will act as a CNO cloud exploiter for up-and-coming projects where you will analyze, design, develop, prototype, modify, and integrate solutions to provide mission-centric results.You will work...Show more
Join ClearEdge and be a part of a dynamic team that solves some of the DoD’s most complex technical challenges.Every day, ClearEdge empowers our customers in government and industry with inno...Show more
Mid / Senior Cloud Engineer with a Data focus
Belay Technologies • Annapolis Junction, MD, US
Full-time
Last updated: 30+ days ago • Promoted
Cloud Engineer - Architect
OmegaCor Technologies • Millersville, MD, US
Full-time
Last updated: 30+ days ago • Promoted
Azure DBA / Senior Data Engineer
Arch Systems • Baltimore, MD, US
Full-time
Last updated: 5 hours ago • Promoted • New!
Senior Cloud and Kubernetes Engineer
Trillion Technology Solutions • Annapolis Junction, MD, US
Full-time
Last updated: 30+ days ago • Promoted
Systems / Cloud Architect (TS / SCI with Poly)
Solerity • Savage, MD, US
Full-time
Last updated: 30+ days ago • Promoted
Cloud System Architect
Athenix Solutions Group • Annapolis Junction, MD, US
Full-time
Last updated: 30+ days ago • Promoted
Senior Data Manager
Oceaneering International, Inc. • Hanover, MD, United States
Full-time
Last updated: 30+ days ago • Promoted
Senior Data Governance & SQL Server Optimization Consultant
Applied Technology Services • Baltimore, MD, United States
Full-time
Last updated: 8 days ago • Promoted
Data Governance Consultant
VirtualVocations • Baltimore, Maryland, United States
Full-time
Last updated: 6 days ago • Promoted
Software / Cloud Architect
Dark Wolf Solutions • Fort Meade, MD, US
Full-time
Last updated: 30+ days ago • Promoted
Senior Database Engineer
GliaCell Technologies • Linthicum Heights, MD, US
Full-time
Last updated: 30+ days ago • Promoted
Senior Data Governance Steward
VirtualVocations • Baltimore, Maryland, United States
Full-time
Last updated: 10 hours ago • Promoted • New!
Cloud Computing Systems Integration and Test Engineer
Global Enterprise Services, LLC • Fort Meade, MD, US
Temporary
Last updated: 30+ days ago • Promoted
Senior System Analyst
Southern New Hampshire University • Baltimore, MD, United States
Full-time
Last updated: 7 days ago • Promoted
Cloud Engineer
Sivad Consulting • Fort Meade, MD, US
Full-time
Last updated: 13 days ago • Promoted
Cloud Engineers - Evergreen
Quotient • Annapolis Junction, MD, US
Full-time
Last updated: 30+ days ago • Promoted
CNO Engineer (Cloud Exploitation), BS+12 yrs or MS+10 yrs
Link, LLC • Fort Meade, MD, US
Full-time
Last updated: 30+ days ago • Promoted
Senior Database Engineer
ClearEdge • Annapolis Junction, MD, US
Full-time
Last updated: 30+ days ago • Promoted