Snowflake Administrator

India- Remote**About Us**
Affine is a global leader in professional services and solutions at the forefront of AI, data engineering, and cloud technologies. With our distributed team of over 500 analytics professionals across North America, Europe, and Asia, we are dedicated to enabling global enterprises to transform and innovate through the power of AI (Artificial Intelligence), data engineering, and cloud technologies.

We offer exciting career opportunities for professionals seeking to make a significant impact. Our diverse team represents a rich tapestry of talent, expertise, and cultural backgrounds. As an Affine employee, you'll be part of a dynamic and inclusive work environment that values collaboration, creativity, and continuous learning. Joining Affine means immersing yourself in a world of cutting-edge projects and solutions. We work closely with global clients spanning various sectors, including manufacturing, gaming, consumer packaged goods (CPG), media and entertainment, travel, and technology. As a member of our team, you'll have the opportunity to leverage your skills and contribute to transformative projects that shape industries and redefine the future.

We believe in investing in our people and nurturing their growth. Affine is dedicated to your professional development and offers a range of learning opportunities, mentorship programs, and career advancement paths. We also encourage innovation and thought leadership through our strong connections with esteemed institutions like UC Berkeley and premier Indian Institutes of Technology (IITs), ensuring that you stay at the forefront of industry advancements. At Affine, we foster a culture of collaboration, where ideas are valued, and teamwork is celebrated. As you work alongside some of the brightest minds in the industry, you'll be inspired to push boundaries, solve complex challenges, and make a lasting impact on the world.

**Snowflake Administrator Acquired skills**:

- Identify the various aspects of compute and storage management
- Illustrate administrative tasks within the detailed architecture of Snowflake
- Review Snowflake best practices & considerations for managing load operations and performance
- Describe data governance in Snowflake, including column-level data security using secure views and
dynamic data masking features
- Manage multiple accounts across the Organization
- Describe the DDL operations that work with fundamental database objects
- Discuss transaction and concurrency models and DML considerations
- Employ recovery methods and agile development with Time Travel & Cloning
- Implement advanced techniques for Snowflake performance-tuning methodologies
- Design and develop secure access to objects in Snowflake with Role-Based Access Control (RBAC)
- Recommend the Snowflake best practices for management, monitoring, and optimization
- Use data replication for data sharing across accounts and for failover scenarios
- Share data securely both within and without your organization

**Detailed Snowflake Architecture and Overview**
- Snowflake Technical Overview
- Overview of Three-Tiered Architecture

**Compute Management**
- Scaling Virtual Warehouses Up & Out
- Creating and Managing Virtual Warehouses

**Job Requirement**

**Mandatory Skills**:

- Compute & Storage Management, Load Operations Management, Snowflake Architecture, Data Governance, Column-Level Data Security, Dynamic Data Masking, DDL/DML Operations, Transaction & Concurrency Models, Recovery Methods, Agile Development, Time Travel, Role-Based Access Control (RBAC), Data Replication, Secure Data Sharing

**Good to Have Skills**:

- Talend Admin Experience, Cost Optimization