Access Control, Amazon Elastic Compute Cloud (EC2), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Best Practices, Caching, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cryptography, Data Analysis, Data Modeling, Data Processing, Data Science, Database Administration, Detail Oriented, DevOps, Disaster Recovery, Firewalls, Information Technology & Information Systems, Information/Data Security (InfoSec), JDBC (Java Database Connectivity), Problem Solving Skills, Process Improvement, Python Programming/Scripting Language, Replication and Remote Mirroring, SQL (Structured Query Language), Scripting (Scripting Languages), Security Architecture, Single Sign-On (SSO), Snowflake Schema, Tableau, Team Player, Unix Shell Programming, Warehousing
Job Title: Snowflake Administrator
Duration- Fulltime Permanent
Location: Plano, TX Onsite
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.
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.