Snowflake Admin

Key Responsibilities:

• Snowflake Administration
• Design and manage schemas, tables, and other database objects.
• Optimize performance through tuning and query optimization.
• Set up and manage security protocols, including access controls and data encryption.
• Deploy Snowflake SQL scripts and stored procedures using CI/CD processes.
• Monitor resource utilization and provide detailed cost reporting.
• Snowflake Architecture
• Understand the architecture and various components of Snowflake.
• Manage storage, clusters, and warehouse sizes for optimal performance.
• Ensure scalability and reliability in Snowflake environments.
• Collaboration and Communication
• Work closely with development and testing teams to streamline database operations.
• Clearly articulate the scope of admin tasks and their impact on project goals.

Minimum Qualifications:

• At least 2 years of experience in Snowflake administration.
• Strong understanding of Snowflake architecture, components, and toolsets.

Preferred Skills and Tools:

• Programming: Python, Shell scripting, SQL, and stored procedure development.
• Cloud Services: Experience with AWS services.
• Integration Tools: Familiarity with tools like dbt, Informatica.
• CI/CD: Hands-on experience with CI/CD tools such as Jenkins.

Certifications:

Certification in Snowflake Administration (preferred).