Snowflake Administrator & Developer + Java

Snowflake Administration Responsibilities

• Strong understanding of Snowflake architecture and its core components (storage, compute, cloud services).
• Manage users, roles, and role-based access control (RBAC) with secure privilege assignment.
• Implement and manage authentication mechanisms including OAuth and integration with third-party tools.
• Monitor system usage, performance, alerts, and auditing for stability and compliance.
• Manage warehouses with focus on performance tuning and cost optimization.
• Handle replication, cloning, tagging, and environment management strategies.
• Apply data governance and security best practices across Snowflake environments.
• Understand and manage different table types (transient, temporary, permanent) and their lifecycle.

Snowflake Development Responsibilities

• Develop complex SQL scripts to support business requirements.
• Create and maintain stored procedures, user-defined functions (UDFs), and views.
• Perform query optimization and performance tuning to improve efficiency.
• Support development and enhancement of Snowflake-based data solutions.
• Work on Snowflake scripting and automation tasks as required.

Integration & Security

• Hands-on experience with Snowflake integrations with external systems and platforms.
• Strong understanding of authentication mechanisms and secure data exchange practices.

Performance & Cost Optimization

• Optimize warehouse utilization to reduce operational cost.
• Implement tagging strategies and resource monitoring.
• Identify inefficiencies and improve overall Snowflake performance.