Senior Administrator - Snowflake & SQL

• Posted 3 hours ago • Updated 25 minutes ago
Full Time
depending on experience
Company Branding Image
Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

  • Performance Management
  • Project Management
  • Preventive Maintenance
  • Reporting
  • Database
  • High Availability
  • Scalability
  • Health Care
  • Provisioning
  • Replication
  • Lifecycle Management
  • Operational Excellence
  • Incident Management
  • Root Cause Analysis
  • RPO
  • Failover
  • Testing
  • Recovery
  • Cost Management
  • Clustering
  • Storage
  • Warehouse
  • Analytics
  • Access Control
  • RBAC
  • Auditing
  • Data Security
  • Data Integration
  • Apache Helix
  • Data Engineering
  • Data Loading
  • Cloud Storage
  • Use Cases
  • Artificial Intelligence
  • Machine Learning (ML)
  • Business Continuity Planning
  • Microsoft SQL Server
  • SQL
  • Optimization
  • Performance Tuning
  • Regulatory Compliance
  • Data Governance
  • Amazon Web Services
  • Cloud Computing
  • Analytical Skill
  • Snow Flake Schema
  • Computer Science
  • Information Systems
  • Database Administration
  • Epic
  • DevOps
  • Facilitation
  • Exceed
  • FOCUS
  • Management
  • Presentations
  • Salesforce.com
  • DICE
  • MIT
  • Military
  • Collaboration
  • Partnership
  • Law

Summary

City/State:
Yonkers, New York
Grant Funded:
No
Department:
D&A - Data & Analytics
Work Shift:
Day
Work Days:
MON-FRI
Scheduled Hours:
8:30 AM-5 PM
Scheduled Daily Hours:
7.5 HOURS
Pay Range:
$144,000.00-$180,000.00

Montefiore is ranked among the top hospitals nationally and regionally by U.S. News & World Report. For more than 100 years we have been innovating new treatments, procedures, and approaches to patient care, producing stellar outcomes and raising the bar for academic medical centers in the region and around the world.

Our work to improve health outcomes in underserved communities is unparalleled in the United States. Our workforce is among the most diverse in the US: Montefiore associates speak 60+ languages. As Montefiore has built paths to deliver lifesaving health outcomes to underserved communities, we are looking to the future of being a data driven organization and tech-enabled care delivery to create better experiences for patients, providers, and operations teams.

Montefiore is actively investing in its data & analytics driven solutions as a new system-level priority, and we are seeking data experts who are excited to create a tangible impact with the healthcare system. We are seeking an experienced Snowflake Database Administrator (DBA) with strong expertise in Snowflake to manage, optimize, and support our enterprise data platforms. The ideal candidate will be responsible for ensuring high availability, performance, security, and scalability of the Snowflake and AWS based SQL Server data platforms, with a strong focus on Snowflake advanced administration. This role will be responsible for administrating Montefiore's AI-ready data Lakehouse in Snowflake that houses complex data solutions supporting Montefiore's business functions. This role is also critical to scaling our data and insights capabilities, empowering teams with actionable insights, and supporting our mission to improve Patient healthcare.

Responsibilities include:

Snowflake Platform Administration

Administer and manage Snowflake enterprise environments (multi-account, multiregion).

Configure and manage virtual warehouses, resource monitors, roles, users, and access controls.

Perform environment provisioning, cloning, replication, and lifecycle management.

Monitor upgrades, feature enablement, and account-level configurations.

Operational Excellence & Reliability

Ensure 24/7 operational readiness and platform stability.

Implement monitoring, alerting, and observability for performance, storage, and compute usage.

Establish operational runbooks, SOPs, and incident response processes. Partner with Montefiore AWS cloud foundations team and data engineering teams to ensure platform SLAs and reliability targets are met.

Support root cause analysis and incident resolution for platform-related issues.

Define RTO/RPO objectives and ensure compliance with enterprise resiliency standards.

Conduct periodic failover testing and recovery drills.

Security, Performance Optimization & Cost Management

Monitor and tune query performance, warehouse sizing, clustering, and data organization.

Optimize storage strategies including micro-partitioning and pruning.

Drive cost optimization through warehouse right-sizing, auto-suspend/resume strategies, and usage analytics.

Provide usage and performance reports as needed Implement and manage role-based access control (RBAC) and fine-grained access policies.

Support audit, compliance, and regulatory requirements.

Collaborate with security teams to maintain enterprise data protection standards.

Stay current with Snowflake releases and emerging capabilities.

Recommend improvements to enhance platform reliability, security, and performance.

