Description

You will manage and optimize the Snowflake environment to ensure secure, efficient, and cost-effective data operations.

Responsibilities

• Create and manage Snowflake objects including databases, schemas, tables, views, materialized views, pipes, streams, and tasks.
• Configure account-level objects such as warehouses, resource monitors, network policies, and integrations for storage and notification.
• Implement RBAC best practices, manage user access rights, and handle privileged roles including Accountadmin, Sysadmin, and Securityadmin.
• Analyze and plan workloads using multi-cluster warehouses, scaling policies, and application-specific warehouse management to optimize compute consumption.
• Monitor and report on cost and credit consumption to identify optimization opportunities.
• Manage PII data through dynamic data masking, secure views, and Azure AD SSO authentication.
• Resolve connectivity issues involving ODBC, JDBC, and Python connectors.

Required Skills

• 5+ years of experience in data administration.
• Hands-on experience with Snowflake Accountadmin, Sysadmin, and Securityadmin roles.
• Proficiency with ODBC, JDBC, and Python connectors.
• Expertise in warehouse management, resource monitors, and network policies.
• Experience managing integrations for storage and notification.
• Knowledge of secure data sharing and reader account provisioning.
• Experience with IP whitelisting and credit quota management.
• Ability to manage ETL batch support and issue resolution.

Preferred Skills

• Experience with Azure cloud environments and Azure SQL Databases.
• Performance monitoring and tuning for SQL Server (2005-2014).
• Experience with distributed databases, MongoDB, or MDM projects.

Key Skills

Education

Any Gradute