Skip to Content

Senior Snowflake Administrator (Data Platform)

--GTA--

Apply Now!

Job Summary:

We are seeking a highly skilled Senior Snowflake Administrator to manage and optimize our Snowflake cloud data platform. The ideal candidate will have extensive experience in Snowflake implementation, AWS services, PostgreSQL administration, and on-prem to cloud migration. This role involves performance tuning, cost optimization, and collaboration with cross-functional teams to ensure seamless data operations.

Key Responsibilities:

• Snowflake Administration:

  • Administer and manage the Snowflake cloud data platform, ensuring optimal performance, security, and reliability.
  • Implement and configure Snowflake solutions, including data warehousing, data integration, and data migration.
  • Optimize Snowflake performance through query tuning, resource management, and data modeling.
  • Monitor and troubleshoot Snowflake environments to ensure high availability and performance.
  • Implement cost optimization strategies, such as right-sizing virtual warehouses, reducing auto-suspend times, and consolidating workloads.
  • Utilize Snowflake's cost insights to identify and act on opportunities for cost savings.

• AWS Integration:

  • Integrate Snowflake with AWS services such as S3, Glue, Lambda, and EC2 to enhance data workflows and analytics.
  • Design and implement data pipelines using AWS services to facilitate seamless data movement and transformation.

• PostgreSQL Management:

  • Manage PostgreSQL databases, including performance tuning, backups, and recovery.
  • Ensure data integrity and security across PostgreSQL environments.
  • Develop and implement automation scripts for database management tasks.

• Performance Tuning:

  • Optimize query performance by leveraging techniques such as clustering, query pruning, and result caching.
  • Conduct regular performance assessments and implement improvements to enhance query execution times and overall system efficiency.
  • Use Snowflake's Query Acceleration Service and other advanced features to improve performance for complex queries.

• On-Prem to Cloud Migration:

  • Lead and manage the migration of on-premise databases to cloud platforms, ensuring minimal downtime and data integrity.
  • Develop migration strategies and plans, including data transfer, schema conversion, and application integration.
  • Collaborate with stakeholders to ensure seamless transition and address any migration-related issues.

• Collaboration and Support:

  • Collaborate with data engineering, analytics, and IT teams to ensure effective communication and integration.
  • Provide technical support and guidance to team members and stakeholders.
  • Participate in on-call rotations to provide 24/7 support for critical issues.

• Documentation and Best Practices:

  • Maintain comprehensive documentation of Snowflake and PostgreSQL configurations, processes, and procedures.
  • Develop and enforce best practices for database management, security, and compliance.

Requirements:

  • 5+ years of experience as a Snowflake Administrator.
  • Proven experience in implementing and managing Snowflake solutions.
  • Strong knowledge of AWS cloud services and integration.
  • Proficiency in PostgreSQL database administration.
  • Experience with cloud computing platforms (e.g., AWS, Azure, GCP).
  • Excellent problem-solving skills and attention to detail.
  • Strong communication and collaboration skills.
  • Ability to work independently and as part of a team in a fast-paced environment.

Preferred Qualifications:

  • Experience with other cloud platforms like AWS.
  • Knowledge of Python, Terraform or other scripting languages for automation.
  • Familiarity with CI/CD pipelines and DevOps practices.
  • Certification in Snowflake, AWS, or PostgreSQL.

Apply Now!