Senior Administrator - Snowflake & SQL

Montefiore Health System; New York (NY); On-site; USD 144,000 - 180,000; Full time

Job summary

Montefiore Health System is seeking an experienced Snowflake Database Administrator (DBA) in New York, NY. The ideal candidate will manage and optimize enterprise data platforms, ensuring high performance, security, and scalability. Responsibilities include Snowflake platform administration, operational excellence, and cost management. Qualifications include 12+ years in database administration, strong Snowflake experience, and a Bachelor’s degree in a related field. This role offers a competitive salary ranging from $144,000 to $180,000 annually.

Qualifications

• 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.

Responsibilities

• Administer and manage Snowflake enterprise environments.
• Ensure 24/7 operational readiness and platform stability.
• Monitor and tune query performance and optimize storage strategies.

Skills

Snowflake administration

Query optimization

SQL Server administration

Performance tuning

Troubleshooting

Data governance

Education

Bachelor’s degree in Computer Science or related field

Tools

AWS

Epic Cogito stack

Job description

Overview

Location: Yonkers, New York. Department: D&A - Data & Analytics. Work Shift: Day. Work Days: MON-FRI. Scheduled Hours: 8:30 AM–5 PM (7.5 hours). Pay Range: $144,000.00–$180,000.00. This is not grant funded.

Position

Montefiore is seeking an experienced Snowflake Database Administrator (DBA) with strong expertise in Snowflake to manage, optimize, and support enterprise data platforms. The ideal candidate will ensure high availability, performance, security, and scalability of Snowflake and AWS-based SQL Server data platforms, with a focus on Snowflake advanced administration. The role will administer Montefiore’s AI-ready data Lakehouse in Snowflake that supports Montefiore’s business functions and scalable data and insights capabilities to improve patient healthcare.

Responsibilities

• Snowflake Platform Administration: Administer and manage Snowflake enterprise environments (multi-account, multi-region).
• 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 AWS cloud foundations and data engineering teams to meet SLAs and reliability targets.
• Support root cause analysis and incident resolution for platform-related issues; define RTO/RPO objectives and ensure 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 and usage analytics.
• Provide usage and performance reports; implement and manage RBAC and fine-grained access policies; support audit, compliance, and regulatory requirements; collaborate with security teams to maintain data protection standards; stay current with Snowflake releases and capabilities; recommend improvements to enhance platform reliability, security, and performance.
• Helix Snowflake Lakehouse Data Integration & Ecosystem Support: Support data ingestion pipelines across disparate data sources (primarily Epic Cogito stack); collaborate with Helix Data Engineering to optimize data loading and transformation; support external tables and AWS storage integration; enable operationalization of Snowflake Cortex AI capabilities; ensure data readiness, governance, and security for AI-driven use cases; optimize compute resources for AI workloads; partner with AI/ML teams to maintain a high-performance platform for model development and inference.

Qualifications

• Required: 12+ years of experience in database administration or data platform operations.
• Required: 4+ years of hands-on Snowflake administration experience in enterprise environments.
• Proven experience managing production-grade, highly available data platforms.
• Experience designing and implementing disaster recovery (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.
• AWS cloud platform experience 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 capable of identifying high-value business opportunities.
• Strong facilitation skills to help leaders identify important business questions.
• Good judgment, especially in ambiguous situations; sets stretch goals and aims for results.
• Ability to gain the confidence of executives, peers, management, and subordinates; strong business-facing presentation skills.