Senior Administrator - Snowflake & SQL (JR229572)

<strong>To heal, to teach, to discover and to advance the health of the communities we serve.<br /></strong><br /> <p>To learn more about the &ldquo;Montefiore Difference&rdquo; &ndash; who we are at Montefiore and all that we have to offer our associates, please click <strong><a href="https://healthymebenefits.com/" target="_blank" title="Montefiore Difference" rel="noopener noreferrer">here</a></strong>.&nbsp;</p>

Yonkers, New York

Montefiore

<h4 class=""><strong>WHY TOP TALENT PICKS MONTEFIORE EINSTEIN&nbsp;<br /><br /></strong>Since its inception in 1884, Montefiore Einstein&rsquo;s mission has been to heal, to teach, to discover and advance the health of the communities we serve.<br /><br />Montefiore Einstein&rsquo;s state-of-the-art facilities include the&nbsp;<span class="">internationally-recognized</span>&nbsp;Children&rsquo;s Hospital at Montefiore Einstein and our Notable Centers of Excellence - Montefiore Einstein Center for Cancer Care, Montefiore Einstein Center for Heart and Vascular Care, Montefiore Einstein Center for Transplantation. Combined with a growing number of locations throughout the Bronx and Westchester County, Montefiore Einstein is the ideal organization to apply and hone your expertise.<br /><br /><span style="text-decoration: underline;"><a href="https://montefiore.wd12.myworkdayjobs.com/en-US/MMC/login" target="_blank" title="Candidate Home" rel="noopener noreferrer">Sign In</a></span>&nbsp;- Candidate Home<br /><span style="text-decoration: underline;"><a href="https://montefiore.wd12.myworkdayjobs.com/en-US/MMC/introduceYourself" target="_blank" title="Introduce Yourself " rel="noopener noreferrer">Introduce Yourself&nbsp;</a></span>-&nbsp;Please let us know about yourself so we can keep in touch about future job openings!<br /><br /><strong><span class="">NURSE&nbsp;RECRUITMENT&nbsp;HOTLINE:</span>&nbsp;<span class="">718-920-6697 (</span><span class="">Monday-Friday: 9am-4pm)&nbsp;&nbsp;</span></strong><br /><br /><strong>Check Out Our Employee&nbsp;<span style="text-decoration: underline;"><a href="https://healthymebenefits.com/" target="_blank" title="Benefits" rel="noopener noreferrer">Benefits</a></span></strong></h4> <h4 class="p1"><span style="text-decoration: underline;"><strong><a href="https://s3.us-east-1.amazonaws.com/vizi.vizirecruiter.com/MontefioreHealthSystem+RecruitingPractices.pdf" target="_blank" title="Safe Online Recruiting" rel="noopener noreferrer">Our Commitment to Safe Online Recruiting</a></strong></span></h4> https://www.montefiore.org/

keywords: position summary,position details,support,performance,quality assurance,teamwork,technical,goals,experience,skills,initiative,education,knowledge

Full time

$144,000.00-$180,000.00

