Sr. Snowflake Lead DBA

2 weeks ago

Jersey City, United States eTeam Full time

Must have 10+ Years of experience into IT and Should be a Lead Snowflake Admin. Please share the below skill matrix while sharing submission without missing.

Snowflake Object creation and Management Snowflake Connectivity UDF, Snowpipe User Management & RBAC Workload Analysis & Optimization Secure views, Account level Security Python, Azure, Unix Shell script, JavaScript

Must Have:

  • Snowflake Datawarehouse Administration
  • Snowflake Utilities SnowSql, SnowPipe
  • Time travel, Fail safe, Clustering, Cloning, Metadata management
  • Scripting Java Script, Unix shell Scripting, Basic of Python
  • Cloud Platform Aws Storage (S3), Azure Blob Storage and Containers
  • Snowflake Unique features use case and implementation (Time Travel, Un-drop, Zero Copy Clone) as per the requirement
  • Worked on thorough testing and implementation of Dev-ops Pipeline for Objects Promotion using GitHub, Jenkins
  • Working with Snowflake Support, handling P1 , P2 incidents, Engaging Support for technical issue on all the Snowflake Accounts under organization including Readers Account
Good to Have:
  • Expertise in SQL, Snowflake procedures, UDFs using JavaScript
  • utomation- CI/CD using Jenkins Pipeline (Code promotion), Github for version control
  • Scheduling- ESP Jobs Scheduling, AWX Ansible Tower
  • Familiarity with JIRA, ServiceNow / GLPI
  • Experience with ITIL process, Change management, Incident handling, JIRA , Development using Agile methodology
Responsibilities
  • Creation & Management of Snowflake Objects like Database/Schema /Tables/Views/MVs /Pipes, Streams, Task Creation & Management
  • ccount level Objects like Warehouse, Resource Monitor, Network Policies, Integration (Storage, Notification), Shares Connectivity issues resolution wrt ODBC, JDBC, Python Connecters.
  • Snowflake UDF using SQL, Python, JavaScript and Java and help them to tune their SQL/UDF.
  • Create replication and failover groups and restore data from Fail safe or from time travel dat
  • Troubleshoot data loading issues, connection issues and Snow pipe issues
  • User management, Implementation of RBAC best practices
  • ccess Rights Management, experience with privileged roles Accountadmin, Sysadmin and Securityadmin
  • nalysing and Planning the Workload, Warehouses with Multi-clusters, Scaling policies and Application Specific warehouse creation and management for efficient Compute consumption
  • Generate, manage and analyze Cost/credits Consumption reports and identify cost optimization areas
  • ETL batch Support and issues resolution
  • PII data management using Dynamic data masking, Secure views implementation, managing Account level Security using network policies, implementing Azure ADSSO for user Authentication
  • Secure Data Sharing using managed accounts Creation, Reader Account provisioning and managing resource monitor, credit Quota, IP whitelisting
  • In depth knowledge of Micro partition, Caching, Table Clustering, Recommendation for Cluster key, Analysing the SQLs using query profile, identifying gaps, patterns and trends, recommendation to BI team based upon the analysis
