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.
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 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, and Masking policy.
Support 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 are any.
Provide a Snowflake solution to the business problem as applicable.
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.
Never miss an opportunity! Create an alert based on the job you applied for.
