Senior Data Governance & SQL Server Optimization ConsultantApplied Technology Services • Baltimore, MD, United States

No longer accepting applications

Senior Data Governance & SQL Server Optimization Consultant

Applied Technology Services • Baltimore, MD, United States

20 days ago

Job type

Full-time

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

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.

Database Optimization Implementation

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.

Documentation & Knowledge Transfer

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.

Required Qualifications

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 Qualifications

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.

Full-Time Employee Benefits :

Competitive compensation

Health benefits including Medical, Dental and Vision

Vacation and Personal Days

401K

Employee Assistance Plan

Continuous education and learning opportunities.

Create a job alert for this search

Senior Data Governance SQL Server Optimization Consultant • Baltimore, MD, United States

Similar jobs

Senior Solutions Consultant – eDiscovery Managed Services

Contact Discovery Services LLC • Baltimore, MD, US

Full-time

Quick Apply

Senior Solutions Consultant – eDiscovery Managed Services Contact Discovery Services - Washington, DC Location : .Remote Start Date : Negotiable Contact Discovery Services, a leading eDiscovery ...Show more

Last updated: 30+ days ago

Senior Data Integration Developer

University of Maryland Medical System • Linthicum Heights, MD, US

Full-time

The University of Maryland Medical System (UMMS) is an academic private health system, focused on delivering compassionate, high quality care and putting discovery and innovation into practice at t...Show more

Last updated: 9 days ago • Promoted

Mid / Senior Cloud Engineer with a Data focus

Belay Technologies • Annapolis Junction, MD, US

Full-time

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

Last updated: 30+ days ago • Promoted

Senior Database Administrator / Engineer - Exadata

GliaCell Technologies • Annapolis Junction, MD, MD, US

Full-time

Quick Apply

Are you a Senior Database Administrator / 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?....Show more

Last updated: 30+ days ago

Oracle Purchasing Consultant

Openkyber • MD, United States

Permanent

Quick Apply

We are seeking to hire an Oracle EBS Financials Support Analyst to join our team working on a new multi-year award we have within a large Federal Gov&...Show more

Last updated: 6 days ago

Senior Consultant - AWS Cloud

Trilagen • MD, US

Remote

Full-time

Quick Apply

Trilagen is looking for a skilled and innovative Senior Consultant with a focus on AWS Cloud to join our expert team.In this role, you will be responsible for designing, implementing, and optimizin...Show more

Last updated: 30+ days ago

Director, Lakehouse Data Architecture & Governance

Crawford Services, Inc. • MD, United States

Full-time

A leading service provider in Maryland is seeking a Director of Data Architecture to oversee the design and implementation of Databricks Lakehouse architecture. The successful candidate will be resp...Show more

Last updated: 2 days ago • Promoted

Database Administration - TS / SCI with Full Scope Poly

Nimori Talent Solutions, LLC • Fort Meade, MD, US

Full-time

ACTIVE TS / SCI with Full Scope Polygraph (Required).This role focuses on maintaining.The Database Administrator will support the. Database Engineers and System Administrators to deliver secure, relia...Show more

Last updated: 20 days ago • Promoted

ME00348-Senior Database Administrator

Momentum Engineering • Fort Meade, Maryland, United States, 20755

Full-time

Woman-Owned Small Business (WOSB), fosters an employee-centric culture.Our strength lies in our people.With a high percentage of employees holding advanced degrees in engineering, computer science,...Show more

Last updated: 30+ days ago

Infor ERP Consultant

Wall Street Consulting Services LLC • MD, United States

Full-time

Quick Apply

Job Title : Senior Infor Specialist / SME Location : Hanover ,MD Job Type : Long term The resource is...Show more

Last updated: 4 days ago

Senior Cloud Data Architect : Snowflake & AWS Lead

T. Rowe Price • Baltimore, MD, United States

Full-time

A leading global asset management firm is seeking a seasoned professional to lead the design and architecture of data solutions. This role requires 5+ years of experience, expertise in Snowflake and...Show more

Last updated: 9 days ago • Promoted

Senior Manager, Channel Performance & Analytics

Xfinity • Baltimore, MD, United States

Full-time

A major telecommunications company in Maryland seeks a highly analytical professional to support performance optimization across channels. This role involves conducting Channel Business Reviews, lev...Show more

Last updated: 2 days ago • Promoted

Sr. Data Platform Engineer

Real Time Medical Systems • Linthicum Heights, MD, US

Full-time

Quick Apply

Data Platform Engineer This is a fully remote role.Job purpose summary Real Time’s suite of Interventional Analytics solutions enables post-acute facilities to seamlessly collaborate with the...Show more

Last updated: 30+ days ago

Cloud Computing Systems Integration and Test Engineer

Global Enterprise Services, LLC • Fort Meade, MD, US

Temporary

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

Last updated: 30+ days ago • Promoted

SAP CPQ Senior Consultant

Deloitte • Baltimore, MD, US

Full-time

Our Deloitte Customer team empowers organizations to build deeper relationships with customers through innovative strategies, advanced analytics, Generative AI, transformative technologies, and cre...Show more

Last updated: 19 hours ago • Promoted • New!

Data Management Software Developer (NH-4)

Legato, Llc • Linthicum, Maryland, United States

Full-time

Legato, LLC recruiters (Staffing@legatocorp.Data Management Software Developer .A Data Management Software Developer that will design software tools and subsystems to support software reuse and dom...Show more

Last updated: 30+ days ago • Promoted

Senior Database Engineer

ClearEdge • Annapolis Junction, MD, US

Full-time

Join ClearEdge and be part of a mission-focused team solving some of the DoD’s most complex technical challenges.Every day, ClearEdge supports government and industry customers by delivering ...Show more

Last updated: 30+ days ago • Promoted

Senior Clinical Database Designer

PAREXEL • Baltimore, MD, United States

Full-time

When our values align, there's no limit to what we can achieve.At Parexel, we all share the same goal - to improve the world's health. From clinical trials to regulatory, consulting, and market acce...Show more

Last updated: 2 days ago • Promoted