Snowflake Administrator

Location: Dallas, TX (Day 1 Onsite)
NEED LOCLS ONLY

W2

Experience: 10+ years IT experience (5+ in DevOps/DBA)

Job Description

Toyota Financial Services is seeking an experienced Snowflake Administrator to manage and optimize Snowflake environments across sub-production, production, and global deployments. The ideal candidate will bring deep expertise in Snowflake architecture, performance tuning, automation, security, and AWS integration.

Roles & Responsibilities

• Administer Snowflake environments (sub-prod, prod, global) including databases, schemas, tables, views, data shares, external stages, and storage integrations.

• Maintain and implement platform design standards, naming conventions, sizing, optimization, automation, security, and best practices.

• Configure and manage Streams, Tasks, Clones, Time Travel, multi-cluster warehouses, and scaling strategies for different workloads.

• Implement role-based security: manage users, roles, privileges, AD groups, SSO/Okta integration, access control, secured views, row access policies, and masking policies.

• Optimize performance using materialized views, clustering, micro-partitioning, and caching. Troubleshoot and tune queries.

• Automate DBA tasks using Python, Shell scripting, SnowSQL executed via Amazon EC2. Integrate with AWS services like S3, EC2, EKS.

• Support integrations with Tableau, SAS, Python, and other JDBC connections.

• Perform data sharing, account replication, and disaster recovery exercises.

• Implement CI/CD pipelines and schema change processes.

• Evaluate new Snowflake features via POC/POT and adopt as applicable.

• Collaborate with Data Engineers, Architects, Modelers, and Information Security teams to maintain standards and best practices.

• Partner with Data Science and Analysis teams to provide Snowflake-based solutions to business problems.