| Snowflake Admin ; Remote at Snowflake, Arizona, USA |
| Email: [email protected] |
| Role: Snowflake Admin Remote Duration: 6+ Months Required Skills: SNOWFLAKE database administration Query optimization Data migration Role Overview: Currently working on role based access controls, defining the roles, ensuring the correct personnel have access to the schemas they leverage. Using Snowflake RBAC service for that. Currently have multiple integrations with security products: Saviynt integrations for role provisioning; Obsidian for audit finding, Ataccama data quality, Ping single sign on. Not expected to build any integrations but work with the teams who do for tracking and troubleshooting. Understanding of what needs to happen from the Snowflake side to whitelist IPs and perform basic security mechanisms. Building alerting dashboards to monitor and show overall health and performance of the environment. All Snowsite dashboards. Currently have an RSA from Snowflake that they'll be working with to build out and have correct alerting in place. Query performance tuning. Will not be expected to take on any query builds themselves, but should be able to troubleshoot, optimize, pull query logs to identify bottlenecks and perform root cause analysis. Wanting to stand up Snowflake Query Profile and Query History for performance analysis--working with Resident Architect to implement best practices. Assist with policies and compliance Will participate in backup and disaster recovery strategy--using Time Travel and SnowMirror Might eventually be pulled into optimizing data modeling and schema design. They have modelers building the table level designs, but could assist with optimization eventually. Not a hard requirement. Will be responsible for capacity planning and forecasting scalability requirements. 1-2 years of Snowflake experience--implementation from an Administrative perspective in an enterprise setting. Ideally will have a Snowpro certification Any other DBA background will work here--coming from a more traditional Oracle/SQL DBA role and having shifted into Snowflake in the last 1-2 years. Interview Process: 1 round, situational type questions (i.e. "If you need to identify the highest running query in the past 10 days, what steps would you take to locate it") Must Haves: 1-2 years' experience in the implementation and administration of Snowflake environments Role-based access control (using Snowflake RBAC) Query monitoring, troubleshooting, optimization Integration monitoring, troubleshooting Backup and disaster recovery (using Snowflake Time Travel/SnowMirror) Capacity planning/scalability forecasting Nice to Have: SnowPro Certification Data modeling and schema build for Snowflake -- Dharma Veer US IT Recruiter Intellisoft Technologies INC 11494 Luna Road, Ste 280 Farmers Branch, TX -75234 Phone: (972) 756 - 1212 Ext 128 Confidentiality & Disclaimer: The information contained in this electronic message along with any attachments is private and confidential and is intended for the exclusive use of the addressee(s). If you are not the intended recipient and/or have received this communication in error, please notify the sender immediately and then delete from system and destroy all copies of this message along with any attachments. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited and may be unlawful. The contents of this email are subject to any terms and conditions agreed between Intellisoft Technologies inc and the recipient, and do not necessarily represent the views, opinions or policies of Intellisoft Technologies inc -- Keywords: information technology Texas Snowflake Admin ; Remote [email protected] |
| [email protected] View all |
| Fri Jul 19 02:06:00 UTC 2024 |