Senior Data Governance & SQL Server Optimization ConsultantApplied Technology Services • Baltimore, Maryland, USA
[error_messages.no_longer_accepting]
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]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. 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 spBlitz 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.
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 :
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]
We take Work-Life-Balance seriously!.This Jobot Job is hosted by : Madeline Lazarus.Are you a fit? Easy Apply now by clicking the "Apply Now" button and sending us your resume.Salary : $100,000 - $15...[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]
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]
Do you find yourself constantly looking for more and better information? Do you want a job where you can use your knowledge and research skills to improve national security? Never has the role of a...[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]
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]
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]
A company is looking for a Data Governance Consultant to support enterprise data governance initiatives.Key Responsibilities Lead the planning and delivery of data governance initiatives, ensurin...[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]
Company Name : Blue Dot Heating, Air Conditioning Overview : .Part-time and full-time opportunities available.Join Blue Dot, the nation's largest provider of residential HVAC, plumbing, and electrical...[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]
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]
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]
This position is for individuals who want to develop a side income stream while still working full time.You will test different small-scale remote opportunities, learn what works, and grow what pro...[show_more]
Senior SIGDEV Analyst - TS / SCI-FSP
Jobot • Annapolis Junction, MD, US
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Database Management Specialist 2
DUIT • Glen Burnie, MD, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Epic Application Analyst Consultant, Senior Associate
PwC • Baltimore, MD, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
DoorDash Shopper - No Experience Needed
DoorDash • Parkton, MD, US
[job_card.full_time] +1
[last_updated.last_updated_1_day] • [promoted]
SIGINT Analyst
Booz Allen Hamilton • Fort Meade, MD, United States
[job_card.full_time] +1
[last_updated.last_updated_variable_days] • [promoted]
Senior Data Governance & SQL Server Optimization Consultant
Applied Technology Services • Baltimore, MD, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Sr. Manager- Database Platforms
T. Rowe Price • Owings Mills, MD, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Data Analytics Engineer
CACI International • Linthicum Heights, MD, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior SigDev Analyst
Fuse Engineering • Fort Meade, MD, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Data Governance Consultant
VirtualVocations • Baltimore, Maryland, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Sr. Manager- Database Platforms
T. Rowe Price Group, Inc. • Owings Mills, MD, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
In-Store Product Ambassador - New Freedom
Blue Dot Heating, Air Conditioning • New Freedom, PA, US
[job_card.full_time] +1
[last_updated.last_updated_variable_days] • [promoted]
Senior Data Manager
Oceaneering • Hanover, MD, United States
[job_card.full_time]
[last_updated.last_updated_1_day] • [promoted]
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]
[last_updated.last_updated_variable_days] • [promoted]
Database Management Specialist
ANGARAI • Catonsville, MD, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Sr. Consultant, Data & Analytics
Fearless Solutions • Baltimore, MD, United States
[job_card.full_time] +1
[last_updated.last_updated_variable_days] • [promoted]
Data Analytics Engineer
Syntricate Technologies • Towson, MD, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Remote Side Hustle Developer
Finance Buzz • Monkton, Maryland, US
[filters.remote]
[job_card.full_time] +1
[last_updated.last_updated_1_day] • [promoted]