What are the responsibilities and job description for the Snowflake Admin position at VHL Technologies?
Job Details
The Snowflake Administrator is responsible for the administration, maintenance, and optimization of the Snowflake data platform. This role involves managing user access, ensuring data security, optimizing performance, and providing operational support for data integration and analytics initiatives. The ideal candidate will have a strong background in database administration, data warehousing, and cloud technologies, with a focus on operational support and troubleshooting.
Key Responsibilities:
Manage and maintain the Snowflake environment, including databases, schemas, tables, and views.
Monitor system performance and ensure high availability and reliability of the Snowflake platform.
Create and manage user accounts, roles, and permissions to ensure secure and efficient access to data.
Implement role-based access control (RBAC) and ensure compliance with security policies.
Monitor and optimize query performance, resource utilization, and storage.
Conduct performance tuning and troubleshooting to resolve issues.
Support data integration processes, including data ingestion, transformation, and loading (ETL).
Set up and manage monitoring and alerting systems to track platform health and performance.
Perform regular maintenance tasks, including backups, updates, and patch management.
Troubleshoot and resolve technical issues related to the Snowflake platform.
Provide operational support for Snowflake, including incident management, problem resolution, and root cause analysis.
Respond to and resolve Snowflake-related issues in a timely manner, ensuring minimal disruption to business operations.
Develop and maintain operational runbooks and standard operating procedures (SOPs) for Snowflake administration and support.
Qualifications:
4 years of experience in database administration, data warehousing, or cloud data platforms.
Proven experience with Snowflake administration and optimization.
Experience with SQL, data modelling, and ETL processes.
Experience in providing operational support and troubleshooting for data platforms.
Strong understanding of Snowflake architecture, features, and best practices.
Proficiency in SQL and experience with scripting languages (e.g., Python, Shell).
Certifications:
Snowflake SnowPro Core Certification or equivalent is a plus.
Relevant certifications in cloud platforms (e.g., AWS, Azure, Google Cloud Platform) are a plus.