Snowflake DBA RoleOverview: Migrating from Hadoop on-prem to Snowflake environment. Has about 15 TB of data to be migrated, currently building out the infrastructure for the Snowflake environment. Data is consumed by various groups within PenFed, internal "customers" who access the data for internal applications across loans, mortgage, credit, etc. Needs a strong Snowflake DBA with experience implementing a Snowflake environment from an administration perspective (RBAC, monitoring/alerting of queries, integrations, overall system health; disaster recovery; capacity and scalability planning).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 complianceWill participate in backup and disaster recovery strategy--using Time Travel and SnowMirrorMight 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 certificationAny 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 environmentsRole-based access control (using Snowflake RBAC)Query monitoring, troubleshooting, optimizationIntegration monitoring, troubleshootingBackup and disaster recovery (using Snowflake Time Travel/SnowMirror)Capacity planning/scalability forecastingNice to Have:SnowPro CertificationData modeling and schema build for Snowflake