Talent.com
Senior Data Governance & SQL Server Optimization Consultant
Senior Data Governance & SQL Server Optimization ConsultantApplied Technology Services • Baltimore, MD, US
Senior Data Governance & SQL Server Optimization Consultant

Senior Data Governance & SQL Server Optimization Consultant

Applied Technology Services • Baltimore, MD, US
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

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

  • 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.

    • Powered by JazzHR

    7oM4I0UQpu

    [job_alerts.create_a_job]

    Data Governance • Baltimore, MD, US

    [internal_linking.similar_jobs]
    Performance Audit Senior Consultant (Remote)

    Performance Audit Senior Consultant (Remote)

    Blue Cross Blue Shield Association • Baltimore, MD, United States
    [filters.remote]
    [job_card.full_time]
    The role ensure Plans' operations handle customer interactions accurately and promptly, leaving a positive brand impression. Execute audit programs and validate reported results.Present updates and ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Database Management Specialist 2

    Database Management Specialist 2

    DUIT • Glen Burnie, MD, United States
    [job_card.full_time]
    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]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Data Manager

    Senior Data Manager

    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]
    Senior Analyst, Cloud Applications Engineering

    Senior Analyst, Cloud Applications Engineering

    Ciena • Hanover, MD, United States
    [job_card.full_time]
    As the global leader in high-speed connectivity, Ciena is committed to a people-first approach.Our teams enjoy a culture focused on prioritizing a flexible work environment that empowers individual...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Senior Data Governance & SQL Server Optimization Consultant

    Senior Data Governance & SQL Server Optimization Consultant

    Applied Technology Services • Baltimore, MD, United States
    [job_card.full_time]
    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]
    [last_updated.last_updated_variable_days] • [promoted]
    Sr. Manager- Database Platforms

    Sr. Manager- Database Platforms

    T. Rowe Price • Owings Mills, MD, United States
    [job_card.full_time]
    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]
    [last_updated.last_updated_1_day] • [promoted]
    Senior Cloud System Administrator

    Senior Cloud System Administrator

    ManTech International Corporation • Hanover, MD, United States
    [job_card.full_time]
    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]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Governance Consultant

    Data Governance Consultant

    VirtualVocations • Baltimore, Maryland, United States
    [job_card.full_time]
    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]
    [last_updated.last_updated_variable_days] • [promoted]
    Diagnostics Solutions Consultant

    Diagnostics Solutions Consultant

    Zoetis, Inc • Baltimore, MD, United States
    [job_card.full_time]
    The Diagnostics Solutions Consultant (DSC) is a field-based customer facing member of our sales team accountable for selling Zoetis diagnostic instruments, tests and associated products and service...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Sr. Manager- Database Platforms

    Sr. Manager- Database Platforms

    T. Rowe Price Group, Inc. • Owings Mills, MD, United States
    [job_card.full_time]
    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]
    [last_updated.last_updated_1_day] • [promoted]
    Insider Threat Program Database Engineer

    Insider Threat Program Database Engineer

    Leidos • Glenn Dale, MD, US
    [job_card.full_time]
    DHS Insider Threat Program (ITP) under the HEITS Contract.This is a dynamic opportunity to apply your expertise in designing, sustaining, and evolving the database infrastructure that powers one of...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Locum Physician (MD / DO) - General / Other Cardiology

    Locum Physician (MD / DO) - General / Other Cardiology

    Weatherby Healthcare • Maryland Line, MD, United States
    [job_card.full_time]
    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]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel CT Tech Job in Glen Rock, PA - $13,271 per Month (2 Years Experience Needed)

    Travel CT Tech Job in Glen Rock, PA - $13,271 per Month (2 Years Experience Needed)

    Vetted Health • Glen Rock, PA, United States
    [job_card.full_time]
    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]
    [last_updated.last_updated_variable_days] • [promoted]
    Database Management Specialist

    Database Management Specialist

    ANGARAI • Catonsville, MD, United States
    [job_card.full_time]
    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]
    [last_updated.last_updated_1_day] • [promoted]
    Database Administrator

    Database Administrator

    Power3 Solutions and Partnering Companies • Fort Meade, MD, United States
    [job_card.full_time]
    Meade Area, MD • Government / Military.Full-Time | Fully Funded | $140K-$170K.We're seeking detail-oriented, security-cleared. The successful candidate will be responsible for maintaining the integrit...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Oracle CX Cloud Implementation Consultant - Manager

    Oracle CX Cloud Implementation Consultant - Manager

    PwC • Baltimore, MD, United States
    [job_card.full_time]
    At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency.These individuals ana...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Physician / Cardiology - Non Invasive / Maryland / Permanent / Cardiology Non Invasive

    Physician / Cardiology - Non Invasive / Maryland / Permanent / Cardiology Non Invasive

    Hayman Daugherty Associates • Maryland Line, Maryland, US
    [job_card.permanent]
    Noninvasive Cardiology Physician Job Near Washington, DC A private practice near Washington, DC is looking for a BE / BC Noninvasive Cardiologist to join their growing practice.The information below ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Systems Administrator 10k sign on bonus

    Senior Systems Administrator 10k sign on bonus

    Leidos Inc • Annapolis Junction, MD, United States
    [job_card.full_time]
    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]
    [last_updated.last_updated_30] • [promoted]