Sr. Snowflake DBA consultant

Company Description Predactica™ supports organizations in their digital transformation journey by delivering product solutions, consulting, and training focused on cloud migration, data science, and big data. The company collaborates with leading technology partners to provide best-of-breed solutions tailored to diverse business needs. Predactica™ works across industries to help clients modernize their data platforms, optimize performance, and unlock actionable insights. Team members have opportunities to work with modern architectures, cutting-edge tools, and complex data environments while contributing to impactful client outcomes.
Role Description This is a remote, contract role for a Sr. Snowflake DBA consultant. The consultant will be responsible for administering and optimizing Snowflake environments, including user management, security configuration, and resource monitoring. Typical day-to-day activities include designing and implementing database schemas, tuning queries and workloads, and managing data loading, transformation, and retention policies. The role involves troubleshooting performance and reliability issues, supporting replication and data-sharing strategies, and collaborating with data engineers and architects on best practices. The consultant will also help define standards, documentation, and governance for Snowflake usage across client projects.
Qualifications
Strong skills in Database Administration and Databases, with hands-on experience managing Snowflake in production environments.
Advanced Snowflake administration certification (SnowPro Advanced: Administrator certification).
Experience with Database Design, including schema modeling, data partitioning, and performance-oriented architecture.
Proficiency in Troubleshooting complex database, query, and connectivity issues in cloud data platforms.
Knowledge of Replication, data sharing, and migration strategies across environments and regions.
Deep understanding of SQL and familiarity with Snowflake-specific features (virtual warehouses, time travel, micro-partitioning).
Experience working in cloud ecosystems such as AWS, Azure, or GCP, including security and networking concepts.
Background collaborating with data engineers, BI developers, and architects in agile or iterative delivery models.
Ability to document standards, procedures, and best practices clearly and effectively.
Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent practical experience.
Snowflake or cloud platform certifications are beneficial.

Work arrangement
Yes