Helix Snowflake Lakehouse Data Integration & Ecosystem Support

Support data ingestion pipelines across disparate internal and external data sources primarily Epic Cogito stack.

Collaborate with the Helix Data Engineering team to ensure optimal data loading and transformation patterns.

Support external tables and integration with AWS cloud storage.

Support enablement and operationalization of Snowflake Cortex AI capabilities.

Ensure data readiness, governance, and security for AI-driven use cases.

Optimize compute resources to support AI workloads.

Partner with AI/ML teams to maintain a high-performance platform for model development and inference. Qualifications:

Required Qualifications include:

12+ years of experience in database administration or data platform operations

4+ years of hands-on Snowflake administration experience in enterprise environments.

Proven experience managing production-grade, highly available data platforms.

Experience designing and implementing DR and business continuity strategies. Solid experience administering Microsoft SQL Server.

Strong knowledge of SQL, query optimization, and performance tuning.

Experience with security, compliance, and data governance best practices.

Experience with AWS cloud platform is a plus

Strong troubleshooting and analytical skills

Ability to work in a fast-paced, mission-critical environment.

Snowflake Advanced Administration Certification

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience).

Preferred Qualifications:

Experience in health systems database administration

Experience in Epic Cogito stack administration

Experience with Infrastructure-as-Code and DevOps practices.

Competencies:

Ability to think strategically and drive structured execution

Structured, linear thinker that can conduct business outcome diagnostics and identify highest value business opportunities

Strong facilitation skills to help business leaders identify their most important business questions

Exhibits excellent judgment, especially when working with ambiguity.

Sets stretch goals and works to exceed goals with a focus for results.

Has the innate ability to gain the confidence of and build strong relationships with executives, peers, management and subordinates alike.

Excellent business-facing presentation skill

#SF-DICE-MIT

#LI-SC1

Montefiore Health System, Inc. is an equal employment opportunity employer. Montefiore Health System, Inc. will recruit, hire, train, transfer, promote, layoff and discharge associates in all job classifications without regard to their race, color, religion, creed, national origin, alienage or citizenship status, age, gender, actual or presumed disability, history of disability, sexual orientation, gender identity, gender expression, genetic predisposition or carrier status, pregnancy, military status, marital status, or partnership status, or any other characteristic protected by law.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10122138
  • Position Id: JR229572
  • Posted 3 hours ago

Company Info

About Montefiore Health System Inc

Montefiore’s IT professionals use their talents to create and support technologies that save people’s lives, and enhance patient outcomes, and improve enhance quality of life for people in the communities we serve. Yes- we are big – over 30,000 employees - but we are centered in values that start with our communities.

Our IT teams work on the technologies that allow Montefiore’s Children’s Hospital to rank among the nation’s best 15 years in a row. Every facet of Montefiore has reason to be proud. Montefiore’s survival rate for liver transplants is among the best in the country. Cardiology at Montefiore pioneered bloodless heart transplantation and innovative techniques to treat heart illnesses with non-invasive procedures.  US News and World Reports named Montefiore as a leader in orthopedics, urology, pulmonology/lung surgery, and GI surgery, to name a few. Not to mention our school health program that provides integrated health services including behavioral health and dental services to thousands of NY kids who need us.

Why should you care about this?

The network engineers, systems engineers, applications analysts, database developers, project managers, and countless other IT people who are part of Montefiore create an infrastructure that allows our clinicians to perform the lifesaving and life-enhancing work we do every day. Their efforts make it possible for our Albert Einstein College of Medicine to participate in groundbreaking research and share clinical solutions with academic medical centers across the globe. Their skills support strong relationships with government, corporate, and community organizations that help us get paid for the work we do.

By the way- our people work on a diverse platform that includes AWS, Azure, Zscaler, Informatica, Epic, Java, .NET, Oracle, Cisco, Infor, JAMF, VMware, and a nice long list of other tools.

How good would it feel to know that your talents are going to improve things for people in the communities where we live, while working in a respectful, diverse environment? 

Our workplace is routinely recognized at a national level for diversity, including for LGBTQ individuals and people of all ages.

Montefiore's IT employees have access to a generous benefits package. For starters: what would you do with 37 paid days off per year?

Ask a recruiter about our opportunities, career development programs, and our employee benefits – you won’t be disappointed.

About_Company_OneAbout_Company_Two
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Yonkers, New York

Today

Full-time

depending on experience

Yonkers, New York

Today

Full-time

depending on experience

Yonkers, New York

Today

Full-time

depending on experience

Yonkers, New York

Today

Full-time

depending on experience

Search all similar jobs