Snowflake Administrator
Share
Job Location:
Marshall County, WV - USA
Monthly Salary:
Not Disclosed
Posted on:
4 hours ago
Vacancies:
1 Vacancy
Job Summary
Tittle : Snowflake Administrator
Location: Dallas TX (day 1 onsite)
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 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:
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.
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.
Location: Dallas TX (day 1 onsite)
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 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:
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.
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.
Required Skills:
SHELL SCRIPTINGSQLVPCAWSNETWORKINGPYTHONENCRYPTIONAWS SERVICESUNIXSAS
Key Skills
- Hadoop
- Microsoft Windows Server
- Windows
- Apache
- Linux
- SAN
- Shell Scripting
- System Administration
- Administrative Experience
- Scripting
- Oracle
- Troubleshooting
