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
10 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
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.
We guarantee 15-25 hours per week with an hourly pay of bet...Show more
We are on several winning teams.Come join us! Our work environment is limitless, you matter to us, your great work will be recognized, and there are many opportunities for advancement.Davis Unlimit...Show more
At PwC, our people in operations consulting specialise in providing consulting services on optimising operational efficiency and effectiveness.
These individuals analyse client needs, develop operat...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
Why Become a Shopper with DoorDash?.Turn your shopping skills into extra income.Whether youre helping someone stock up on groceries or delivering a last-minute convenience order, as a Shopper you u...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
Rowe Price, we identify and actively invest in opportunities to help people thrive in an evolving world.As a premier global asset management organization with more than 85 years of experience, we p...Show more
Unlock the secrets of intelligence with MANTECH! Join a dynamic team at the forefront of national security, providing advanced solutions to government intelligence agencies.Since 1968, we’ve been s...Show more
A company is looking for a Data Governance Consultant.Key Responsibilities Drive the planning and execution of Data / BI governance initiatives and ensure timely completion of governance activities...Show more
Senior Lead Data Engineer (Snowflake, Databricks, Apache Iceberg, Spark SQL workload optimizations) Do you love building and pioneering in the technology space? Do you enjoy solving complex busine...Show more
Rowe Price, we identify and actively invest in opportunities to help people thrive in an evolving world.As a premier global asset management organization with more than 85 years of experience, we p...Show more
At Panera, our people come first.If you're looking for a place where you can grow, feel supported, be yourself, enjoy great perks, and have a little fun along the way—you're in the ri...Show more
Doctor of Medicine | Cardiology - General / Other Location : Maryland Employer : Weatherby Healthcare Pay : Competitive weekly pay (inquire for details) Start Date : ASAP About the Position Weatherby can...Show more
Must have 2+ years of experience.This contract pays approximately $13,271 / month gross.Guaranteed Pay : Never worry about canceled shifts.
Premium Overtime : 2x hourly rate for overtime on travel assig...Show more
ANGARAI is a professional management consulting firm based in College Park, MD.We work with state, federal, and local governments, delivering project management, IT solutions, and business transfor...Show more
Senior Consultant is an expert in data analysis, engineering, and science.This rolewill possess the necessary skills at an advanced level of proficiency to drive organizational transformation by ar...Show more
Senior Systems Administrator in our.Intelligence Sector's (NSS) Cyber & Analytics Business Area (CABA).Our talented team is at the forefront in Security Engineering, Computer Network Operations (CN...Show more
This position will be fully remote and can be hired anywhere in the continental U.We are seeking a Senior Consultant to join our Secure Cloud Transformation practice.
As a Senior Consultant, you wil...Show more
Hiring Now - Work from Home - No Experience
OCPA • Shrewsbury township, Pennsylvania, us
Remote
Part-time +1
Last updated: 30+ days ago • Promoted
Database Management Specialist 2
DUIT • Glen Burnie, MD, United States
Full-time
Last updated: 7 days ago • Promoted
Epic Application Analyst Consultant, Senior Associate
PwC • Baltimore, MD, United States
Full-time
Last updated: 7 days ago • Promoted
Senior Data Manager
Oceaneering International, Inc. • Hanover, MD, United States
Full-time
Last updated: 30+ days ago • Promoted
DoorDash Shopper - No Experience Needed
DoorDash • Parkton, MD, US
Full-time +1
Last updated: less than 1 hour ago • Promoted • New!
Senior Data Governance & SQL Server Optimization Consultant
Applied Technology Services • Baltimore, MD, United States
Full-time
Last updated: 7 days ago • Promoted
Sr. Manager- Database Platforms
T. Rowe Price • Owings Mills, MD, United States
Full-time
Last updated: 2 days ago • Promoted
Senior Cloud System Administrator
ManTech International Corporation • Hanover, MD, United States
Full-time
Last updated: 7 days ago • Promoted
Data Governance Consultant
VirtualVocations • Baltimore, Maryland, United States
Full-time
Last updated: 5 days ago • Promoted
Senior Lead Data Engineer (Snowflake, Databricks, Apache Iceberg, Spark SQL workload optimizations)
Capital One • Arnold, MD, US
Full-time +1
Last updated: 4 hours ago • Promoted • New!
Sr. Manager- Database Platforms
T. Rowe Price Group, Inc. • Owings Mills, MD, United States
Full-time
Last updated: 2 days ago • Promoted
Salad and Sandwich Maker
Panera Bread • Shrewsbury, PA, US
Full-time
Last updated: 19 hours ago • Promoted • New!
Locum Physician (MD / DO) - General / Other Cardiology
Weatherby Healthcare • Maryland Line, MD, United States
Full-time
Last updated: 3 days ago • Promoted
Travel CT Tech Job in Glen Rock, PA - $13,271 per Month (2 Years Experience Needed)
Vetted Health • Glen Rock, PA, United States
Full-time
Last updated: 2 days ago • Promoted
Database Management Specialist
ANGARAI • Catonsville, MD, United States
Full-time
Last updated: 2 days ago • Promoted
Sr. Consultant, Data & Analytics
Fearless Solutions • Baltimore, MD, United States
Full-time +1
Last updated: 10 hours ago • Promoted • New!
Senior Systems Administrator 10k sign on bonus
Leidos Inc • Annapolis Junction, MD, United States
Full-time
Last updated: 30+ days ago • Promoted
Sr. Consultant - Secure Cloud Transformation (AWS / Azure) | Remote, USA
Optiv • Baltimore, MD, United States
Remote
Full-time
Last updated: 7 days ago • Promoted