Snowflake Database Administrator


Role Snowflake Database Administrator
Experience 03 - 05 Years
Location Chennai (India) - Hybrid
Salary As per Industry
Job Description:

We seek immediate joiners for the full-time Snowflake DBA (Database Administrator) position. Responsible for managing and optimizing databases' performance, security, and reliability within the Snowflake Data Cloud platform.

Database Setup and Configuration:

1. Configuring warehouses, databases, and other Snowflake objects to meet specific project or organizational requirements.

2. Ensuring optimal configuration settings for performance and cost-efficiency.

Performance Monitoring and Tuning:

1. Monitoring the performance of Snowflake environments and executing performance tuning strategies to optimize query execution and resource utilization.

2. Analyzing query performance and optimizing SQL queries and warehouse sizes for efficiency.

Data Security and Compliance:

1. Implementing and managing security measures within Snowflake, including data encryption, access controls, and network policies to protect sensitive information.

2. Ensuring compliance with data protection regulations and organizational data governance policies.

Data Management and Operations:

1. Managing data storage within Snowflake, including data loading, transformation, and extraction processes.

2. Implementing data retention policies and managing data lifecycle within the platform.

Backup and Disaster Recovery:

1. Although Snowflake provides automatic backups and failover capabilities, the DBA is responsible for planning and managing disaster recovery strategies and data retention policies.

Cost Management:

1. Monitoring and optimizing Snowflake credit usage to control costs without compromising performance.

2. Advising on cost-effective use of Snowflake features and resources.

User Management and Support:

1. Managing user accounts, roles, and access privileges to ensure secure and appropriate access to the database.

2. Providing technical support and training to users on how to effectively use Snowflake features.

Collaboration and Documentation:

1. Collaborating with data engineers, analysts, and IT teams to support data-related activities.

2. Documenting database schemas, configurations, procedures, and best practices.

Required Skills and Qualifications

Technical Proficiency: Strong understanding of Snowflake’s architecture, including virtual warehouses, databases, roles, and security features.

SQL Expertise: Proficient in SQL for querying and managing Snowflake databases.

Performance Optimization: Skills in query performance tuning and resource optimization in a cloud environment.

Data Security: Knowledge of best practices in data security, encryption, and compliance within cloud environments.

Cloud Computing: Familiarity with cloud services, particularly those related to data storage and computation, and an understanding of cloud cost management.

Problem-Solving: Ability to troubleshoot and resolve database issues efficiently.

Communication: Excellent communication skills for collaborating with team members and explaining technical concepts to non-technical stakeholders.

Education and Certification: A bachelor’s degree in Computer Science, Information Technology, or related field is typically required.
Certifications specific to Snowflake, such as the Snowflake SnowPro Core Certification, can be highly beneficial.

Note: Only shortlisted candidates will be contacted for further steps in the selection process.