Snowflake Database Admin

Skills

Description

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

Responsibilities

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