Location - Buffalo, NY - 14203 (Hybrid)

Title - Lead Snowflake Admin

Duration - 06 Months (Possible Extension)

Pay Range: $60/hr. to $70/hr.

Skill Set

• Snowflake Administration 

• Infrastructure as Code 

• Linux Administration

Overview

• Provide technical administrative support to our Snowflake systems and applications

• Work with internal and external teams to help design solutions based on the needs of our Snowflake applications

• Design resilient, scalable, and maintainable systems for the enterprise data platform team and interfacing applications

Primary responsibilities

• Snowflake – - Create and configure new Snowflake accounts as needed

• Design, implement, and support replication processes to ensure business continuity

• Design, implement, and support data sharing solutions for both in-bound and out-bound data shares

• Design, implement, and support role based access controls (RBAC) to properly secure our data

• Monitor cost and performance of activities on the Snowflake accounts

• Assist applications with troubleshooting needs

• Implement production application database changes when needed Linux

• Provide 1st level Linux administration support for Snowflake application servers Cloud

• Foundational cloud concepts

• Experience building in Azure

• Good understanding of Private DNS zones, Blob Storage (tiers), Private endpoints & Private Link in relation to snowflake DevOps

• Experience with infrastructure as code using tools such as Terraform and Ansible

• Comfort with code versioning tools (git)