Snowflake Admin DBA With RBAC Experience @ Jobs via Dice
placeHybrid
attach_money $120,000
businessHybrid
scheduleFull Time
Posted 24 days ago
Your Application Journey
Interview
Email Hiring Manager
******* @infojunction.com
Recommended after applying
Job Details
Snowflake Admin DBA With RBAC Experience
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Info Junction LLC, is seeking a highly skilled and experienced Snowflake Database Administrator with over 10 years of experience to manage, optimize, and secure their cloud data platform.
Snowflake Administration & Optimization
- Administer and manage the Snowflake cloud data warehouse environment including provisioning, configuration, monitoring, and maintenance.
- Optimize virtual warehouses for performance, scalability, and cost efficiency.
- Perform query performance tuning and schema optimizations.
- Monitor Snowflake credit usage and implement cost control strategies.
- Manage data loading, ingestion (Snowpipe) and unloading processes.
- Utilize features such as Zero-Copy Cloning, Time Travel, and Fail-safe.
Security & Role-Based Access Control (RBAC)
- Design, implement, and maintain a robust RBAC model following least privilege.
- Manage user accounts, roles, and access privileges for secure data access.
- Configure advanced security features like Data Masking, Row Access Policies, and network controls.
- Integrate with identity providers for SSO and SCIM.
- Conduct regular access reviews and security audits to ensure compliance (GDPR, HIPAA, SOX).
Operations & Support
- Troubleshoot and resolve production issues related to performance and connectivity.
- Collaborate with Data Engineers, Data Scientists, and Business Intelligence teams.
- Automate tasks using scripting languages like Python, Bash, and SnowSQL, and IaC tools (Terraform).
- Maintain comprehensive documentation for schemas, configurations and security practices.
- Participate in on-call rotation for production support.
Key skills/competency
- Snowflake
- RBAC
- SQL
- Performance Tuning
- Data Governance
- Security
- Snowpipe
- Python
- Bash
- Terraform
How to Get Hired at Jobs via Dice
🎯 Tips for Getting Hired
- Research Info Junction LLC: Understand company culture and recent news.
- Customize your resume: Highlight Snowflake and RBAC experience.
- Showcase technical expertise: Detail SQL and performance tuning skills.
- Prepare for technical queries: Practice scenarios relevant to cloud data platforms.
📝 Interview Preparation Advice
Technical Preparation
circle
Review Snowflake architecture and administration guides.
circle
Practice SQL query tuning and execution plan analysis.
circle
Learn scripting automation with Python and Bash.
circle
Familiarize with Terraform for infrastructure management.
Behavioral Questions
circle
Describe handling production database crises.
circle
Explain collaboration with cross-functional teams.
circle
Discuss security compliance experiences.
circle
Share examples of process automation success.
Frequently Asked Questions
What key Snowflake skills are needed for Snowflake Admin DBA With RBAC Experience at Info Junction LLC?
keyboard_arrow_down
How important is RBAC experience for the Snowflake Admin DBA role at Info Junction LLC?
keyboard_arrow_down
What technical tools should candidates proficient in for this role at Info Junction LLC?
keyboard_arrow_down
What kind of work environment can one expect for Snowflake Admin DBA With RBAC Experience?
keyboard_arrow_down
How does Info Junction LLC manage security compliance for its Snowflake environments?
keyboard_arrow_down