Snowflake Administrator
Share
Job Location:
Monthly Salary:
Posted on:
18 hours ago
Vacancies:
1 Vacancy
Job Summary
Location: Plano Texas (Hybrid - 3 days onsite)
Role: Snowflake Administrator
Experience Required: 8-10 Years
Job Summary
We are seeking an experienced Snowflake Administrator responsible for managing and optimizing Snowflake environments across global production and non-production systems. The role involves platform administration security management performance tuning automation and integration with cloud and analytics tools to support enterprise data platforms.
Key Responsibilities
Snowflake Platform Administration
-
Administer Snowflake production and non-production environments.
-
Create and manage databases schemas tables views data shares external stages and storage integrations.
-
Implement Snowflake platform standards naming conventions sizing optimization automation and security best practices.
-
Manage multi-cluster warehouses workload scaling and cost optimization.
Snowflake Feature Implementation
-
Work with Snowflake Streams Tasks Cloning and Time Travel features.
-
Implement materialized views clustering micro-partitioning and caching techniques for query optimization and performance tuning.
Security & Access Control
-
Configure and maintain roles privileges and user access using Snowflake RBAC.
-
Implement SSO integrations with Okta and Active Directory groups.
-
Configure network policies row access policies masking policies and secure views.
-
Manage encryption and secure data access frameworks.
Cloud Integration & Infrastructure
-
Set up Snowflake environments including PrivateLink VPC networking and firewall configurations.
-
Integrate Snowflake with AWS services such as S3 EC2 and EKS.
-
Automate administrative tasks using Python Shell scripting and SnowSQL.
Data Sharing & Disaster Recovery
-
Manage Snowflake data sharing account replication and disaster recovery processes.
-
Support cross-account data sharing and business continuity planning.
Performance Optimization & Automation
-
Identify opportunities to optimize data flows automate processes and improve system scalability and cost efficiency.
-
Develop automation scripts for monitoring alerts and maintenance tasks.
Integration & Analytics Support
-
Support integrations with Tableau SAS Python and other JDBC-based tools.
-
Work with Data Engineers Data Architects Data Scientists and Information Security teams to maintain platform standards.
Innovation & Platform Improvements
-
Perform Proof of Concepts (POCs) for new Snowflake features and evaluate adoption opportunities.
-
Support CI/CD processes for Snowflake deployments.
-
Explore Snowflake capabilities including Cortex LLM and Streamlit applications.
Required Qualifications
-
Bachelors degree in Computer Science Engineering or a related field.
-
10 years of IT experience including 5 years in DevOps or Database Administration.
-
3 years of hands-on Snowflake administration experience.
-
Strong experience with SQL Python Unix and Shell scripting.
-
Experience working with AWS services such as S3 EC2 and EKS.
-
Strong knowledge of data warehousing concepts and performance optimization techniques.
-
Excellent communication and collaboration skills.
Top 3 Required Skills
-
Snowflake Administration
-
Python and Unix Shell Scripting
-
AWS and SQL
Top 3 Preferred Skills
-
Snowflake Cortex / LLM capabilities
-
Streamlit
-
DevOps / CI-CD pipelines
Key Skills
- Hadoop
- Microsoft Windows Server
- Windows
- Apache
- Linux
- SAN
- Shell Scripting
- System Administration
- Administrative Experience
- Scripting
- Oracle
- Troubleshooting
