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