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.