Snowflake Administrator

Snowflake Administrator

Good To Have Skills

Talend Admin, Cost Optimization

Must Have Skills

DDL/DML, Snowflake, Role-Based Access Control (RBAC)

Experience Level

5 - 7 Years

Employee Type

Salaried

External Description

Snowflake Administrator Acquired skills:

Identify the various aspects of compute and storage management

Illustrate administrative tasks within the detailed architecture of Snowflake

Review Snowflake best practices & considerations for managing load operations and performance

Describe data governance in Snowflake, including column-level data security using secure views and

dynamic data masking features

Manage multiple accounts across the Organization

Describe the DDL operations that work with fundamental database objects

Discuss transaction and concurrency models and DML considerations

Employ recovery methods and agile development with Time Travel & Cloning

Implement advanced techniques for Snowflake performance-tuning methodologies

Design and develop secure access to objects in Snowflake with Role-Based Access Control (RBAC)

Recommend the Snowflake best practices for management, monitoring, and optimization

Use data replication for data sharing across accounts and for failover scenarios

Share data securely both within and without your organization

Detailed Snowflake Architecture and Overview

Snowflake Technical Overview

Overview of Three-Tiered Architecture

Compute Management

Scaling Virtual Warehouses Up & Out

Creating and Managing Virtual Warehouses

External Skills And Expertise

Mandatory Skills:

Compute & Storage Management, Load Operations Management, Snowflake Architecture, Data Governance, Column-Level Data Security, Dynamic Data Masking, DDL/DML Operations, Transaction & Concurrency Models, Recovery Methods, Agile Development, Time Travel, Role-Based Access Control (RBAC), Data Replication, Secure Data Sharing

Good to Have Skills:

Talend Admin Experience, Cost Optimization