Snowflake Administrator (7-12 yrs)

Job Description :

- 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