Snowflax Admin

Rcinfotech; Atlanta (GA); On-site; USD 130,000 - 210,000; Full time

Job summary

Rcinfotech in Atlanta is seeking a Snowflake SRE to administer Snowflake environments on AWS and ensure high performance and availability. You will diagnose issues, tune performance, and work with the team to raise and track support tickets.

Responsibilities include implementing security models, creating databases, schemas, and data sharing, plus cost planning and automation of manual tasks. A 24/7 on-call rotation is required.

Qualifications

• Bachelor's degree in CS/IS/IT.
• 10+ years of experience as a database administrator.
• Minimum 5+ years of hands-on Snowflake administration on AWS.
• Experience with scripting (Unix shell, Python).
• AWS knowledge including S3, EC2, VPC, IAM, Networking, Security.
• Disaster Recovery and High Availability experience.
• Ability to document processes and project plans for team use.
• Excellent communication, presentation, and customer relationship skills.
• Willingness to provide 24/7 on-call support.

Responsibilities

• Admin Snowflake environments on AWS.
• Identify, tune, and fix performance issues on priority.
• Diagnose Snowflake errors and manage tickets with team follow-ups.
• Implement security, roles, users, and privileges.
• Create database objects and data sharing.
• Plan Snowflake utilization and cost, identify abnormalities.
• Automate manual processes to improve efficiency.
• Provide 24/7 on-call support.

Skills

Communication skills

Time management

On-call support

Customer relationship

Troubleshooting

Education

Bachelor's degree in computer science, information systems, or information technology

Tools

Unix shell scripting

Python

AWS (S3, EC2, VPC, IAM, Security, Networking)

Job description

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.
• Providedatabase/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.