Sr Snowflake Lead DBA

Cary, North Carolina

EA Team Inc.
Job Expired - Click here to search for similar jobs
Must have 10+ Years of experience into IT and Should be a Lead Snowflake Admin. Please share the below skill matrix while sharing submission without missing.

Skill
Mandatory
Proficiency Level (1-5)

Snowflake Object creation and Management
Yes
4

Snowflake Connectivity
Yes
4

UDF, Snowpipe
Yes
4

User Management & RBAC
Yes
4

Workload Analysis & Optimization
Yes
4

Secure views, Account level Security
Yes
4

Python, Azure, Unix Shell script, JavaScript
Yes
3

Must Have:

Snowflake Datawarehouse Administration

Snowflake Utilities SnowSql, SnowPipe

Time travel, Fail safe, Clustering, Cloning, Metadata management

Scripting - Java Script, Unix shell Scripting, Basic of Python

Cloud Platform - Aws Storage (S3), Azure Blob Storage and Containers

Snowflake Unique features use case and implementation (Time Travel, Un-drop, Zero Copy Clone) as per the requirement

Worked on thorough testing and implementation of Dev-ops Pipeline for Objects Promotion using GitHub, Jenkins

Working with Snowflake Support, handling P1 , P2 incidents, Engaging Support for technical issue on all the Snowflake Accounts under organization including Readers Account

Good to Have:

Expertise in SQL, Snowflake procedures, UDF's using JavaScript

Automation- CI/CD using Jenkins Pipeline (Code promotion), Github for version control

Scheduling- ESP Jobs Scheduling, AWX Ansible Tower

Familiarity with JIRA, ServiceNow / GLPI

Experience with ITIL process, Change management, Incident handling, JIRA , Development using Agile methodology

Responsibilities

Creation & Management of Snowflake Objects like Database/Schema /Tables/Views/MV's /Pipes, Streams, Task Creation & Management

Account level Objects like Warehouse, Resource Monitor, Network Policies, Integration (Storage, Notification), Shares Connectivity issues resolution wrt ODBC, JDBC, Python Connecters.

Snowflake UDF using SQL, Python, JavaScript and Java and help them to tune their SQL/UDF.

Create replication and failover groups and restore data from Fail safe or from time travel data

Troubleshoot data loading issues, connection issues and Snow pipe issues

User management, Implementation of RBAC best practices

Access Rights Management, experience with privileged roles Accountadmin, Sysadmin and Securityadmin

Analysing and Planning the Workload, Warehouses with Multi-clusters, Scaling policies and Application Specific warehouse creation and management for efficient Compute consumption

Generate, manage and analyze Cost/credits Consumption reports and identify cost optimization areas

ETL batch Support and issues resolution

PII data management using Dynamic data masking, Secure views implementation, managing Account level Security using network policies, implementing Azure ADSSO for user Authentication

Secure Data Sharing using managed accounts Creation, Reader Account provisioning and managing resource monitor, credit Quota, IP whitelisting

In depth knowledge of Micro partition, Caching, Table Clustering, Recommendation for Cluster key, Analysing the SQLs using query profile, identifying gaps, patterns and trends, recommendation to BI team based upon the analysis

Working experience in writing Procedures (PLSQL, Javascript) / UDF and calling them from Unix shell Scripts using SnowSql to automate day to day DBA BAU's

Date Posted: 20 May 2024
Job Expired - Click here to search for similar jobs