Snowflake Database Administrator responsible for support and maintenance of data lakes,
data warehouse and databases. Knowledge of Snowflake Database Engineering is a plus.
•Implement a backup and recovery plan
•Optimize compute with scale out and scale in planning.
• Performance tune virtual warehouses.
•Implement security, roles, users and privileges using RBAC model.
• Implement data pipelines using SnowSQL.
• Strong DBA administration skills for all DB maintenance plan activities including backups, indexing, integrity, and consistency checks, etc.
• Experience in troubleshooting and resolving database problems performance tuning and optimization.
• Proactively identify, design, and implement process improvements like automating manual processes, optimizing data flow, increasing scalability etc.
• knowledge in Snowflake security features including access control, authentication, authorization, encryption, masking, secured views etc.
• Skilled in relational and dimensional modeling.
• Experience with Snowflake and its utilities i.e. SnowSQL, SnowCD etc.
• SQL
• Unix Shell Scripting