Senior Snowflake Database Administrator

Domo
US - Utah - American Fork
January 16, 2025

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 SUMMARYThis 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, UTBENEFITS: ***/company/careers/culture

Domo is an equal opportunity employer.
• LI-JC1
• LI-Onsite

Read the full job description and apply online on the recuiter's web-site

Related Job Postings

Travel Cath Lab Technologist 2,338 per week

Focus Staff

US - UT - UT - Salt Lake City
January 29, 2025

Focus Staff is seeking a travel Cath Lab Technologist for a travel job in Salt Lake City, Utah. & Requirements • Specialty: Cath Lab Technologist • Discipline: Allied Health Professional • Start Date: 02/17/2025 • Duration: 13 weeks • 40 hours per week • Shift: 10 hours, days • Employment Type:...

Find Jobs Hiring Now Near You!

Get Jobilize Job Search Mobile App Now