Job Title: Snowflake Administrator
Experience: 5 - 7 years
Mandatory Skills: DDL/DML, Snowflake, Role-Based Access Control (RBAC)
Key Responsibilities:
- Administer and manage Snowflake environments, ensuring efficient database performance and availability.
- Handle DDL/DML operations such as creating tables, views, indexes, and managing data loading, updating, and deletion processes.
- Implement and manage Role-Based Access Control (RBAC) policies to ensure secure data access and user privileges within the Snowflake platform.
- Optimize Snowflake configurations, storage usage, and query performance to improve operational efficiency.
- Collaborate with data engineering teams to support the development and maintenance of scalable and efficient Snowflake solutions.
- Perform backup, recovery, and disaster recovery planning for Snowflake environments.
- Monitor and manage usage, costs, and resource allocation within Snowflake.
- Troubleshoot and resolve any Snowflake-related performance and operational issues.
- Ensure compliance with data security standards and best practices.
Qualifications:
- 5 - 7 years of experience in database administration, with at least 3 years focused on Snowflake.
- Strong knowledge of DDL/DML operations and database query optimization.
- Proven experience with Role-Based Access Control (RBAC) implementation and management.
- Experience in monitoring, tuning, and optimizing Snowflake environments for performance and cost-efficiency.
- Strong understanding of data warehousing concepts and SQL.
- Hands-on experience with backup, recovery, and disaster recovery solutions.
- Excellent troubleshooting and problem-solving skills.
