n
JOB DESCRIPTION ? Snowflake Admin
n
n
Snowflake Administrator responsible for support and maintenance of data lakes, data warehouse and databases.
n
Knowledge of Snowflake Database Engineering.
n
User provisioning and access management (preferably automated)
n
Monitor and manage data platform costs and credit consumption
n
Recommend and develop platform automation
n
Provision, configure, and operate tooling to support Snowflake
n
Create an information architecture for organizing data
n
Manage and maintain proper governance and security
n
Support developers and users needing guidance or troubleshooting
n
Manage monitoring and alerting on Snowflake data platform and tooling
n
Provide routine reporting on pipeline activity and success rates
n
Configure storage locations and security
n
Advise on warehouse sizing and performance
n
Platform connectivity troubleshooting and resolution
n
Setup network connectivity between Snowflake and data source(s)
n
Deployment of DDL and DML statements to PROD
n
Optimize compute with scale out and scale in planning.
n
Implement security, roles, users, and privileges using RBAC model.
n
Implement data pipelines using SnowSQL.
n
Strong DBA administration skills for all DB maintenance plan activities including backups, indexing, integrity, and consistency checks, etc.
n
Proactively identify, design, and implement process improvements like automating manual processes, optimizing data flow, increasing scalability etc.
n
knowledge in Snowflake security features including access control, authentication, authorization, encryption, masking, secured views etc.
n
Skilled in relational and dimensional modeling.
n
Experience with Snowflake and its utilities i.e., SnowSQL, SnowCD, Snowpipe etc. ? SQL ? Unix Shell Scripting
n
n
Experience Required
n
8 – 10 Years
n
Location
n
India
n
Roles & Responsibilities
n
n
Being a custodian of production environment, ensure and perform deployments with validation through established operations gating criteria and checklist.
n
Assess whether best practices are followed for project deployments by reviewing the schema, code etc.
n
Implement best practices to operate a highly performant Snowflake environment.
n
Conduct DB maintenance plan activities including backups, indexing, integrity, and consistency checks,
n
Proactively identify, design, and implement process improvements like automating manual processes, optimizing data flow, increasing scalability,
n
Review the Snowpipe ingestion pattern leveraged by projects from an operations acceptance point of view.
n
Participate in Service Transition sessions to take handover from projects to Operations team.
n
n
Expertise & Qualification
n
n
Knowledge of Snowflake Database Engineering,
n
DBA background ? SQL/Snowflake/Teradata with 4-5 years of experience
n
n
Role Purpose
n
The purpose of this role is to provide significant technicalexpertise in architecture planning and design of the concerned tower(platform, database, middleware, backup etc) as well as managing itsday-to-day operations
n
Do
n
n
Provide adequate support in architecture planning, migration& installation for new projects in own tower (platform/dbase/middleware/ backup)n
n
Lead the structural/ architectural design of a platform/middleware/ database/ back up etc. according to various systemrequirements to ensure a highly scalable and extensiblesolution
n
Conduct technology capacity planning by reviewing the currentand future requirements
n
Utilize and leverage the new features of all underlyingtechnologies to ensure smooth functioning of the installed databases andapplications/ platforms, as applicable
n
Strategize & implement disaster recovery plans and createand implement backup and recovery plans
n
n
n
Manage the day-to-day operations of the towern
n
Manage day-to-day operations by troubleshooting any issues,conducting root cause analysis (RCA) and developing fixes to avoidsimilar issues.
n
Plan for and manage upgradations, migration, maintenance,backup, installation and configuration functions for own tower
n
Review the technical performance of own tower and deploy ways toimprove efficiency, fine tune performance and reduce performancechallenges
n
Develop shift roster for the team to ensure no disruption in thetower
n
Create and update SOPs, Data Responsibility Matrices, operationsmanuals, daily test plans, data architecture guidance etc.
n
Provide weekly status reports to the client leadership team,internal stakeholders on database activities w.r.t. progress, updates,status, and next steps
n
Leverage technology to develop Service Improvement Plan (SIP)through automation and other initiatives for higher efficiency andeffectiveness
n
n
n
n
n
n
Team Managementn
n
Resourcingn
n
Forecast talent requirements as per the current and future businessneeds
n
Hire adequate and right resources for the team
n
n
n
n
n
n
n
Train direct reportees to make right recruitment and selectiondecisions
n
n
n
Talent Managementn
n
Ensure 100% compliance to Wipro?s standards of adequateonboarding and training for team members to enhance capability &effectiveness
n
Build an internal talent pool of HiPos and ensure their careerprogression within the organization
n
n
n
n
n
Promote diversity in leadership positions
n
n
n
Performance Managementn
n
Set goals for direct reportees, conduct timely performance reviewsand appraisals, and give constructive feedback to direct reports.
n
Ensure that organizational programs like Performance Nxt are wellunderstood and that the team is taking the opportunities presented bysuch programs to their and their levels below
n
n
n
Employee Satisfaction and Engagementn
n
Lead and drive engagement initiatives for the team
n
Track team satisfaction scores and identify initiatives to buildengagement within the team
n
n
n
n
n
Proactively challenge the team with larger and enriching projects/initiatives for the organization or team
n
n
n
Exercise employee recognition and appreciation
n
n
n
Stakeholder Interaction
n
nnnnnnnnnnnnnnnnnnnnnnnnnnn
n
Stakeholder Type
n n
Stakeholder Identification
n n
Purpose of Interaction
n
n
Internal
n n
Technology Solutions Group, BU Teams, Different Infrastructureteams
n n
Understanding requirements, planning and status updates,maintenance and back up, issue resolution etc.
n
n
IRMC, QA
n n
Guidance on risk mitigation and quality standards
n
n
External
n n
Clients
n n
Understanding requirements, planning and status updates,maintenance and back up, issue resolution etc.
n
n
Vendors/ Manufacturers
n n
Development and deployment of platforms, applications, databasesetc.
n
n
n
n
Display
n
n
Lists the competencies required to perform this role effectively:
n
n
Functional Competencies/ Skilln
n
Technical Knowledge ? Knowledge of own tower (platform,application, database etc) – Expert
n
Domain Knowledge ? Understanding of IT industry and itstrends ? Competent to Expert
n
n
n
n
nnnnnnnnnnnnnnnnnnnnnnn
n
Competency Levels
n
n
Foundation
n n
Knowledgeable about the competency requirements. Demonstrates (inparts) frequently with minimal support and guidance.
n
n
Competent
n n
Consistently demonstrates the full range of the competencywithout guidance. Extends the competency to difficult and unknownsituations as well.
n
n
Expert
n n
Applies the competency in all situations and is serves as a guideto others as well.
n
n
Master
n n
Coaches others and builds organizational capability in thecompetency area. Serves as a key resource for that competency and isrecognised within the entire organization.
n
n
n
n
Behavioral Competenciesn
n
Managing Complexity
n
Client centricity
n
Execution Excellence
n
Passion for Results
n
Team Management
n
Stakeholder Management
n
n
n
n
n
Deliver
n
nnnnnnnnnnnnnnnnnnn
n
No.
n n
Performance Parameter
n n
Measure
n
n
1.
n n
Operations of the tower
n n
SLA adherence
n
Knowledge management
n
CSAT/ Customer Experience
n
Identification of risk issues and mitigation plans
n
Knowledge management
n
n
2.
n n
New projects
n n
Timely delivery
n
Avoid unauthorised changes
n
No formal escalations
n
n
Snowflake