Job Description
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).