WHO WE ARE:

WE ARE A TEAM OF HIGHLY MOTIVATED DESIGNERS AND ENGINEERS THAT HELP OUR CLIENTS AT EVERY PHASE OF THEIR CLOUD JOURNEY.  IF IT TOUCHES THE CLOUD, INVOLVES DATA, OR LIVES AS AN APPLICATION, WE DO IT.  

WHO YOU ARE:

SELF-MOTIVATED AND DRIVEN WITH A DESIRE TO FIND SOLUTIONS AND MAKE AN IMPACT. YOU LOOK TO DIG DEEPER BEYOND THE SURFACE LEVEL OF A JOB PROFILE RESEARCHING MARKET TRENDS, DOMAIN TECHNOLOGY, AND SEEK OUT INFORMATION TO HAVE A SOLID UNDERSTANDING OF THE BUSINESS. YOU ASK FOR FEEDBACK AND WANT TO GROW AND DEVELOP IN YOUR CAREER.

WE ARE SEEKING A SNOWFLAKE ADMINISTRATOR  WHO WILL PLAY A CRITICAL ROLE IN BUILDING AND MAINTAINING SNOWFLAKE IN AN AWS ENVIRONMENT. THE CANDIDATE WILL PLAY A CENTRAL CRITICAL ROLE FOR IDENTIFYING AND PERFORMING CORE DATABASE ADMINISTRATION FOR THE SNOWFLAKE ENVIRONMENT.

CORE RESPONSIBILITIES:

• MUST HAVE VERY STRONG  EXPERIENCE WITH ACCOUNT_ADMIN ROLE

• STRONG EXPERIENCE WITH ROLES, USERS, DATA SHARES,  ACCOUNTS, PII , CLEAN ROOM, SCHEMAS  AND NATIVE SNOWFLAKE

• PERFORM ADMINISTRATIVE TASKS LIKE BUT NOT LIMITED TO, DDL CREATION, USER CREATION, ACCOUNT LEVEL PARAMETER CHANGES ETC WITHIN SNOWFLAKE DATABASE.

• RESPONSIBLE TO INTEGRATE SNOWFLAKE DATABASE WITH SAML OR OPENID PROVIDER FOR AUTHENTICATION

• CREATE SNOWFLAKE UTILIZATION AND CAPACITY PLAN FOR GENERAL HOUSEKEEPING AS WELL AS FOR PEAK PERIOD.

• CREATE AND MANAGE MULTIPLE ACCOUNTS ACROSS THE ORGANIZATION.

• PRACTICAL KNOWLEDGE OF TIME TRAVEL & CLONING

• BE ABLE TO DESIGN AND DEVELOP SECURE ACCESS TO OBJECTS IN SNOWFLAKE WITH ROLE-BASED ACCESS CONTROL (RBAC)

• ABLE TO PROVIDE RECOMMENDATION ON SNOWFLAKE BEST PRACTICES FOR MANAGEMENT, MONITORING, AND OPTIMIZATION

• GOOD UNDERSTANDING OF DATA REPLICATION FOR DATA SHARING ACROSS ACCOUNTS AND FOR FAILOVER SCENARIOS

• DIAGNOSE DATABASE PROBLEMS AND IMPLEMENT SOLUTIONS.

• EXPERIENCE WORKING WITH SNOWFLAKE SUPPORT FOR RAISING TICKETS AND TRIAGING OUTAGES

• BE ABLE TO REVIEW DDLS AND APPLY STANDARDS.

• GOOD UNDERSTANDING OF SNOWFLAKE ODBC, JDBC DRIVERS AS WELL AS SNOWSQL IN TERMS OF USAGE AS WELL AS TROUBLESHOOTING ANY ISSUES.

• ABILITY TO MAINTAIN AND FOLLOW A RUN BOOK WITH HAS DOCUMENTATION RELATED ALL THE TASKS AS WELL AS DATABASE STANDARDS

QUALIFICATIONS:

• BACHELOR’S DEGREE OR 5-10 YEARS OF EXPERIENCE WORKING IN THE FIELD OF IT, SPECIFICALLY AS DATABASE ADMINISTRATOR

• 3+ YEARS EXPERIENCE AS SNOWFLAKE DBA. THIS SHOULD BE A COMPLETE HANDS-ON EXPERIENCE.

• DEVELOP, BUILD & MAINTAIN MISSION CRITICAL CENTRALIZED DATA PLATFORM USING SNOWFLAKE

• DIAGNOSE AND TROUBLESHOOT SNOWFLAKE DATABASE ERRORS

• WORK WITH MULTIPLE INTERNAL USER GROUPS INCLUDING ANALYTICS AND DATA SCIENCE

• IMPLEMENT SNOWFLAKE USER /QUERY LOG ANALYSIS AND ALERTS

• DEMONSTRATED PROFICIENCY OF INDEX DESIGN, QUERY PLAN OPTIMIZATION AND ANALYSIS REQUIRED

• USER SECURITY AUDITING

• IMPLEMENT/SUPPORT AUTOMATION FOR PRODUCTION DEPLOYMENT IN SNOWFLAKE

• ACTIVELY WORK WITH SNOWFLAKE SUPPORT FOR RAISING SUPPORT TICKETS AND TRIAGING OUTAGES

• CREATE SNOWFLAKE UTILIZATION AND CAPACITY PLAN

• TUNE THE DATABASE TO IMPROVE SNOWFLAKE QUERIES

• PROACTIVELY IDENTIFY, DESIGN, AND IMPLEMENT PROCESS IMPROVEMENTS LIKE AUTOMATING MANUAL PROCESSES, OPTIMIZING DATA FLOW, INCREASE SCALABILITY ETC.

• STRONG KNOWLEDGE ON SNOWFLAKE SECURITY FEATURES INCLUDING AUTHENTICATION, AUTHORIZATION, ENCRYPTION, MASKING, SECURED VIEWS ETC.