Jobs
>
Jersey City

    Sr. Snowflake Lead DBA - Jersey City, United States - eTeam

    eTeam
    eTeam Jersey City, United States

    6 days ago

    eTeam background
    Description

    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
  • LasikPlus

    Patient Services Professional

    2 days ago

    LasikPlus Manhattan, United States

    **We are Growing Join us at LasikPlus, LVI & TLC** · Are you looking for an exciting and rewarding career opportunity at a second-generation family-owned business working alongside world-class Ophthalmologists and Optometrists with a leading provider of laser vision correction in ...

  • Mercer F&B, LLC DBA: Sartiano's

    Ird Server

    1 week ago

    Mercer F&B, LLC DBA: Sartiano's New York, United States

    **Server (Breakfast/Lunch/Dinner)** · **Job Description**: · **Responsible to**: · Management · **About** · Sartiano's was born from the Tuscan heart and soul of Italy. Business leader, Restaurateur, and Lifestyle Architect Scott Sartiano introduces his latest concept, appropriat ...

  • Restore Hyper Wellness L5 Be Well

    Registered Nurse

    4 days ago

    Restore Hyper Wellness L5 Be Well Edgewater, United States

    **Benefits**: · - Competitive salary · - Employee discounts · - Flexible schedule · - Paid time off · **Registered Nurse (Holistic/Wellness/Retail/IV Drip)** · Do you have a passion for nursing but also enjoy a less chaotic environment? Do you love helping people and want a regul ...

  • Burroughs, Inc.

    Middleware Developer and Digital Architec

    1 week ago

    Burroughs, Inc. Elmhurst, United States

    **Description** · 1 · Through its 135 years of innovation and service excellence Burroughs has seen and helped drive numerous evolutions in payment and transaction automation technology. This commitment to innovation combined with service, collaboration, agility, and investment i ...

  • Burroughs, Inc.

    Middleware Developer and Digital Architec

    5 days ago

    Burroughs, Inc. Elmhurst, United States

    **Description** · 1 · Through its 135 years of innovation and service excellence Burroughs has seen and helped drive numerous evolutions in payment and transaction automation technology. This commitment to innovation combined with service, collaboration, agility, and investment i ...

  • Diverse Lynx

    Senior Database Developer

    1 week ago

    Diverse Lynx Jersey City, United States

    Job Summary: · 7-10+ years experience as DB2 SQL developer with a strong focus on writing stored procedures. · • Demonstrable experience with analyzing and optimizing complex stored procedures. · • Extensive experience with database performance tuning including stored procedur ...

  • Center for Autism and Related Disorders

    Clinical Supervisor

    1 week ago

    Center for Autism and Related Disorders Bayside, United States

    Salary Range: $80,000 - $120,000 · ORGANIZATION · Pantogran, DBA CARD, is seeking highly motivated professionals to join our team. As a part of our growing organization under new ownership, you'll have the opportunity to contribute to our success and take advantage of new policie ...

  • Center for Autism and Related Disorders

    Clinical Supervisor

    1 week ago

    Center for Autism and Related Disorders Mamaroneck, United States

    Salary Range: $80,000 - $120,000 · ORGANIZATION · Pantogran, DBA CARD, is seeking highly motivated professionals to join our team. As a part of our growing organization under new ownership, you'll have the opportunity to contribute to our success and take advantage of new policie ...

  • Diverse Lynx

    Database Developer

    1 week ago

    Diverse Lynx Jersey City, United States

    Job Title: Senior Database Developer · Client: Prudential Financial Inc. (INS) · # of Positions: 1 · Length of Assignment: 1 year + · Job Summary: · 7-10+ years experience as DB2 SQL developer with a strong focus on writing stored procedures. · •Demonstrable experience with ...

  • eTeam

    sot infra l3 sql dba

    4 days ago

    eTeam Jersey City, United States

    Pay Range: $60-$65 · Minimum 12+ years Experience · t least 5+ years of SQL DBA experience covering implementation, production support and project work. At least 4+ years of exposure as L3/SME support role. · Knowledge and Understanding of ITIL process · In client facing role( ...

  • The Fountain Group

    Performance Test Engineers

    2 weeks ago

    The Fountain Group Jersey City, United States

    Performance Test Engineers · About this Opportunity · We have an immediate requirement for a Principal Performance Test Engineer to join our passionate Performance Engineering team. The Performance Architect is a software engineer and performance analyst with a passion for opti ...

  • Dtcc

    Principal Lead Cloud Data Engineer

    2 weeks ago

    Dtcc Jersey City, United States

    Are you ready to explore a world of possibilities? · Join our DTCC family, and you'll grow your expertise and become the best version of you. As you embark on a new journey, you'll be supported and surrounded by other professionals as you learn new skills, advance your career, an ...

  • Resource Informatics Group Inc

    REMOTE - Senior ETL Technical Architect

    1 week ago

    Resource Informatics Group Inc Jersey City, United States

    Job Description · Job DescriptionTitle: ETL Technical Architect with State or Public sector experience · Duration :1 year · Rate: DOE · Remote · Job description · Having public sector project exp would be added advantage. · Daily Tasks include: · Lead efforts in identification an ...

  • BGIS

    Sr. Residential Service Technician

    5 days ago

    BGIS Hudson, United States

    Job Description · Job DescriptionBGIS ITS is currently seeking a Sr. Residential Service Technician to join the team in Hudson, FL and surrounding areas. · The Senior Service Technician leverages their extensive expertise to diagnose, troubleshoot, and efficiently repair a variet ...

  • BrightSpring Health Services

    pharmacy technician

    1 week ago

    BrightSpring Health Services Hudson, United States Regular, Full time

    · PHARMACY TECHNICIAN · Job Locations · US-WI-HUDSON · ID · Line of Business · OnePoint Patient Care · Position Type · Full-Time · Pay Min · USD $18.50/Hr. · Pay Max · USD $21.00/Hr. · Our Company · OnePoint Patient Care · Overview · OnePoint Patient Care is one of the pioneers ...

  • BrightSpring Health Services

    pharmacist

    1 week ago

    BrightSpring Health Services Hudson, United States Regular, Part time

    · PHARMACIST · Job Locations · US-WI-HUDSON · ID · Line of Business · OnePoint Patient Care · Position Type · Part-Time · Pay Min · USD $54.00/Hr. · Pay Max · USD $59.00/Hr. · Our Company · OnePoint Patient Care · Overview · OnePoint Patient Care is one of the pioneers in the ho ...

  • BrightSpring Health Services

    pharmacist in charge

    1 week ago

    BrightSpring Health Services Hudson, United States Regular, Full time

    · PHARMACIST IN CHARGE · Job Locations · US-WI-HUDSON · ID · Line of Business · OnePoint Patient Care · Position Type · Full-Time · Pay Min · USD $60.00/Hr. · Pay Max · USD $65.00/Hr. · Our Company · OnePoint Patient Care · Overview · OnePoint Patient Care was established in the ...

  • LasikPlus

    Optometrist OD Full-Time

    1 week ago

    LasikPlus Manhattan, United States Full time

    We are Growing Join us at LasikPlus, LVI & TLC · Optometry leaders, are you looking for an exciting and rewarding career opportunity at a second-generation family-owned business working alongside world-class ophthalmologists with a leading provider of laser vision correction in t ...

  • Sartiano's

    Maintenance Engineer

    5 days ago

    Sartiano's New York, United States Full time

    99 Prince Street · Maintenance · Job Description · Responsible to: · Management · About: · Sartiano's was born from the Tuscan heart and soul of Italy. Business leader, Restaurateur, and Lifestyle Architect Scott Sartiano introduces his latest concept, appropriately chosen afte ...

  • Zero Bond

    Senior Food and Beverage Manager

    1 week ago

    Zero Bond New York, United States Full time

    Full Time · Senior F&B Manager · The Place · A place like no other - Re-imagine the experience of membership with the opportunity to belong to an eclectic and stellar community; that is the Zero Bond private members' club. Born into the heart of a culturally historic neighborhood ...