Lead Snowflake Admin
Remote
6-12 Months
Video Interview
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
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 task
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
Thanks & Regards
Aman Sharma
Direct Number:408-459-7174
e-mail : [email protected]
Hangout: [email protected]
Mississauaga, Canada
Job Type: Fixed term contract
Contract length: 12 months
Schedule:
Ability to commute/relocate:
Experience:
Speak with the employer
+91 +916399121513
Attributions : Sous la responsabilité du directeur régional, la personne titulaire de l’emploi réalise des recherches, des études, des observations...
Apply For This JobJob Description Temporary Part Time – Montreal Part Distribution Center Location: Pointe Claire, Quebec Department: Montreal Shipping and Receiving Target...
Apply For This Jobbr{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> Vous avez envie d’évoluer au sein d’un hôtel qui est au cœur des attractions locales...
Apply For This Jobbr{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> Business Equipment and Computer Applications MS Excel MS Windows MS Word MS Office Specific Skills...
Apply For This JobWhat This Role Involves: As a Credit Counsellor, you are passionate about providing support, care, and guidance to clients who...
Apply For This JobPosition: Head of People Reports to: CEO Works closely with: VP, Finance & Operations Location: Toronto Practice Better is changing...
Apply For This Job