Snowflake Admin (AWS + SRE skills + Python) at P99soft · Hyderabad · 10 - 15 years · ₹10L - ₹15L / yr · Profitable · Posted 8 Jan 2024
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.
Shubham Vishwakarma
Full Stack Developer - Averlon
About P99soft
About
Company social profiles
Similar jobs (2)
The recruiter has not been active on this job recently. You may apply but please expect a delayed response.
PythonLocation: Hyderabad / Chennai
Experience: 5+ years
Employment type: Full-time, permanent
Work Hours: General Shift
website: www.amazech.com
Qualifications:
- B.E./B.Tech/M.E./M.Tech in Computer Science, Information Technology, Data Science, or related disciplines.
- Strong academic background with relevant industry experience in Data Engineering and Data Warehousing.
Key Responsibilities:
· Design, develop, and maintain scalable data warehouse solutions using Snowflake.
· Write, optimize, troubleshoot, and enhance Snowflake SQL queries with a focus on performance and scalability.
· Develop and support ETL processes using Talend to ensure reliable and efficient data movement.
· Collaborate with business, analytics, and application teams to enable reporting, dashboards, metrics, and data exploration capabilities.
· Perform data analysis and resolve issues across data ingestion, transformation, and reporting pipelines.
· Debug and troubleshoot Python-based data processing scripts and automation workflows.
· Implement best practices for data quality, testing, deployment, and code reviews.
· Work across UI, API, and Data Warehouse layers to support end-to-end data integration and business requirements.
· Monitor, optimize, and maintain data warehouse performance and operational stability.
· Create and maintain technical documentation, data models, and process workflows.
Required Skills and Experience:
· Strong hands-on expertise in Snowflake Data Warehouse.
· Advanced SQL skills with experience handling large-scale datasets.
· Strong understanding of Data Warehousing concepts, dimensional modelling, and data architecture.
· Hands-on experience with Analytical SQL functions, query tuning, and performance optimization.
· Experience developing and maintaining ETL solutions using Talend.
· Proficiency in Python for scripting, debugging, automation, and data processing.
· Experience integrating UI, API, and Data Warehouse workflows.
· Strong problem-solving and analytical skills.
· Experience with testing, code reviews, and deployment best practices.
· Excellent communication and stakeholder management skills.
Python
Amazon Web Services (AWS)About the Role
You'll be at the forefront of designing and implementing robust data platform solutions that power advanced analytics, AI, and machine learning. Working with modern cloud technologies, you'll build scalable data foundations that enable clients to make smarter, data-driven decisions.
Key Responsibilities
- Build scalable data pipelines using Snowflake, AWS, GCP, and Databricks.
- Design and optimize data models for AI and machine learning workloads.
- Develop reliable data foundations for MLOps, governance, and data lineage.
- Integrate data from multiple sources into modern data platforms.
- Leverage Snowpark ML and Snowflake's native AI capabilities.
- Ensure data platforms are secure, scalable, and high-performing.
What We're Looking For
- 5+ years of hands-on experience with Snowflake.
- Strong proficiency in SQL and Python.
- Experience with AWS, Azure, or GCP.
- Knowledge of cloud storage services such as S3, ADLS, or GCS.
- Strong understanding of Dimensional Modeling and Data Vault.
- Experience with Scala or Java is a plus.
Tech Stack
- Data Warehouse: Snowflake
- Programming: SQL, Python, Scala (Good to Have), Java (Good to Have)
- Cloud: AWS, Azure, GCP
- Storage: S3, ADLS, GCS
- AI/ML: Snowpark ML, MLOps
Perks & Benefits
- Public Speaking & Communication Program
- Mentoring Program with Senior Support Leads
- 360° Progress Reviews
- Weekly Learning Sessions & Guilds
- Paid Certifications
- Hackathons & Innovation Days
- Recognition & Rewards Programs
- Team Socials & Annual Offsites
- Employee Assistance Program (24/7 Wellbeing Support)
The Data People Shaping Tomorrow
Our client helps organizations unlock the power of data through modern cloud, analytics, and AI solutions. We believe in creating an environment where talented technologists can learn, innovate, and make a real impact while building cutting-edge data platforms for global clients. If you're passionate about data engineering and want to work with the latest technologies in AI, cloud, and analytics, we'd love to hear from you.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon