What are the responsibilities and job description for the Sr. Snowflake Lead DBA position at Eateam?
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.
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
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
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Sr. Snowflake Lead DBA?
Sign up to receive alerts about other jobs on the Sr. Snowflake Lead DBA career path by checking the boxes next to the positions that interest you.
