Talent.com
Senior Data Governance & SQL Server Optimization Consultant
Senior Data Governance & SQL Server Optimization ConsultantApplied Technology Services • Baltimore, Maryland, USA
[error_messages.no_longer_accepting]
Senior Data Governance & SQL Server Optimization Consultant

Senior Data Governance & SQL Server Optimization Consultant

Applied Technology Services • Baltimore, Maryland, USA
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.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 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 spBlitz 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.

    • Required Experience :

    Senior IC

    Key Skills

    Anti Money Laundering,Consultancy,Administration Support,Fire Alarm,Document Management,AV

    Employment Type : Contract

    Experience : years

    Vacancy : 1

    [job_alerts.create_a_job]

    Data Governance • Baltimore, Maryland, USA

    [internal_linking.similar_jobs]
    SQL Database Administrator (DBA)

    SQL Database Administrator (DBA)

    Leidos Inc • Odenton, MD, United States
    [job_card.full_time]
    Are you ready to make an impact and join a creative, forward-thinking team? We're looking for innovators and forward-thinkers to help us do great things. The Digital Modernization Sector in Leidos i...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    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]
    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 Information Assurance (IA) Analyst.

    Senior Information Assurance (IA) Analyst.

    CompQsoft • Fort George G Meade, MD, United States
    [job_card.full_time]
    Title : Senior Information Assurance (IA) Analyst.Clearance required : Secret Clearance.Certification required by project : IAT Level 2. Examine internal IT controls, evaluate the design and operatio...[show_more]
    [last_updated.last_updated_30] • [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]
    Mid-Level SQL Database Engineer

    Mid-Level SQL Database Engineer

    Synergy Ecp • Annapolis Junction, Maryland, United States, 20701
    [job_card.full_time]
    Mid-Level SQL Database Engineer.Founded in 2007 and headquartered in Columbia, Maryland, Synergy ECP is a leading provider of cybersecurity, software and systems engineering and IT services to the ...[show_more]
    [last_updated.last_updated_30]
    OneDrive Storage Engineer

    OneDrive Storage Engineer

    Independent Software • Annapolis Junction, MD, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    As a Senior Storage Engineer with expertise in NetApp solutions, you will focus on leading the migration to Microsoft 365 (M365) and OneDrive and managing both cloud-based and on-premises global Ne...[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]
    Database Engineer

    Database Engineer

    Pointer Technologies • Annapolis Junction, MD, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Pointer Technologies is seeking a highly skilled and motivated Database Engineer to design, develop, and maintain scalable and efficient database solutions. In this role, you will be responsible for...[show_more]
    [last_updated.last_updated_30]
    AI Consulting Senior Manager

    AI Consulting Senior Manager

    EisnerAmper • Owings Mills, MD, United States
    [job_card.full_time]
    At EisnerAmper, we look for individuals who welcome new ideas, encourage innovation, and are eager to make an impact.Whether you're starting out in your career or taking your next step as a seasone...[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]
    Public Cloud Specialist (RapidScale)

    Public Cloud Specialist (RapidScale)

    Cox Communications • Baltimore, MD, US
    [job_card.full_time]
    At RapidScale, exceptional technology is powered by exceptional people.We deliver secure, reliable managed and advisory services across private, public, and hybrid clouds, helping organizations inn...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Senior Server-Side Engineer

    Senior Server-Side Engineer

    Openkyber • MD, United States
    [job_card.temporary]
    [filters_job_card.quick_apply]
    Job Title : GIS Application Developer Location : Towson, MD Duration : 12+ months contract Scope of Work - Background : ...[show_more]
    [last_updated.last_updated_variable_hours]
    Oracle Application Developer(Apps Cloud)

    Oracle Application Developer(Apps Cloud)

    Office of The Chief Financial Officer • Maryland, MD, United States
    [job_card.full_time]
    Government of the District of Columbia.Office of the Chief Financial Officer (OCFO).Hybrid - Location Washington DC.The Office of the Chief Financial Officer (OCFO) whose mission is to enhance the ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data and Enterprise Reporting Administrator EPIC

    Data and Enterprise Reporting Administrator EPIC

    Greater Baltimore Medical Center (GBMC) • Towson, MD, United States
    [job_card.full_time]
    Under general supervision of Enterprise Business Intelligence and Analytics Manager, evaluates, designs and maintains existing or proposed systems to structure, access, and maintain relational and...[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]
    Oracle Database Engineer

    Oracle Database Engineer

    Dezign Concepts LLC • WMA, MD, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    BP-138-01 NSA Top Secret Clearance Required Only those with existing NSA Top Secret Clearance with Polygraph will be considered (salary is commensurate with education and experience) Or...[show_more]
    [last_updated.last_updated_30]