Job details

Senior Snowflake Database Administrator

Company OverviewDomo puts data to work to help everyone multiply their impact. Domo gives every kind of user real-time insights they can act on, with secure, easy-to-use, AI-powered data experience that drive a culture of data curiosity.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 experienceLOCATION: American Fork, UTBENEFITS: https://www.domo.com/company/careers/cultureDomo is an equal opportunity employer.

Average salary estimate

Estimate provided by employer

$105000 / ANNUAL (est.)

min

max

$85K

$125K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About Senior Snowflake Database Administrator, Domo

If you're a tech-savvy individual with a passion for data, Domo is on the lookout for a Senior Snowflake Database Administrator to join our dynamic team in American Fork, UT! Your expertise will play a crucial role in managing vital components of our SaaS platform, where you'll work hands-on with Snowflake, AWS, and Azure to deliver exceptional data solutions. In this role, you will dive into Snowflake operations, overseeing databases, warehouses, and schemas, while ensuring secure access for users through effective management of roles and permissions. Performance optimization will be in your skillset as you monitor database performance and tune queries to enhance efficiency. Beyond configuration and administration, your day-to-day will also include troubleshooting database issues, collaborating with data engineers, and implementing robust security measures compliant with industry standards. Domo fosters a culture of data curiosity; hence, your strong analytical and problem-solving skills, coupled with your proficiency in SQL and Python, will allow you to thrive as you innovate within a fast-paced environment. With over five years of experience with Snowflake and a solid understanding of cloud technologies, you will play a significant part in nesting data into actionable insights. By the end of the day, you’ll contribute to a culture within Domo where data helps everyone multiply their impact. Are you ready to take the next step in your career with us?

Frequently Asked Questions (FAQs) for Senior Snowflake Database Administrator Role at Domo

What are the primary responsibilities of a Senior Snowflake Database Administrator at Domo?

As a Senior Snowflake Database Administrator at Domo, your key responsibilities include managing Snowflake operations, designing and maintaining databases, and ensuring secure user access. You'll also monitor performance, optimize configurations, implement data loading processes, integrate with cloud services, and enforce data integrity through effective modeling and engineering.