Snowflake Admin DBA With RBAC Experience
@ Jobs via Dice

Hybrid
$120,000
Hybrid
Full Time
Posted 24 days ago

Your Application Journey

Personalized Resume
Apply
Email Hiring Manager
Interview

Email Hiring Manager

XXXXXXXXXX XXXXXXXXXXX XXXXXXX******* @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

Review Snowflake architecture and administration guides.
Practice SQL query tuning and execution plan analysis.
Learn scripting automation with Python and Bash.
Familiarize with Terraform for infrastructure management.

Behavioral Questions

Describe handling production database crises.
Explain collaboration with cross-functional teams.
Discuss security compliance experiences.
Share examples of process automation success.

Frequently Asked Questions