Lead Administrator

Lead Administrator

 

\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
1. Provide adequate support in architecture planning, migration& installation for new projects in own tower (platform/dbase/middleware/ backup)\n
   \n
   1. 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
   2. Conduct technology capacity planning by reviewing the currentand future requirements
   \n
   3. Utilize and leverage the new features of all underlyingtechnologies to ensure smooth functioning of the installed databases andapplications/ platforms, as applicable
   \n
   4. Strategize & implement disaster recovery plans and createand implement backup and recovery plans
   \n
   \n
\n
2. Manage the day-to-day operations of the tower\n
   \n
   1. Manage day-to-day operations by troubleshooting any issues,conducting root cause analysis (RCA) and developing fixes to avoidsimilar issues.
   \n
   2. Plan for and manage upgradations, migration, maintenance,backup, installation and configuration functions for own tower
   \n
   3. Review the technical performance of own tower and deploy ways toimprove efficiency, fine tune performance and reduce performancechallenges
   \n
   4. Develop shift roster for the team to ensure no disruption in thetower
   \n
   5. Create and update SOPs, Data Responsibility Matrices, operationsmanuals, daily test plans, data architecture guidance etc.
   \n
   6. Provide weekly status reports to the client leadership team,internal stakeholders on database activities w.r.t. progress, updates,status, and next steps
   \n
   7. Leverage technology to develop Service Improvement Plan (SIP)through automation and other initiatives for higher efficiency andeffectiveness
   \n
   \n
\n

\n

 

\n

\n
1. Team Management\n
   \n
   1. Resourcing\n
      \n
      1. Forecast talent requirements as per the current and future businessneeds
      \n
      2. 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
1. Talent Management\n
   \n
   1. Ensure 100% compliance to Wipro?s standards of adequateonboarding and training for team members to enhance capability &effectiveness
   \n
   2. 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
1. Performance Management\n
   \n
   1. Set goals for direct reportees, conduct timely performance reviewsand appraisals, and give constructive feedback to direct reports.
   \n
   2. 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
2. Employee Satisfaction and Engagement\n
   \n
   1. Lead and drive engagement initiatives for the team
   \n
   2. 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
1. Exercise employee recognition and appreciation
\n

\n

 

\n

Stakeholder Interaction

\n

 

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

\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/ Skill\n
  \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

 

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

\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 Competencies\n
  \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

 

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

\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