Job description
Snowflake SRE JD
Your Role Accountabilities
• Primarily responsible for administrating Snowflake environments on AWS
• Identify, tune, and fix the performance issues on priority.
• Diagnose and troubleshoot Snowflake related errors and work with team to raise support tickets, follow ups and help to resolve them.
• Implement security, roles, users and privileges using the best practices.
• Provide database/objects recovery as need on basis.
• Design, identify and implement high performing and highly available data warehouse solutions.
• Create database, schema, tables, views, data sharing
• Create Snowflake utilization and capacity/cost plans, identifies, and provide solution for abnormalities.
• Proactively identify, design, and implement process improvements like automating manual processes
• Stay up-to-date with the latest features and best practices in Snowflake administration
• Follow existing database runbooks, create and maintain new runbooks for new and improved processes
• Provide 24X7 On-call support by participating in rotation schedule.
Qualifications & Experiences
• Bachelor’s degree in computer science, information systems, or information technology.
• 10+ years of experience as a database administrator.
• Minimum 5+ years of hands-on administration experience, from setting up the Snowflake environments to successfully administering it (AWS preferred)
• Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting, Python etc.
• Some experience with AWS with knowledge of S3, EC2, VPC, IAM, Security, Networking etc.
• Ability and experience with the development of processes and procedures to standardize Database configuration
• Extensive experience with implementation and maintenance of Disaster Recovery and High availability.
• Ability to work on unusually complex technical problems and provide solutions that are highly innovative and ingenious.
• Ability to provide technical documentation and project plans for technical staff members.
• Excellent communication, presentation, and customer relationship skills.
• Excellent organizational and time management skills to handle multiple tasks simultaneously
• Ability to provide 24/7 support.