Snowflake Administrator

Tittle: Snowflake Administrator

Location: Dallas TX (day 1 onsite)

Duration: Long Term

Job Description

Roles and Responsibilities:

• Administrating Snowflake sub-prod, prod and the global environments. Create database, schema, tables, views, data share, external stage, storage integration.
• Document, maintain and implement Snowflake platform design standard, pattern, discipline, naming, sizing, optimization, automation, security, best practices, usage.
• Real world work experience in using Snowflake Stream, Task, Clone and Time Travel, multi-cluster Warehouses, scaling out, scaling up for different types of workloads.
• Security roles, privileges, users as per best practice. Integrate other tools as per business need but leverage snowflake role-based security to enforce access restrictions.
• Proactively identify, design, and implement process improvements like automating manual processes, optimizing data flow, increase scalability and be cost-effective.
• Well versed with Materialized views, Clustering, micro-partitioning, Caching like optimization techniques to tune the queries and fix the performance issues on priority basis.
• Experience in setting up the Snowflake account from scratch for an enterprise-wide implementation, the Private Link setups, VPC, Networking, Firewall.
• Should have written in past the DBA scripts using Python and/or Shell scripts and the SNOW SQL. Execution from Amazon EC2 to automate and/or notify Admin related alerts. Must have used the AWS services like the S3, EC2, EKS.
• Snowflake SSO/Okta integration and AD Groups setups, Access Control, Encryption, Secured Views. Work experience on Network policy, Row Access Policy, Masking policy.
• Support to Tableau connection to Snowflake. SAS, Python and other jdbc connections.
• Should have done the Data Share, Account Replication, Disaster Recovery exercise.
• Should know the CI/CD in Snowflake and the Schema change process.
• Perform POT and POC for new features, capabilities and their evaluations and then adaption.
• Collaborate with Data Modelers, Data Engineers, Data Architects, Information Security and maintain the standards, consistency, adhere to best practices and be compliant.
• Partner with Data Science, Data Analysis teams, address snowflake platform issues, concerns if there is any. Provide Snowflake solution to the business problem as applicable.

Qualification:

• Bachelor's degree in a relevant field.
• 10+ years of IT experience, including 5+ years in DevOps or Database Administration roles.
• 3+ years of hands-on experience with Snowflake administration, Python ELT, SQL, Unix, Shell scripting and AWS services like EC2 and S3.
• Preferred certifications in Snowflake, Python, or AWS.
• Previous experience in the financial industry is a plus.
• Strong communication and collaboration skills with attention to detail.
• Proven ability to design effective solutions, maintain consistency, and drive disciplined execution.

Thanks & Regards,

Ramesh