Snowflake DBA (Azure Focus)
- Open Hall, NL, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Experience
- 3-5 years of experience in database administration, with at least 2 years focused on Snowflake administration in cloud environments.
- Posting language
- English
- Posted
Original job description
Job Description
About xCroTek
xCroTek is a product- and service-based AI software company that builds innovative, AI-powered solutions to drive intelligent automation and digital transformation. We specialize in creating scalable, impactful technologies for modern businesses.
Job Overview
We are hiring a dedicated Snowflake DBA with 3-5 years of experience to manage and optimize our Snowflake data platform on Azure. In this role, you will handle day-to-day administration, performance tuning, and security while contributing to architectural designs aligned with the Medallion Architecture framework. You will ensure high availability, cost efficiency, and seamless integration with Azure services to support enterprise data workloads. The ideal candidate is a proactive administrator with a blend of technical expertise and architectural insight, eager to enhance data reliability in a cloud-native environment. This mid-level position offers growth opportunities in a collaborative Azure-based data team.
Key Responsibilities
Interested candidates should submit their resume and a brief cover letter explaining their interest in the role to hr@xcrotek.com. Please include “Snowflake DBA (Azure Focus)” in the subject line.
Apply with a one-page cover letter and CV to hr@xcrotek.com
#Azure#Snowflake
SHARE THIS INSIGHT
Copied!
About xCroTek
xCroTek is a product- and service-based AI software company that builds innovative, AI-powered solutions to drive intelligent automation and digital transformation. We specialize in creating scalable, impactful technologies for modern businesses.
Job Overview
We are hiring a dedicated Snowflake DBA with 3-5 years of experience to manage and optimize our Snowflake data platform on Azure. In this role, you will handle day-to-day administration, performance tuning, and security while contributing to architectural designs aligned with the Medallion Architecture framework. You will ensure high availability, cost efficiency, and seamless integration with Azure services to support enterprise data workloads. The ideal candidate is a proactive administrator with a blend of technical expertise and architectural insight, eager to enhance data reliability in a cloud-native environment. This mid-level position offers growth opportunities in a collaborative Azure-based data team.
Key Responsibilities
- Administer Snowflake environments on Azure, including user management, role-based access control (RBAC), resource monitoring, and cost optimization using tools like Snowsight and Azure Cost Management.
- Architect and implement data pipelines following the Medallion Architecture (Bronze for raw data, Silver for refined data, Gold for curated analytics) to ensure scalable, layered data processing.
- Monitor and tune Snowflake performance, including warehouse sizing, query optimization, clustering, and caching strategies to handle high-volume workloads efficiently.
- Manage data security and compliance, implementing features like encryption, masking, row-level security, and integration with Azure AD for authentication and Azure Sentinel for threat detection.
- Oversee data ingestion, replication, and sharing using Snowflake features such as Snowpipe, Streams, and Secure Data Sharing, with Azure integrations like Data Factory and Synapse.
- Perform regular maintenance tasks, including backups (Time Travel/Fail-safe), disaster recovery planning, and troubleshooting incidents to maintain 99.9% uptime.
- Collaborate with data engineers, architects, and Azure teams to design secure, cost-effective solutions and conduct audits for data governance adherence.
- Document configurations, procedures, and architectural decisions; provide training and support to end-users on Snowflake best practices.
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- 3-5 years of experience in database administration, with at least 2 years focused on Snowflake administration in cloud environments.
- Hands-on experience architecting Snowflake solutions using Medallion Architecture for organized data layering and transformation.
- Proficiency in Snowflake administration tools and features: accounts, warehouses, stages, pipes, streams, tasks, and security protocols.
- Strong knowledge of Azure services integrated with Snowflake, such as Azure AD, Data Lake Storage, Synapse Analytics, and monitoring via Azure Monitor.
- Expertise in SQL for query analysis, performance tuning, and scripting administrative tasks.
- Familiarity with data governance, compliance standards (e.g., GDPR, SOC 2), and cost management in multi-tenant cloud setups.
- Experience with ETL/ELT orchestration tools like dbt or Azure Data Factory in Medallion implementations.
- Background in other cloud databases (e.g., Azure SQL Database) or big data platforms (e.g., Databricks).
- Snowflake SnowPro Core or Advanced Administrator certification, and Azure AZ-104 or DP-203 certifications.
- Knowledge of automation scripting with Python or SnowSQL for routine DBA tasks.
- Core: Snowflake Administration (RBAC, Monitoring, Tuning), Medallion Architecture, SQL Optimisation
- Azure Integration: Azure AD, Synapse, Data Factory, ADLS Gen2, Azure Monitor
- Tools & Technologies: Snowsight, SnowSQL, dbt; Backup/Recovery (Time Travel)
- Concepts: Data Security, Cost Optimisation, High Availability, Cloud Governance
- Strong analytical and problem-solving skills to diagnose and resolve complex database issues swiftly.
- Excellent communication abilities to explain technical concepts to stakeholders and document processes clearly.
- Ability to prioritize tasks and deliver reliable solutions in a fast-paced, team-oriented Azure environment.
Interested candidates should submit their resume and a brief cover letter explaining their interest in the role to hr@xcrotek.com. Please include “Snowflake DBA (Azure Focus)” in the subject line.
Apply with a one-page cover letter and CV to hr@xcrotek.com
#Azure#Snowflake
SHARE THIS INSIGHT
Copied!
More about this job
Responsibilities
Administer and optimize Snowflake environments on Azure, including access control, performance, cost management, security, ingestion, and recovery. Design Medallion Architecture data pipelines, maintain high availability, document procedures, and collaborate with data and Azure teams on governed solutions.
Requirements
Requires a bachelor’s degree in Computer Science, Information Technology, or a related field, plus 3–5 years of database administration experience, including at least 2 years administering Snowflake. Candidates should have strong SQL and Snowflake expertise, Azure integration experience, and knowledge of Medallion Architecture, security, governance, and cloud cost management.
Skills
- Snowflake Administration
- Medallion Architecture
- SQL
- Performance Tuning
- Azure Integration
- Role-Based Access Control
- Data Security
- Data Governance
- Cost Optimization
- Azure Active Directory
- Azure Data Factory
- Azure Synapse Analytics
- Azure Data Lake Storage Gen2
- Snowpipe
- Disaster Recovery
- Python
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
Keywords
- Snowflake
- Azure
- Database Administration
- Medallion Architecture
- SQL
- Snowsight
- SnowSQL
- Azure Active Directory
- Azure Data Lake Storage Gen2
- Azure Synapse Analytics
- Azure Data Factory
- Azure Monitor
- Azure Cost Management
- Azure Sentinel
- Snowpipe
- Streams
- Tasks
- Secure Data Sharing
- Time Travel
- Fail-Safe
- Role-Based Access Control
- Data Masking
- Row-Level Security
- Data Governance
- GDPR
- SOC 2
- dbt
- Databricks
- Python
- SnowPro Certification