Snowflake Developer/DBA
This role is for one of Weekday's clients
Salary range: Rs 1200000 - Rs 2200000 (ie INR 12 -22 LPA)
Min Experience: 4+ years
Location: Pune
JobType: full-time
Requirements
50% DBA & 50% Development
We are looking for an experienced Snowflake Database Administrator to manage and support production, development, and QA databases, ensuring maximum availability for various applications
The role includes core DBA responsibilities across System Administration, Database Administration, Performance Management, and Reporting.
Perform capacity planning, performance monitoring, tuning, and issue resolution
Manage database operations for high availability and reliability
Interact directly with customers/vendors-requiring strong communication and presentation skills
Mentor junior team members and contribute to team growth
Support 24/7 operations and extended hours as needed
Technical Skills -Mandatory Skills
Automation & Pipeline Management
Automate data transformations using Streams and Tasks
Manage continuous ingestion using Snowpipe
Implement data pipelines using SnowSQL
Create Azure DevOps (AZDO) CI/CD pipelines
Drive process improvements (automation, optimization, scalability)
Design and implement AI agents in Snowflake for automating data workflows and operational tasks.
Manage and optimize agent-driven processes using Snowpark and AI/ML frameworks for intelligent data operations.
Security & Access Management
Manage users and security configurations
Implement RBAC (roles, users, privileges)
Apply Snowflake security features:
o Access Control, Authentication & Authorization
o Encryption and Secured Views
o Masking Policies, Object Tagging, Row-Level Security
Configure Network Policies (IP whitelisting, secure access)
Performance & Optimization
Tune performance of virtual warehouses
Optimize compute through scale-out and scale-in strategies
Design and manage clustering keys for large tables
Troubleshoot and resolve performance bottlenecks
Cost Management & Governance
Monitor and manage compute, storage, and data sharing costs
Optimize costs for Time Travel and data retention
Set credit quotas to control budget usage
Data Engineering & Integration
Integrate and transform structured and unstructured data
Strong understanding of:
o Data Lakes
o Data Warehousing
o Data Sharing concepts
Expertise in relational and dimensional data modeling
Database Administration (DBA)
Create and manage databases, tables, views, and data sharing
Handle performance, user access, and security
Troubleshoot database issues
Perform testing of cloud-based database solutions
High Availability & Disaster Recovery
Configure replication and failover across regions/cloud providers (Azure)
Ensure high availability and DR readiness
Monitoring & Operations
Monitor system performance and workloads
Manage warehouse utilization
Provide continuous operational support and issue resolution
Scripting & Development
Develop SQL scripts and stored procedures
Write Unix Shell scripts
Automate administrative tasks using Python via Snowflake APIs
Experience with Snowflake tools (SnowSQL, SnowCD, etc.)
Good to have: Teradata Experience
Behavioral Skills
Strong technical, analytical, and problem-solving abilities
Ability to work under pressure and adapt to change
Willingness to work in shifts and extended hours
Self-motivated and result-oriented
Strong team player with cross-functional collaboration ability
Excellent communication skills (team, stakeholders, customers)
Ability to work independently and drive issues to closure
Proactive in risk identification and escalation
Effective multitasking with consistent delivery of high-quality work
Strong learning mindset (eagerness to learn)
Must-have skills
Snowflake, DBA, developer
Good-to-have skills
Database Administrator, Design, Teradata
