Senior Snowflake Database Administrator

COMPANY OVERVIEW

Domo's AI and Data Products Platform lets people channel AI and data into innovative uses that deliver a measurable impact. Anyone can use Domo to prepare, analyze, visualize, automate, and build data products that are amplified by AI.

POSITION SUMMARY

This role is required to be in office 5 days a week.

We are seeking a highly skilled Snowflake Database Administrator (DBA) to join our team and manage critical components of our SaaS platform, leveraging the power of AWS and Azure, and data pipelines in Snowflake. The ideal candidate will have a deep understanding of Snowflake's architecture, data modeling, and performance optimization techniques, coupled with a strong grasp of cloud technologies.

This role requires a strong blend of technical expertise, problem-solving skills, and a passion for data. You'll be working in a fast-paced environment, collaborating with cross-functional teams to deliver innovative data solutions.

KEY RESPONSIBILITIES

• Manage all Snowflake operations inside of Domo’s SaaS environment
  • Snowflake Administration:
    • Design, implement, and maintain Snowflake databases, warehouses, and schemas.
    • Manage user accounts, roles, and permissions to ensure secure access to data.
    • Monitor database performance and identify optimization opportunities.
    • Tune queries and optimize database configurations to improve performance.
    • Implement data loading and ETL processes using Snowflake's powerful data ingestion capabilities.
  • Cloud Integration:
    • Integrate Snowflake with AWS and Azure services to leverage their capabilities.
    • Configure and manage cloud resources (VMs, storage, networks) to support Snowflake.
    • Implement automated deployment and provisioning processes using infrastructure as code (IaC) tools.
    • Monitor cloud costs and optimize resource utilization.
  • Data Modeling and Engineering:
    • Design and implement efficient data models to support business requirements.
    • Create and maintain data pipelines to ensure data integrity and consistency.
    • Optimize data storage and indexing strategies to improve query performance.
    • Collaborate with data engineers and analysts to design and implement data solutions.
  • Security and Compliance:
    • Implement robust security measures to protect sensitive data.
    • Monitor and enforce security policies and procedures.
    • Conduct regular security audits and vulnerability assessments.
    • Ensure compliance with industry standards and regulations, including GDPR, HIPAA, and SOC 2.
  • Performance Optimization:
    • Analyze query performance and identify bottlenecks.
    • Tune queries and optimize database configurations to improve performance.
    • Implement caching strategies to reduce query execution time.
    • Monitor resource utilization and adjust resource allocations as needed.
  • Backup and Recovery:
    • Implement and maintain backup and recovery strategies.
    • Test recovery procedures to ensure data integrity.
    • Implement disaster recovery plans to minimize downtime in case of failures.
  • Troubleshooting and Support:
    • Diagnose and resolve database issues.
    • Provide technical support to users.
    • Collaborate with other teams to ensure smooth operations.

JOB REQUIREMENTS

• 5+ years of experience administering Snowflake.
• Strong understanding of Snowflake architecture, features, and best practices.
• Proficiency in SQL and Python.
• Experience with data modeling and ETL processes.
• Knowledge of cloud platforms (AWS and Azure) and their services.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Experience with infrastructure as code (IaC) tools like Terraform or CloudFormation.
• Understanding of security best practices and compliance standards.
• This role requires daily in-office attendance
• Availability to provide on-call support and handle out-of-band requests.
• Familiarity with a wide range of database administration tools
• Bachelor's degree in computer science, information systems or comparable experience

LOCATION: American Fork, UT

BENEFITS: https://www.domo.com/company/careers/culture

Domo is an equal opportunity employer.

#LI-JC1

#LI-Onsite