Snowflake DBA

Clover Solutions - Austin, TX

Full-time

Austin, TX

About the position

The Snowflake DBA position is focused on managing and optimizing Snowflake environments, ensuring secure access and efficient data integration processes. The role requires a strong understanding of Snowflake architecture, hands-on experience with its components, and the ability to automate administrative tasks. The DBA will work closely with multiple teams to prioritize and complete tasks while maintaining high-quality standards.

Responsibilities

• Manage and optimize Snowflake environments for efficient query execution.
• Implement and manage Snowflake RBAC (Role-Based Access Control) for secure access.
• Integrate Snowflake SSO (Single Sign-On) and SCIM (System for Cross-domain Identity Management).
• Automate administrative tasks using Snowflake SQL and scripting languages like Python or Shell scripting.
• Monitor and troubleshoot Snowflake environments, including usage tracking and query profiling.
• Utilize Snowflake's cloning capabilities for databases and schemas.
• Work with data integration tools like Informatica and ADF for ETL/ELT processes.
• Participate in agile sprint teams and manage multiple responsibilities effectively.

Requirements

• Strong overall understanding of Snowflake architecture and its components.
• Hands-on experience with Snowflake objects such as Databases, Procedures, Tasks, and Streams.
• Proven experience in managing Snowflake Warehouses and optimizing performance.
• Proficiency in Snowflake RBAC, including implementation of roles and privileges.
• Experience with integrating Snowflake SSO and SCIM for secure access.
• Familiarity with CI/CD pipelines and version control for managing Snowflake code deployments.
• Experience working with data integration tools like Informatica and ADF.
• Ability to automate administrative tasks using Snowflake SQL and scripting languages.
• Expertise in monitoring and troubleshooting Snowflake environments.
• Strong understanding of Snowflake's security features such as data masking and encryption.
• Technical writing and diagramming skills, including proficiency with modeling tools and Microsoft Office Suite.
• Experience on an agile sprint team.
• Experience with JIRA software.

Nice-to-haves

• Proven ability to write well-designed, testable, efficient code using best software development practices.
• Understanding of security principles as they apply to healthcare data.
• Experience with software components for performance metrics data visualization or business intelligence.
• Excellent oral and written communication skills.
• Ability to manage multiple responsibilities and prioritize conflicting assignments.
• Bachelor's degree in Computer Science, Information Systems, or Business or equivalent experience.
• Prior experience in the Healthcare Industry.
• Prior experience with an HHS agency.
• Prior experience working with PII or PHI data.
• Prior experience working with HL7 data.
• Prior experience with Azure.