Working experience in writing Procedures (PLSQL, Javascript) / UDF and calling them from Unix shell Scripts using SnowSql to automate day to day DBA BAUs

  • Sr. Service Practice Manager

    1 week ago

    New York City, NY, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team.AS A SR. SERVICES PRACTICE MANAGER YOU WILL :Report to a Practice Director on the Americas team, aligned to a specific regionBe aligned to Sales District Managers and Account Executives in your regionBe responsible for both services sales enablement/execution and services delivery success for your accounts,...

  • Sr. Service Practice Manager

    5 days ago

    New York City, NY, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team.AS A SR. SERVICES PRACTICE MANAGER YOU WILL :Report to a Practice Director on the Americas team, aligned to a specific regionBe aligned to Sales District Managers and Account Executives in your regionBe responsible for both services sales enablement/execution and services delivery success for your accounts,...

  • Sr. Service Practice Manager

    2 days ago

    New York City, NY, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team.AS A SR. SERVICES PRACTICE MANAGER YOU WILL :Report to a Practice Director on the Americas team, aligned to a specific regionBe aligned to Sales District Managers and Account Executives in your regionBe responsible for both services sales enablement/execution and services delivery success for your accounts,...

  • Solutions Architect

    4 days ago

    Ohio City, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. Snowflake Professional Services is the implementation and strategy experts for the Snowflake platform. We engage with customers at all phases of the customer journey to optimize, accelerate, and achieve business outcomes. Our teams of Solutions Architects demonstrate technical leadership everyday by writing...

  • Senior Sql Database Administrator

    3 weeks ago

    Culver City, United States Motion Recruitment Full time

    Our Client, An Education Focused Tech Company, is looking for a Sr. SQL Server DBA / BI Engineer Data Warehouse Engineer to join their team in Culver City, CA!Hybrid Schedule 2-3 days a week in the officeAs the SQL DBA you will be alongside the Sr. Developer on a team of 15 to support a Data warehousing project. They currently don’t have one and will be...

  • Senior Sql Database Administrator

    3 weeks ago

    Culver City, United States Motion Recruitment Full time

    Our Client, An Education Focused Tech Company, is looking for a Sr. SQL Server DBA / BI Engineer Data Warehouse Engineer to join their team in Culver City, CA!Hybrid Schedule 2-3 days a week in the officeAs the SQL DBA you will be alongside the Sr. Developer on a team of 15 to support a Data warehousing project. They currently don’t have one and will be...

  • Senior Sql Database Administrator

    3 weeks ago

    Culver City, United States Motion Recruitment Full time

    Our Client, An Education Focused Tech Company, is looking for a Sr. SQL Server DBA / BI Engineer Data Warehouse Engineer to join their team in Culver City, CA!Hybrid Schedule 2-3 days a week in the officeAs the SQL DBA you will be alongside the Sr. Developer on a team of 15 to support a Data warehousing project. They currently don’t have one and will be...

  • Sr. Power BI developer

    1 month ago

    Jersey City, United States Coforge Full time

    Need : Sr. Power BI developerLocation : Raleigh, NC / Jersey city, NJ (Hybrid)Duration: FulltimeQualification requirements9+ years of experience in Business Analytics tools developing Reporting and Dashboards5+ years in Reporting and Analytics using Power BI, Data Modeling5+ years in database technologies and strong SQL query writing skillsExperience working...

  • Sr. Power BI developer

    4 weeks ago

    Jersey City, United States Coforge Full time

    Need : Sr. Power BI developerLocation : Raleigh, NC / Jersey city, NJ (Hybrid)Duration: FulltimeQualification requirements9+ years of experience in Business Analytics tools developing Reporting and Dashboards5+ years in Reporting and Analytics using Power BI, Data Modeling5+ years in database technologies and strong SQL query writing skillsExperience working...

  • Sr. Power BI developer

    4 weeks ago

    Jersey City, United States Coforge Full time

    Need : Sr. Power BI developerLocation : Raleigh, NC / Jersey city, NJ (Hybrid)Duration: FulltimeQualification requirements9+ years of experience in Business Analytics tools developing Reporting and Dashboards5+ years in Reporting and Analytics using Power BI, Data Modeling5+ years in database technologies and strong SQL query writing skillsExperience working...

  • Senior Sql Database Administrator

    5 days ago

    Culver City, United States Motion Recruitment Full time

    Our Client, An Education Focused Tech Company, is looking for a Sr. SQL Server DBA / BI Engineer Data Warehouse Engineer to join their team in Culver City, CA! If the following job requirements and experience match your skills, please ensure you apply promptly. Hybrid Schedule 2-3 days a week in the office As the SQL DBA you will be alongside the Sr....

  • Sr. Java Spark Developer

    5 days ago

    Jersey City, United States Diverse Lynx Full time

    Job Title: Sr. Java Spark Developer - 10+ Years Exp Location: Jersey City, NJ - Hybrid Project (3 days onsite) Duration: Long Term Project Job Description: As a core technical contributor, you are responsible for conducting critical technology solutions across multiple technical areas within various business functions in support of the firm's business...

  • Sr. Java Spark Developer

    2 weeks ago

    Jersey City, United States Diverse Lynx Full time

    Job Title: Sr. Java Spark Developer - 10+ Years Exp Location: Jersey City, NJ - Hybrid Project (3 days onsite) Duration: Long Term Project Job Description: As a core technical contributor, you are responsible for conducting critical technology solutions across multiple technical areas within various business functions in support of the firm's business...

  • Technical Support Manager

    6 days ago

    Texas City, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. Snowflake Support is committed to providing high-quality resolutions to help deliver data-driven business insights and results. We are a team of subject matter experts collectively working toward our customers' success. We form partnerships with customers by listening, learning and building connections. ...

  • SQL Server DBA

    2 weeks ago

    Texas City, United States eTeam Full time

    looking for Sr. SQL Server DBA with good exp in performance tuning + AG + Replication experience. Job Description: As a Senior SQL Server Database Administrator, you will play a critical role in ensuring the optimal performance, reliability, and efficiency of our SQL Server environments. Your primary responsibilities will revolve around performance...

  • SQL Server DBA

    4 days ago

    Texas City, United States eTeam Full time

    looking for Sr. SQL Server DBA with good exp in performance tuning + AG + Replication experience. Job Description: As a Senior SQL Server Database Administrator, you will play a critical role in ensuring the optimal performance, reliability, and efficiency of our SQL Server environments. Your primary responsibilities will revolve around performance...

  • Senior Support Account Manager

    2 weeks ago

    Texas City, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. Snowflake's Support team is expanding! We are looking for a Senior Support Account Manager to join our team. As a Senior Support Account Manager, you have developed an excellent balance of business and technical skills that allows you to operate at multiple levels within our customer's business environment...

  • Sr. Mulesoft Tech Lead

    2 weeks ago

    Jersey City, United States Diverse Lynx Full time

    Sr. Mulesoft Tech Lead / Tech Lead - Integration (Mulesoft)// NJ // FTE Job Title: Sr. Mulesoft Tech Lead / Tech Lead - Integration (Mulesoft) Job Type: FTE (Full Time ) Location: NJ (Remote with may have 10-20 % travel at client place) Salary- $140 K-150 K+ Benefits Birlasoft Expenses Paid Don't submit west coast candidate Key Responsibilities: We are...

  • Oracle DBA with PostgreSQL

    2 weeks ago

    Culver City, United States Teamware Solutions Inc Full time

    Job DescriptionJob DescriptionTitle; Oracle DBA with PostgreSQLJob location:Culver City, CAExperience: 8-10 YearsContact: kamala.b@twsol.comMandatory skills:EDB Postgres DBA, Oracle, and MS-SQL DBAJob description: Bachelor's degree in technical or STEM major 5+ years hands-on experience EDB Postgres /Oracle and MS-SQL Database Administration. Proven...

  • Sr. Mainframe Lead

    2 weeks ago

    Jersey City, United States Hudson Data Full time

    Job Title: Sr. Mainframe Developer Location: Trenton, NJ Duration: Long Term 40 Hrs Job Description: Hybrid position - 3 days remote, 2 days onsite. Note this is a SENIOR position . Candidate should be a Current Hands-on Developer with some lead experience. The ideal candidate can : *Clearly and effectively communicate both...