What are the responsibilities and job description for the Snowflake Admin(Only W2) position at Cloudberyl LLC?
1. Working on day-to-day Snowflake Admin activities like, Storage Integration (AWS & Google Cloud Platform buckets), Integration setup (Notification, API & Email)
2. Setup of Inbound & Outbound Data shares as per the project requirements.
3. IP Allow listing as per the Project requirements, after review/approval of Platform Manager.
4. New Application Onboarding guidance and provide in-depth knowledge around the costing & billing aspects as per the standards.
5. Analyzing the Snowflake Warehouse Usage and provide best recommendations as per the trend and cost optimization.
6. Providing guidance around the usage of Cloud Toolkit API’s and reading the secrets and manage the passwords in the Keeper Vault Services.
7. Configure and optimize Snowflake accounts, virtual warehouses, databases, schemas, and user roles.
8. Monitor platform performance and ensure optimal configuration and scaling of compute resources.
9. Implement and manage data security measures including role-based access control, data encryption, and user authentication.
10. Monitor query performance and optimize SQL queries for better efficiency, Analyze and resolve performance bottlenecks and resource contention issues, Utilize Snowflake’s advanced features such as clustering keys, materialized views, and result caching to enhance performance.
11. Implement backup and recovery strategies to ensure data durability and availability, Manage data archiving, replication, and failover processes.
12. Develop and maintain scripts for automating administrative tasks and workflows, Utilize tools and frameworks for continuous integration and deployment (CI/CD).
13. Provide technical support and troubleshooting for Snowflake-related issues, collaborate with Snowflake support to resolve platform-specific issues
. Knowledge in any RDBMS database like Teradata or Oracle
2. Knowledge of programming languages such as Python or JavaScript.
3. Experience with data visualization tools (e.g., Tableau, Power BI).
4 . 24*7 support model experience