Overview: <p>Montefiore is ranked among the top hospitals nationally and regionally by U.S. News &amp; 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.</p> <p>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.</p> <p>Montefiore is actively investing in its data &amp; 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&rsquo;s AI-ready data Lakehouse in Snowflake that houses complex data solutions supporting Montefiore&rsquo;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.</p>
Responsibilities: <p><strong>Snowflake Platform Administration<br /><br /> </strong></p> <ul> <li>Administer and manage Snowflake enterprise environments (multi-account, multi-region).</li> <li>Configure and manage virtual warehouses, resource monitors, roles, users, and access controls.</li> <li>Perform environment provisioning, cloning, replication, and lifecycle management.</li> <li>Monitor upgrades, feature enablement, and account-level configurations.</li> </ul> <br /><strong>Operational Excellence &amp; Reliability</strong><br /><br /> <ul> <li>Ensure 24/7 operational readiness and platform stability.</li> <li>Implement monitoring, alerting, and observability for performance, storage, and compute usage.</li> <li>Establish operational runbooks, SOPs, and incident response processes.</li> <li>Partner with Montefiore AWS cloud foundations team and data engineering teams to ensure platform SLAs and reliability targets are met.</li> <li>Support root cause analysis and incident resolution for platform-related issues.</li> <li>Define RTO/RPO objectives and ensure compliance with enterprise resiliency standards.</li> <li>Conduct periodic failover testing and recovery drills.</li> </ul> <p>&nbsp;</p> <p><strong>Security, Performance Optimization &amp; Cost Management<br /><br /></strong></p> <ul> <li>Monitor and tune query performance, warehouse sizing, clustering, and data organization.</li> <li>Optimize storage strategies including micro-partitioning and pruning.</li> <li>Drive cost optimization through warehouse right-sizing, auto-suspend/resume strategies, and usage analytics.</li> <li>Provide usage and performance reports as needed.</li> <li>Implement and manage role-based access control (RBAC) and fine-grained access policies.</li> <li>Support audit, compliance, and regulatory requirements.</li> <li>Collaborate with security teams to maintain enterprise data protection standards.</li> <li>Stay current with Snowflake releases and emerging capabilities.</li> <li>Recommend improvements to enhance platform reliability, security, and performance.</li> </ul> <p>&nbsp;</p> <p><strong>Helix Snowflake Lakehouse Data Integration &amp; Ecosystem Support<br /><br /></strong></p> <ul> <li>Support data ingestion pipelines across disparate internal and external data sources primarily Epic Cogito stack.</li> <li>Collaborate with the Helix Data Engineering team to ensure optimal data loading and transformation patterns.</li> <li>Support external tables and integration with AWS cloud storage.</li> <li>Support enablement and operationalization of Snowflake Cortex AI capabilities.</li> <li>Ensure data readiness, governance, and security for AI-driven use cases.</li> <li>Optimize compute resources to support AI workloads.</li> <li>Partner with AI/ML teams to maintain a high-performance platform for model development and inference.</li> </ul>
Requirements: <ul> <li>12+ years of experience in database administration or data platform operations.</li> <li>4+ years of hands-on Snowflake administration experience in enterprise environments.</li> <li>Proven experience managing production-grade, highly available data platforms.</li> <li>Experience designing and implementing DR and business continuity strategies.</li> <li>Solid experience administering Microsoft SQL Server.</li> <li>Strong knowledge of SQL, query optimization, and performance tuning.</li> <li>Experience with security, compliance, and data governance best practices.</li> <li>Experience with AWS cloud platform is a plus.</li> <li>Strong troubleshooting and analytical skills.</li> <li>Ability to work in a fast-paced, mission-critical environment.</li> <li>Snowflake Advanced Administration Certification.</li> <li>Bachelor&rsquo;s degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience).</li> </ul> <p>&nbsp;</p> <p><strong>Preferred Qualifications:<br /><br /> </strong></p> <ul> <li>Experience in health systems database administration.</li> <li>Experience in Epic Cogito stack administration.</li> <li>Experience with Infrastructure-as-Code and DevOps practices.</li> </ul> <p>&nbsp;</p> <p><strong>Competencies</strong>:<br /><br /></p> <ul> <li>Ability to think strategically and drive structured execution.</li> <li>Structured, linear thinker that can conduct business outcome diagnostics and identify highest value business opportunities.</li> <li>Strong facilitation skills to help business leaders identify their most important business questions.</li> <li>Exhibits excellent judgment, especially when working with ambiguity.</li> <li>Sets stretch goals and works to exceed goals with a focus for results.</li> <li>Has the innate ability to gain the confidence of and build strong relationships with executives, peers, management and subordinates alike.</li> <li>Excellent business-facing presentation skills.</li> </ul>