Snowflake Admin

Role : Snowflake Admin

Location : Bangalore

Exp : 8-10yrs

Imm-30 days Notice Period

JD

Desired Competencies (Technical / Behavioral Competency)

Must-Have

• Working on day-to-day Snowflake Admin activities like, Storage Integration (AWS & GCP buckets), Integration setup (Notification, API & Email)
• Setup of Inbound & Outbound Data shares as per the project requirements.
• IP Allow listing as per the Project requirements, after review / approval of Platform Manager.
• New Application Onboarding guidance and provide in-depth knowledge around the costing & billing aspects as per the standards.
• Analyzing the Snowflake Warehouse Usage and provide best recommendations as per the trend and cost optimization.
• Providing guidance around the usage of Cloud Toolkit API's and reading the secrets and manage the passwords in the Keeper Vault Services.
• Configure and optimize Snowflake accounts, virtual warehouses, databases, schemas, and user roles.
• Monitor platform performance and ensure optimal configuration and scaling of compute resources.
• Implement and manage data security measures including role-based access control, data encryption, and user authentication.
• Monitor query performance and optimize SQL queries for better efficiency, Analyze and resolve performance bottlenecks and resource contention issues, Utilize Snowflake's advanced features such as clustering keys, materialized views, and result caching to enhance performance.
• Implement backup and recovery strategies to ensure data durability and availability, Manage data archiving, replication, and failover processes.
• Develop and maintain scripts for automating administrative tasks and workflows, Utilize tools and frameworks for continuous integration and deployment (CI / CD).
• Provide technical support and troubleshooting for Snowflake-related issues, collaborate with Snowflake support to resolve platform-specific issues

Skills Required

Gcp, Sql, Aws