Snowflake Administrator

Nastech Global

Not Interested
Bookmark
Report This Job

profile Job Location:

Plano, TX - USA

profile Monthly Salary: Not Disclosed
Posted on: 2 hours ago
Vacancies: 1 Vacancy

Job Summary

Position: Snowflake Administrator

Location: Plano TX(Onsite)
Duration: Fulltime

Job Description

Must Have Technical/Functional Skills

  • Bachelors 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.

Roles & 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 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.
Position: Snowflake Administrator Location: Plano TX(Onsite) Duration: Fulltime Job Description Must Have Technical/Functional Skills Bachelors 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 ...
View more view more

Key Skills

  • Hadoop
  • Microsoft Windows Server
  • Windows
  • Apache
  • Linux
  • SAN
  • Shell Scripting
  • System Administration
  • Administrative Experience
  • Scripting
  • Oracle
  • Troubleshooting