Snow Flake Job Opening in New York, NY

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:

3+ 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

Unix Shell Scripting