Job Role: Administer and modernize cloud-first data platforms (Azure and Snowflake) with secondary support for on‑premises SQL Server, focusing on centralized, automated deployments, secure operations (including HIPAA/PHI), performance/availability, and continuous improvement through automation to increase efficiency and reliability.
Job Description:
• Administers and supports cloud-first data platforms (Azure and Snowflake), including Azure Data Factory (ADF), Azure SQL Database/Managed Instance, Azure Cosmos DB, Azure Database for PostgreSQL, MongoDB, and Snowflake; provides support for on premises SQL Server.
• Centralizes, standardizes, and executes deployments for SQL Server–related components, including SQL code (DDL/DML, stored procedures), SQL Agent jobs, SSIS packages, SSAS models, SSRS reports, and supporting BI/analytics tools (Tableau, Alteryx).
• Designs, implements, and maintains automated CI/CD pipelines and release processes for databases, pipelines, and analytics artifacts across environments, emphasizing repeatability, auditability, and change control.
• Builds and operates deployment automation and administrative tooling using scripting and programming (e.g., PowerShell, Python), enabling self-service and reducing manual effort.
• Monitors, tunes, and optimizes database and warehouse performance across platforms (SQL Server, Azure data services, Snowflake), ensuring capacity planning, cost/performance efficiency, and stable SLAs.
• Implements and validates backup/restore, high availability and disaster recovery, replication, and data protection controls for on prem and cloud environments; performs regular testing and documentation of recovery procedures.
• Operates and governs data ingestion/integration pipelines, including ADF orchestration and Coalesce-based data modeling for the Snowflake EDW, ensuring reliability, lineage, and deployable, version-controlled models.
• Manages security, access controls, secrets, and auditing across data platforms and tooling; ensures proper handling of highly sensitive PHI in compliance with HIPAA and partners with security/compliance stakeholders to meet policy and regulatory requirements.
• Leads incident response, troubleshooting, root-cause analysis, and problem management for production and critical environments; participates in on-call support as required and maintains runbooks, deployment guides, and operational documentation.
• Drives continuous improvement using an automation-first, AI-enabled approach by applying standardization, templates, and intelligent tooling to improve developer/analyst experience, increase deployment velocity, and reduce operational risk.
Experience:
• Cloud Data Platforms (Primary): 8 to 10+ years administering and supporting enterprise data platforms, with primary focus on cloud services (Azure data services and Snowflake) and support for on‑premises SQL Server.
• Centralized Deployments & DevOps: 5+ years building and operating standardized release processes and CI/CD pipelines for database, ETL/ELT, and analytics artifacts, with strong source control and change management discipline.
• Reliability & Performance: Proven experience operating mission‑critical data systems, including performance tuning, monitoring/alerting, capacity planning, incident response, and resilient backup/restore and DR practices.
• Governance & Security: Experience implementing access controls, auditing, and secure configuration across data platforms, partnering with security/compliance stakeholders, and supporting HIPAA-regulated environments.
Skills:
• Cloud data platform administration: Hands-on administration of Snowflake and Azure data services (Azure SQL DB/MI), including security, performance tuning, cost management, and operational support; supports on‑prem SQL Server.
• Cloud database services: Working knowledge administering and operating Azure Cosmos DB, Azure Database for PostgreSQL, and MongoDB (security, monitoring, performance/capacity, and troubleshooting).
• Azure Data Factory (ADF): Build/support ADF orchestration with production monitoring, alerting, and troubleshooting.
• Snowflake administration: Manage warehouses, roles/grants, resource monitors, performance tuning, and cost management for a modern cloud EDW.
• Data modeling & ELT tooling: Use Coalesce (or similar) to build modular, version-controlled models; strong understanding of dimensional modeling and data quality/lineage concepts.
• Release engineering for data platforms: Ability to package and deploy SQL code, SQL Agent jobs, SSIS packages, SSAS models, and SSRS reports via CI/CD with repeatable promotion across environments; familiarity deploying/refreshing downstream analytics tools (e.g., Tableau, Alteryx).
• Automation & scripting: Proficiency with PowerShell and Python to automate operational tasks (deployments, monitoring, user/access provisioning, and routine maintenance); able to evaluate and apply AI-assisted tooling safely and appropriately.