Talent.com
Senior Data Governance & SQL Server Optimization Consultant
Senior Data Governance & SQL Server Optimization ConsultantMaryland Staffing • Baltimore, MD, United States
[error_messages.no_longer_accepting]
Senior Data Governance & SQL Server Optimization Consultant

Senior Data Governance & SQL Server Optimization Consultant

Maryland Staffing • Baltimore, MD, United States
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Senior Consultant Opportunity

A senior consultant is required 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 :

  • 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 040 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
    • [job_alerts.create_a_job]

    Data Governance • Baltimore, MD, United States

    [internal_linking.similar_jobs]
    Senior Solutions Consultant – eDiscovery Managed Services

    Senior Solutions Consultant – eDiscovery Managed Services

    Contact Discovery Services LLC • Baltimore, MD, US
    [job_card.full_time]
    [filters_job_card.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.last_updated_30]
    Mid / Senior Cloud Engineer with a Data focus

    Mid / Senior Cloud Engineer with a Data focus

    Belay Technologies • Annapolis Junction, MD, US
    [job_card.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.last_updated_30] • [promoted]
    Senior SQL Server Database Administrator

    Senior SQL Server Database Administrator

    VirtualVocations • Baltimore, Maryland, United States
    [job_card.full_time]
    A company is looking for a Senior Database Administrator.Key Responsibilities Design, implement, and administer Microsoft SQL Server environments Develop, optimize, and maintain complex T-SQL co...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Database Administrator / Engineer - Exadata

    Senior Database Administrator / Engineer - Exadata

    GliaCell Technologies • Annapolis Junction, MD, MD, US
    [job_card.full_time]
    [filters_job_card.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.last_updated_30]
    Senior Consultant - AWS Cloud

    Senior Consultant - AWS Cloud

    Trilagen • MD, US
    [filters.remote]
    [job_card.full_time]
    [filters_job_card.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.last_updated_30]
    Senior Data Analytics Engineer

    Senior Data Analytics Engineer

    CACI International • Linthicum Heights, MD, United States
    [job_card.full_time]
    Senior Data Analytics Engineer.Job Category : Information Technology.Minimum Clearance Required to Start : TS / SCI with Polygraph. Percentage of Travel Required : None.CACI is seeking a Senior Data Anal...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior SigDev Analyst

    Senior SigDev Analyst

    Fuse Engineering • Fort Meade, MD, United States
    [job_card.full_time]
    The SIGINT Development (SIGDEV) Analyst provides analytic support to optimize and develop assigned customer accesses.Conduct research and analysis of collection and collateral data to develop targe...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Solutions Analyst I

    Senior Solutions Analyst I

    Oceaneering International, Inc. • Hanover, MD, United States
    [job_card.full_time]
    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]
    [last_updated.last_updated_30] • [promoted]
    ME00348-Senior Database Administrator

    ME00348-Senior Database Administrator

    Momentum Engineering • Fort Meade, Maryland, United States, 20755
    [job_card.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.last_updated_30]
    Senior Cloud Data Architect : Snowflake & AWS Lead

    Senior Cloud Data Architect : Snowflake & AWS Lead

    T. Rowe Price • Baltimore, MD, United States
    [job_card.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.last_updated_variable_days] • [promoted]
    Sr. Consultant, Data & Analytics

    Sr. Consultant, Data & Analytics

    Fearless Solutions • Baltimore, MD, United States
    [job_card.full_time] +1
    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]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Analytics Engineer

    Data Analytics Engineer

    Syntricate Technologies • Towson, MD, United States
    [job_card.full_time]
    Microsoft Power Platforms (PowerBI, Power Automate, Power Apps).Analytical Reporting and Dashboarding.Data Management and Pipelining (ETL). Experience in the Analytical Reporting and Dashboarding.Ex...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Sr. Data Platform Engineer

    Sr. Data Platform Engineer

    Real Time Medical Systems • Linthicum Heights, MD, US
    [job_card.full_time]
    [filters_job_card.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.last_updated_30]
    Cloud Computing Systems Integration and Test Engineer

    Cloud Computing Systems Integration and Test Engineer

    Global Enterprise Services, LLC • Fort Meade, MD, US
    [job_card.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.last_updated_30] • [promoted]
    ADC Engineer I, Non-Relational Database Services

    ADC Engineer I, Non-Relational Database Services

    Amazon • Jessup, MD, United States
    [job_card.full_time]
    Intelligence Community and Defense agencies implement innovative cloud computing solutions and solve unique technical problems?. Would you like to do this using the latest cloud computing technologi...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Database Engineer

    Senior Database Engineer

    ClearEdge • Annapolis Junction, MD, US
    [job_card.full_time]
    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]
    [last_updated.last_updated_30] • [promoted]
    Director, Data Architecture New S01 Field Support

    Director, Data Architecture New S01 Field Support

    Crawford Services, Inc. • MD, United States
    [job_card.full_time]
    Databricks Lakehouse architecture, including bronze / silver / gold layers, dimensional modeling, data governance, and production-grade pipelines. This role ensures that our data is trusted, accessible,...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Sr. Database Admin / Engineer - Exadata

    Sr. Database Admin / Engineer - Exadata

    Quevera LLC • Annapolis Junction, MD, US
    [job_card.full_time]
    Database Admin / Engineer - Exadata.At Quevera, we don’t just offer jobs—we provide opportunities to be part of a dynamic, forward-thinking community that fosters innovation, collaboratio...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]