Note: The job is a remote job and is open to candidates in USA. Glansa Associates is seeking a Snowflake Administrator to manage and maintain Snowflake environments across development, testing, and production. The role focuses on administration, security, performance optimization, data integration, recovery, automation, monitoring, documentation, and collaboration with technical and business teams.
Responsibilities
- Administer and maintain Snowflake environments across development, testing, and production
- Manage Snowflake users, roles, privileges, warehouses, databases, schemas, and resource monitors
- Implement and maintain role-based access control (RBAC) and security policies
- Monitor Snowflake usage, performance, storage, and compute consumption
- Perform query and warehouse performance tuning and optimize resource utilization
- Configure and manage virtual warehouses , auto-suspend, auto-resume, scaling, and workload management
- Manage data loading and unloading processes using Snowflake-supported tools and integrations
- Configure Snowpipe, Streams, Tasks , and other Snowflake features where required
- Monitor and troubleshoot failed queries, data pipelines, connectivity issues, and performance problems
- Implement backup, recovery, and disaster-recovery strategies using Time Travel, Fail-safe, cloning , and related Snowflake capabilities
- Manage Snowflake integrations with cloud storage such as AWS S3, Azure Blob Storage, or Google Cloud Storage
- Support data migration and environment refresh activities
- Implement monitoring, alerting, and operational best practices
- Maintain security, compliance, and data governance standards
- Automate administrative tasks using SQL, Python, Shell scripting , or similar technologies
- Maintain technical documentation, operational procedures, and access-control documentation
- Collaborate with data engineers, developers, DevOps teams, security teams, and business stakeholders
Skills
- Strong hands-on experience with Snowflake administration
- Good knowledge of Snowflake architecture and cloud data warehousing concepts
- Strong knowledge of SQL and database administration concepts
- Experience managing users, roles, privileges, warehouses, databases, and schemas
- Strong understanding of RBAC and Snowflake security
- Experience with performance monitoring and query optimization
- Knowledge of Snowflake resource monitors and cost optimization
- Experience with Snowflake Time Travel, Fail-safe, zero-copy cloning, and data recovery
- Understanding of Snowflake Streams, Tasks, and Snowpipe
- Experience with cloud platforms such as AWS, Azure, or GCP
- Familiarity with Git and scripting/automation
- Experience with AWS S3, Azure Blob Storage, or Google Cloud Storage
- Knowledge of ETL/ELT tools such as Informatica, Matillion, dbt, or similar
- Experience with Airflow or other workflow orchestration tools
- Knowledge of Terraform or Infrastructure as Code (IaC)
- Familiarity with CI/CD pipelines
- Experience implementing Snowflake security features such as network policies, masking policies, row access policies, and secure data sharing
- Snowflake certification is an advantage
- Experience with data governance, auditing, and compliance requirements
Company Overview