Eateam
Sr. Snowflake Lead DBA
Eateam, Cary, North Carolina, United States, 27518
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 3Must Have:
Snowflake Datawarehouse AdministrationSnowflake Utilities SnowSql, SnowPipeTime travel, Fail safe, Clustering, Cloning, Metadata managementScripting - Java Script, Unix shell Scripting, Basic of PythonCloud Platform - Aws Storage (S3), Azure Blob Storage and ContainersSnowflake Unique features use case and implementation (Time Travel, Un-drop, Zero Copy Clone) as per the requirementWorked on thorough testing and implementation of Dev-ops Pipeline for Objects Promotion using GitHub, JenkinsWorking with Snowflake Support, handling P1 , P2 incidents, Engaging Support for technical issue on all the Snowflake Accounts under organization including Readers AccountGood to Have:
Expertise in SQL, Snowflake procedures, UDF's using JavaScriptAutomation- CI/CD using Jenkins Pipeline (Code promotion), Github for version controlScheduling- ESP Jobs Scheduling, AWX Ansible TowerFamiliarity with JIRA, ServiceNow / GLPIExperience with ITIL process, Change management, Incident handling, JIRA , Development using Agile methodologyResponsibilities
Creation & Management of Snowflake Objects like Database/Schema /Tables/Views/MV's /Pipes, Streams, Task Creation & ManagementAccount 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 dataTroubleshoot data loading issues, connection issues and Snow pipe issuesUser management, Implementation of RBAC best practicesAccess Rights Management, experience with privileged roles Accountadmin, Sysadmin and SecurityadminAnalysing and Planning the Workload, Warehouses with Multi-clusters, Scaling policies and Application Specific warehouse creation and management for efficient Compute consumptionGenerate, manage and analyze Cost/credits Consumption reports and identify cost optimization areasETL batch Support and issues resolutionPII data management using Dynamic data masking, Secure views implementation, managing Account level Security using network policies, implementing Azure ADSSO for user AuthenticationSecure Data Sharing using managed accounts Creation, Reader Account provisioning and managing resource monitor, credit Quota, IP whitelistingIn 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 analysisWorking experience in writing Procedures (PLSQL, Javascript) / UDF and calling them from Unix shell Scripts using SnowSql to automate day to day DBA BAU's
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 3Must Have:
Snowflake Datawarehouse AdministrationSnowflake Utilities SnowSql, SnowPipeTime travel, Fail safe, Clustering, Cloning, Metadata managementScripting - Java Script, Unix shell Scripting, Basic of PythonCloud Platform - Aws Storage (S3), Azure Blob Storage and ContainersSnowflake Unique features use case and implementation (Time Travel, Un-drop, Zero Copy Clone) as per the requirementWorked on thorough testing and implementation of Dev-ops Pipeline for Objects Promotion using GitHub, JenkinsWorking with Snowflake Support, handling P1 , P2 incidents, Engaging Support for technical issue on all the Snowflake Accounts under organization including Readers AccountGood to Have:
Expertise in SQL, Snowflake procedures, UDF's using JavaScriptAutomation- CI/CD using Jenkins Pipeline (Code promotion), Github for version controlScheduling- ESP Jobs Scheduling, AWX Ansible TowerFamiliarity with JIRA, ServiceNow / GLPIExperience with ITIL process, Change management, Incident handling, JIRA , Development using Agile methodologyResponsibilities
Creation & Management of Snowflake Objects like Database/Schema /Tables/Views/MV's /Pipes, Streams, Task Creation & ManagementAccount 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 dataTroubleshoot data loading issues, connection issues and Snow pipe issuesUser management, Implementation of RBAC best practicesAccess Rights Management, experience with privileged roles Accountadmin, Sysadmin and SecurityadminAnalysing and Planning the Workload, Warehouses with Multi-clusters, Scaling policies and Application Specific warehouse creation and management for efficient Compute consumptionGenerate, manage and analyze Cost/credits Consumption reports and identify cost optimization areasETL batch Support and issues resolutionPII data management using Dynamic data masking, Secure views implementation, managing Account level Security using network policies, implementing Azure ADSSO for user AuthenticationSecure Data Sharing using managed accounts Creation, Reader Account provisioning and managing resource monitor, credit Quota, IP whitelistingIn 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 analysisWorking experience in writing Procedures (PLSQL, Javascript) / UDF and calling them from Unix shell Scripts using SnowSql to automate day to day DBA BAU's