Requirements
· At least 3 years of working experience in Snowflake administration.
· Should be proficient in cloud data warehousing concepts, building cloud data warehouse
· Proficient in provisioning requests like warehouse, database, schema, stage, users and roles in Snowflake
· Developing stored procedures in Snowflake using Java script
· Should be aware of Data encryption using Tri-secret secure keys
· Should be good in optimization required for Snowflake like Query optimization, storage optimization techniques
· Should be aware of DR activities like DR setup, data recovery and off cloud backups
· Should have knowledge on regular operational activities including incident and problem management
· Should be aware of security and auditing aspects with respect to Snowflake, charge back models, different reporting tools available
· Should be able to analyze and resolve platform related issues.
· Should work on the critical incidents and user service requests and responsible for SLA adherence, tracking and reporting.
· Assist application/migration teams with database activities.
· Assists with impact analysis of all Prod/Non-Prod changes.
· Responsible for User (on/off boarding), Access (grant/revoke) management.
· Should be able perform backup(clone) , restore (time travel, Undrop) activities and sharing.
· Should be able to identify performance bottlenecks, tune Query and Performance, Triage and resolve the same.
· Should generate and monitor the cost/credit consumption reports and take the effective measures for cost optimization.
· Must be able to solve complex problems and ability to work on multiple projects/tasks simultaneously to meet project deadlines.
· Works well in a collaborative, cross functional, and multi-cultural environment with onshore/offshore teams.