What are the responsibilities and job description for the Snowflake Database Architect, DBA - Only W2 position at CBTS?
Role: Snowflake DBA
Location: Cincinnati, Ohio – Onsite, 4 days work from office
TECHNICAL SKILLS
Must Have
- Python
- Very Strong Snowflake Experience
- Very Strong SQL
- SnowPro Certification
Position Overview
Key Responsibilities
Performance & Optimization
- Analyze and optimize complex SQL queries and workloads to ensure efficient resource utilization and cost management.
- Monitor and tune Snowflake compute resources (warehouses) for optimal performance.
- Implement best practices for data modeling, partitioning, clustering, and indexing.
Security & Governance
- Manage user roles, access controls, and data masking policies to ensure compliance with internal and external security standards.
- Collaborate with InfoSec and compliance teams to enforce data governance policies.
- Audit and monitor data access and usage patterns to detect anomalies and ensure data protection.
Database Hygiene & Maintenance
- Maintain clean and organized schemas, tables, and views across environments.
- Implement automated routines for purging obsolete data, archiving, and metadata management.
- Ensure consistency and reliability of data pipelines and integrations with Snowflake.
Collaboration & Leadership
- Work closely with data engineers, analysts, and business stakeholders to support data initiatives.
- Provide guidance and mentorship to junior DBAs and data team members.
- Stay current with Snowflake features, updates, and industry trends to continuously improve platform capabilities.
Qualifications
- Proven experience as a Snowflake DBA or in a similar role managing cloud-based data platforms.
- Strong proficiency in SQL and performance tuning techniques.
- Deep understanding of Snowflake architecture, including virtual warehouses, storage layers, and caching mechanisms.
- Experience with data security frameworks and compliance standards.
- Familiarity with ETL/ELT tools and data integration frameworks.
- Excellent problem-solving, communication, and documentation skills.
Preferred Skills
- SnowPro Certification (Core or Advanced).
- Experience with automation tools (e.g., dbt, Terraform).
- Knowledge of other cloud platforms (AWS) and their integration with Snowflake.
- Scripting experience in Python or Shell for administrative tasks.