snowflake administrator,DBA

Role &
Snowflake DBA
Job Title: Snowflake DBA(Lead)-Expereince in lead atleast 2 years
Work Mode: Remote role
No of Positions: 2

Role: Snowflake Admin/DBA -with RBAC experience & Cortex AI experience 

Responsibilities:

• Implementing security controls, including role-based access control (RBAC), datemarking, encryption, and related capabilities.
• Building Stream lit applications within Snowflake and working with Cortex AI.
• Cost& Compute Management Warehouse Sizing: Tuning virtual warehouse clusters, adjusting auto-suspend/resume times, and setting up scaling policies to balance query speed with credit consumption.
• Resource Monitors: Creating budgets and alerts to monitor account-level and warehouse-level usage, preventing unintended budget overruns.
• Security &Governance Access Control: Designing and maintaining Role-Based Access Control (RBAC) hierarchies, assigning privileges, and troubleshooting permission issues.
• Data Privacy: Enforcing network policies, Row-Level Security, Column-Level Security (masking policies), and data classification tagging.
• Performance Tuning Query Optimization: Investigating sluggish workloads using tools like ACCOUNT_USAGE views and the Snowflake Query Profile.
• Data Layout: Optimizing table structures by configuring clustering keys, materialized views, and the Search Optimization Service.
• Backup & Disaster Recovery Data Lifecycle: Managing Time Travel retention periods and Fail-safe configurations.
• Replication: Setting up database replication and failover across multiple cloud regions or accounts to maintain high availability.
• Deployment &Operations Environment Management: Overseeing database migration to Snowflake, object cloning, and promoting DDL changes across DEV, QA, and PROD environments.
• Automation: Automating administrative tasks and alerts using Python or shell scriptsresponsibilities

Preferred candidate profile

Perks and benefits