What are the responsibilities and job description for the Snowflake Admin position at Swanktek Inc?
Job description:
Roles & Responsibilities and Skillset:
Snowflake Administrator (Snowflake Admin): Responsible for the day-to-day administration, security, performance, monitoring, and operational support of the Snowflake environment.
1. User & Access Management
- Create and manage users, roles, and role hierarchies.
- Implement Role-Based Access Control (RBAC).
- Grant and revoke privileges on databases, schemas, tables, views, stages, and warehouses.
- Manage service accounts and application integrations.
- Ensure compliance with least-privilege access principles.
2. Security Administration
- Configure Single Sign-On (SSO) and Multi-Factor Authentication (MFA).
- Manage network policies and IP listing.
- Implement data masking and row-level security policies.
- Manage encryption and key management requirements.
- Perform periodic access reviews and audits.
3. Warehouse Administration
- Create and manage virtual warehouses.
- Monitor warehouse utilization and concurrency.
- Configure auto-suspend and auto-resume settings.
- Optimize warehouse sizing and scaling.
- Monitor credits consumption and cost optimization.
4. Monitoring & Performance Management
- Monitor query performance and execution plans.
- Identify long-running and resource-intensive queries.
- Troubleshoot warehouse contention issues.
- Review query history and resource monitors.
- Implement performance tuning recommendations.
5. Data Management
- Manage databases, schemas, tables, views, streams, and tasks.
- Support data loading and unloading processes.
- Manage Time Travel and Fail-safe configurations.
- Oversee cloning and data sharing activities.
- Validate data replication and synchronization processes.
6. Backup, Recovery & Business Continuity
- Configure and monitor replication.
- Support disaster recovery testing.
- Recover data using Time Travel.
- Implement failover procedures.
- Maintain recovery documentation.
7. Cost Management
- Monitor Snowflake credit consumption.
- Configure resource monitors and alerts.
- Analyze usage trends.
- Recommend cost-saving measures.
- Generate usage and chargeback reports.
8. Incident & Support Management
- Troubleshoot production issues.
- Support ETL/ELT platforms such as HVR, Informatica, SnapLogic, and Fivetran.
- Coordinate with application teams during incidents.
- Perform root cause analysis (RCA).
- Maintain operational runbooks and SOPs.
9. Change & Release Management
- Deploy Snowflake objects across environments.
- Support CI/CD implementations.
- Execute release activities.
- Validate post-deployment functionality.
- Maintain version control standards.