Snowflake App Admin

Snowflake App Admin

Work Location USA - Rosemead, CA

Number of Openings 1 (USA – California)

Duration of Hiring May - Dec 2021

No of years' experience 8+

Detailed job description:

Skill Set:

• Compute Management

• Scaling Virtual Warehouses Up & Out

• Creating and Managing Virtual Warehouses

• Snowflake Objects & Commands

• Built-in Design and Comparison to Traditional SQL Commands

• DDL Commands to Work with Different Database Objects

• Different Functions and Operators Available in Snowflake

• Account, Session, & Object Parameters

• Storage Management

• Table Design Considerations

• DML and Cloning Considerations

• Storage Optimization

• Performance Methodology & Management

• Query Profile Analysis

• Query Best Practices

• Caching

• Troubleshooting Tools & Tuning Performance Metrics

• Data Clustering

• Search Optimization Service

• Materialized Views

• Implement Role-based Access & Design

• System Roles & Custom Roles

• Role Hierarchy

• Best Practices

• Column-Level Data Security to Protect Sensitive Data

• Certified in Snowflake SnowPro Core

• Implement Time Travel on Warehouses and Schemas

• Implement Multi-cluster warehouse

• Assure highest performance when repeating queries from a collection of BI tools, reports and dashboards

• Backup and Recovery

• Migration of components between Dev, QA and Production environment through DevOps setup on GitHub

• Migration of historical data from Oracle DB into Snowflake using AZ Copy into Blob and Snowflake

• Expertise in Snowflake – data modeling, ELT/ETL using Snowflake SQL and Talend (optional)

Technical Skills:

Snowflake App Admin experience

Cloud DW Admin

Snowflake SQL

Azure Cloud Big Data Admin experience