Senior Data Governance

6 days ago

Baltimore, MD, United States Applied Technology Services 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 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

  • Director, Data and AI Governance

    7 days ago

    Baltimore, MD, United States Breakthru Beverage Group Full time

    Time Type: Full time Remote Type: Job Family Group: Information Technology Job Description Summary: Breakthru Beverage Group (BBG) is seeking a strategic and hands-on Director, Data and AI Governance to define and lead the execution of our enterprise data governance strategy. In this pivotal role, you will establish the frameworks, policies, and standards...

  • Senior Government Accounting Manager

    1 day ago

    Baltimore, MD, United States GE Aerospace Full time

    Job Description Summary The Senior Government Accounting Manager is responsible for compliantly developing Forward Pricing Rate Proposals (FPRPs) and the annual Incurred Cost Submission (ICS) for the GE Aerospace Defense & Systems organization. This role will partner with functional organization leadership to enable the business to have compliant operating...

  • Senior Data Scientist

    1 week ago

    Baltimore, MD, United States GliaCell Technologies LLC Full time

    ***An active or rein-statable TS/SCI with Polygraph security clearance is REQUIRED. Please do not apply if you currently do not possess this level of clearance.*** Are you a Senior Data Scientist who is ready for a new challenge that will launch your career to the next level? Tired of being treated like a company drone? Tired of promised adventures during...

  • Senior Data Scientist

    2 weeks ago

    Baltimore, MD, United States GliaCell Technologies LLC Full time

    ***An active or rein-statable TS/SCI with Polygraph security clearance is REQUIRED. Please do not apply if you currently do not possess this level of clearance.*** Are you a Senior Data Scientist who is ready for a new challenge that will launch your career to the next level? Tired of being treated like a company drone? Tired of promised adventures during...

  • Senior Data Scientist

    7 days ago

    Baltimore, MD, United States GliaCell Technologies LLC Full time

    ***An active or rein-statable TS/SCI with Polygraph security clearance is REQUIRED. Please do not apply if you currently do not possess this level of clearance.*** Are you a Senior Data Scientist who is ready for a new challenge that will launch your career to the next level? Tired of being treated like a company drone? Tired of promised adventures during...

  • Senior Software Engineer, Data Platform

    1 day ago

    Baltimore, MD, United States Circle Full time

    Senior Software Engineer, Data Platform Join to apply for the Senior Software Engineer, Data Platform role at Circle. Circle is a financial technology company at the epicenter of the emerging internet of money, where value can finally travel like other digital data globally, nearly instantly and less expensively than legacy settlement systems. This...

  • Senior Business Analyst

    1 week ago

    Baltimore, MD, United States Trigyn Technologies Full time

    Immediate long-term contract opportunity for Senior Business Analyst with direct client in Baltimore, MD. Trigyn's direct client has contract opportunity for Senior Business Analyst in Baltimore, MD (HYBRID). The particulars of the position are as follows. NOTE: Hybrid work (Baltimore, Maryland 21202). Experience working on projects within Public Sector/...

  • Senior Program Portfolio Manager, SVP

    6 days ago

    Baltimore, MD, United States M&T Bank Full time

    Who We Are: Enterprise Transformation Delivery Engaged in the bank's most critical & strategic initiatives, leveraging modern delivery approaches A results-oriented team of 30+ diverse professionals, we provide execution certainty through strong project delivery, business acumen, and change management capabilities. We engage in strategic, enterprise...

  • Senior Project Manager

    5 days ago

    Baltimore, MD, United States USA Jobs Full time

    Senior Project Manager - Data Center North Americas top General Contractor is seeking a Senior Project Manager - Data Center to serve as the on-site manager, responsible for the overall direction, completion, and financial outcome of a large, complex data center construction project. This role will sit primarily on the job site, with occasional travel to the...

  • Senior DevOps Engineer

    2 weeks ago

    Baltimore, MD, United States Trigyn Technologies Full time

    Immediate contract to hire opportunity for Senior DevOps Engineer with direct client in Baltimore, MD. Trigyn's direct client has a contract to hire opportunity (Temp to Perm full time) for a Senior DevOps Engineer in Baltimore, MD (HYBRID). NOTE: Local candidates preferred. Experience with Government systems such as Accela and/or OpenGov is required...