Snowflake App Admin

Snowflake App AdminWork Location: USA - Rosemead, CANumber of Openings: 1 (USA – California)Duration of Hiring: May - Dec 2021No of years' experience: 8+Detailed job description:Skill Set:Compute ManagementScaling Virtual Warehouses Up & OutCreating and Managing Virtual WarehousesSnowflake Objects & CommandsBuilt-in Design and Comparison to Traditional SQL CommandsDDL Commands to Work with Different Database ObjectsDifferent Functions and Operators Available in SnowflakeAccount, Session, & Object ParametersStorage ManagementTable Design ConsiderationsDML and Cloning ConsiderationsStorage OptimizationPerformance Methodology & ManagementQuery Profile AnalysisQuery Best PracticesCachingTroubleshooting Tools & Tuning Performance MetricsData ClusteringSearch Optimization ServiceMaterialized ViewsImplement Role-based Access & DesignSystem Roles & Custom RolesRole HierarchyBest PracticesColumn-Level Data Security to Protect Sensitive DataCertified in Snowflake SnowPro CoreImplement Time Travel on Warehouses and SchemasImplement Multi-cluster warehouseAssure highest performance when repeating queries from a collection of BI tools, reports and dashboardsBackup and RecoveryMigration of components between Dev, QA and Production environment through DevOps setup on GitHubMigration of historical data from Oracle DB into Snowflake using AZ Copy into Blob and SnowflakeExpertise in Snowflake – data modeling, ELT/ETL using Snowflake SQL and Talend (optional)Technical Skills:Snowflake App Admin experienceCloud DW AdminSnowflake SQLAzure Cloud Big Data Admin experience