Snowflake Platform Lead / Senior Administrator

Job Title: Snowflake Platform Lead / Senior Administrator
Department: Platform Health Engineering (Data)
Location: Dallas, TX
Duration: Long Term

Job Description:
Client is looking for an experienced and highly motivated Senior Snowflake Administrator / Platform Lead with deep passion in solutioning complex & large-scale data Infrastructure setups and sustainable Snowflake platform. 
As the Snowflake SME, the primary responsibility of this role is designing and deploying best in class, reliable, scalable and most efficient database platform that will host and maintain massive enterprise-wide data. This person will be working with cross-functional teams across the company to ensure that the platform supports the enterprise data products built with high performance, availability, maintainability standards using current and emerging data technologies.
Reporting to the DevOps Engineering Manager, you will be responsible for handling the implementation and maintenance of a multi-tenant and global Snowflake platform for the data solution and the service capability. Deep hands-on technical knowledge with a strong track record of implementing resilient Snowflake solution. 

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 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 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:
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.
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.