Snowflake Admin

Overview

On Site
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

Snowflake
Snowflake Admin
API
AWS
GCP
Cloud
warehouses
SQL
Teradata
Python
JavaScript
Tableau

Job Details

Job Title: Snowflake Admin

Location: San Jose, CA (Onsite)

Job Description:

Working on day-to-day Snowflake Admin activities like, Storage Integration (AWS & Google Cloud Platform 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

1. Knowledge in any RDBMS database like Teradata or Oracle

2. Knowledge of programming languages such as Python or JavaScript.

3. Experience with data visualization tools (e.g., Tableau, Power BI).

4. 24*7 support model experience

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.