What are the responsibilities and job description for the Snowflake admin position at Tanisha Systems, Inc?
Job description
Role Overview:
We are seeking a skilled Snowflake Administrator with at least 5 years of hands-on experience in Snowflake administration and architecture. The ideal candidate will be well-versed in Snowflake components, toolsets, and their purposes, with expertise in performance tuning, security, data encryption, and cloud integration.
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 5 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)
