Job Description:

– 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

– User management, Implementation of RBAC best practices

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

– Analyzing 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

Desired :

Cloud environment (Azure is a +)

Performance monitoring, tuning and troubleshooting (SQL Server 2005/2008/2012/2014) (Azure SQL  Databases)

Experience with distributed databases

MongoDB related projects

MDM experience