What are the responsibilities and job description for the Snowflake Administrator position at Jobs via Dice?
Position: Snowflake Administrator
Location: Plano, TX(Onsite)
Duration: Fulltime
Job Description
Must Have Technical/Functional Skills
Location: Plano, TX(Onsite)
Duration: Fulltime
Job Description
Must Have Technical/Functional Skills
- 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.
- Strong communication and collaboration skills with attention to detail.
- Proven ability to design effective solutions, maintain consistency, and drive disciplined execution.
- Local to Dallas or willing to relocate and be in office atleast 3 days a week.
- 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, familiarity with Cortex /LLM, Streamlit
- 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.