Snowflake DBA

Snowflake DBA

Job Location: Hyderabad / Bangalore / Chennai / Noida/ Gurgaon / Pune / Indore / Mumbai

Responsibilities:
• Implement a backup and recovery plan.
• Develop and implement business continuity plan and procedures.
• Monitor and manage compute, storage, and data sharing costs.
• Optimize compute with scale out and scale in planning.
• Performance tune virtual warehouses.
• Create new databases, tables, views, data sharing.
• Implement security, roles, users and privileges using RBAC model.
• Implement data pipelines using SnowSQL.
• Develop SQL Scripts and Stored Procedures.
• Develop Unix Shell Scripts.
• Create AZDO CI/CD pipelines.

Skills:
• 4+ years of experience as Snowflake DBA.
• Experience with Data Lake, Data Warehouse and Data Sharing concepts.
• Skilled in testing of cloud-based database solutions.
• 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 and Unix Shell Scripting