Snowflake Admin

Infosys; Hyderabad; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Infosys is seeking a skilled Snowflake Administrator to manage, monitor, secure, and optimize Snowflake data platform environments in Hyderabad. You will handle accounts, warehouses, RBAC, and security policies to ensure platform stability.

The role includes performance tuning, cost management, data security, and data integration with Snowpipe and bulk loads. You will collaborate with ETL teams and support disaster recovery planning to maintain data integrity.

Qualifications

• Experience administering Snowflake environments, including accounts, warehouses, and RBAC.
• Knowledge of Snowflake security, access controls, and data governance.
• Familiarity with Snowpipe, COPY INTO, and data loading pipelines.

Responsibilities

• Snowflake Administration: Manage Snowflake accounts, warehouses, databases, schemas, and roles. Configure and maintain virtual warehouses (compute layers). Handle user access, RBAC, and security policies. Monitor system usage and ensure platform stability.
• Performance Tuning & Optimization: Optimize Snowflake queries, warehouse sizing, and auto-scaling. Identify and resolve performance bottlenecks. Implement clustering, partitioning, and caching strategies. Monitor query performance using Query Profile and History.
• Cost Management: Track and optimize Snowflake credit usage. Implement cost-saving strategies: auto suspend/resume, right-sizing warehouses, query optimization. Generate usage reports and cost dashboards.
• Data Security & Governance: Implement data security best practices. Role-based access control (RBAC), row-level and column-level security. Manage data encryption and masking policies. Ensure compliance with organizational security standards.
• Data Integration & Pipeline Support: Support data loading using Snowpipe, bulk loads (COPY INTO), and external stages (S3, Azure Blob). Collaborate with ETL teams (Informatica, Airflow, dbt, etc.). Troubleshoot data ingestion and transformation issues. Backup & Recovery: Utilize Time Travel and Fail-safe features. Perform data recovery and disaster recovery planning. Ensure data availability and integrity.
• Monitoring & Troubleshooting: Monitor system health, workloads, and query activity. Troubleshoot: query failures, data load issues, performance degradation. Handle incident management, RCA, and SLA adherence.

Skills

Snowflake administrator

Job description

Primary Skills

Snowflake admin

We are seeking a skilled Snowflake Administrator responsible for managing, monitoring, securing, and optimizing Snowflake data platform environments. The role includes performance tuning, cost optimization, access control, and production support for enterprise data workloads.

Key Responsibilities

• Snowflake Administration: Manage Snowflake accounts, warehouses, databases, schemas, and roles. Configure and maintain virtual warehouses (compute layers). Handle user access, RBAC, and security policies. Monitor system usage and ensure platform stability.
• Performance Tuning & Optimization: Optimize Snowflake queries, warehouse sizing, and auto-scaling. Identify and resolve performance bottlenecks. Implement clustering, partitioning, and caching strategies. Monitor query performance using Query Profile and History.
• Cost Management: Track and optimize Snowflake credit usage. Implement cost-saving strategies: auto suspend/resume, right-sizing warehouses, query optimization. Generate usage reports and cost dashboards.
• Data Security & Governance: Implement data security best practices. Role-based access control (RBAC), row-level and column-level security. Manage data encryption and masking policies. Ensure compliance with organizational security standards.
• Data Integration & Pipeline Support: Support data loading using Snowpipe, bulk loads (COPY INTO), and external stages (S3, Azure Blob). Collaborate with ETL teams (Informatica, Airflow, dbt, etc.). Troubleshoot data ingestion and transformation issues. Backup & Recovery: Utilize Time Travel and Fail-safe features. Perform data recovery and disaster recovery planning. Ensure data availability and integrity.
• Monitoring & Troubleshooting: Monitor system health, workloads, and query activity. Troubleshoot: query failures, data load issues, performance degradation. Handle incident management, RCA, and SLA adherence.