Snowflake Admin Job at VDart Inc, Chicago, IL

MWlZcUg5Q0xXaFdZdFQzUlVLdk1KV29aeGc9PQ==
  • VDart Inc
  • Chicago, IL

Job Description

Job Title: Snowflake Admin

Location: Chicago, IL - Remote

Duration: 6+ months Contract

Job Description:

We are looking for a hands-on Snowflake Administrator to join our team! You will be included in the Snowflake administration team and tasked with managing the Snowflake database as well as supporting various teams within the Data Intelligence and Pricing group. You will assist applications in loading data in real-time, near real-time, and end-of-day files, with UI and API applications utilizing Snowflake as their backend database. This dynamic environment will demand that you are a proactive critical problem solver who can maintain platform stability and resilience while applying modern engineering practices and solutions. Manage existing data pipelines keeping data relevant and true, ready for analytical consumption.

Key Responsibilities:

Database Administration:

  • Deploy, configure, and administer Snowflake environments
  • Monitor and optimize Snowflake performance, storage, and query execution
  • Automate maintenance and administration tasks using SQL, Python, or Shell scripting
  • Integrate Snowflake with AWS S3, Glue, Lambda, Airflow, DBT and other cloud services
  • Manage external stages and storage integrations for seamless data movement
  • Monitor security logs and implement audit controls for data protection
  • Identify and resolve performance bottlenecks, query performance, and connectivity issues
  • Establish monitoring, alerts, and proactive issue resolution strategies
  • Create, manage, and maintain Snowflake databases, warehouses, and roles.
  • Implement and enforce data governance policies and procedures.
  • Monitor database performance and identify optimization opportunities.
  • Perform regular database backups and recoveries.
  • On-call rotation duties and weekend support activities where needed.
  • Participate in CICD deployments and other planned activities where needed.

Security:

  • Implement and maintain robust security measures to protect sensitive data.
  • Manage user access controls and privileges.
  • Monitor for security threats and respond to incidents promptly

Performance Optimization:

  • Analyze database performance and identify bottlenecks.
  • Tune database configurations to improve query performance.
  • Implement indexing strategies and data partitioning techniques.

Data Loading and Migration:

  • Develop and execute data loading and migration strategies.
  • Ensure data integrity and accuracy during the migration process

Troubleshooting:

  • Diagnose and resolve database-related issues and errors.
  • Provide technical support to data analysts and engineers

Documentation:

  • Maintain comprehensive documentation of database architecture, procedures, and standards.

Qualification Requirements:

  • 6+ years of proven experience as a database administrator with Snowflake.
  • 5+ years of Strong understanding of SQL and database concepts
  • 5+ years of experience in deployments and on-call support activities
  • 5+ years of experience in supporting and troubleshooting batch, streaming and real time data loads.
  • 4+ years of experience in Snowflake applications (big data cloud database), writing efficient queries, as well as reading and understanding the query plans and writing stored procedures and functions
  • 4+ years of experience in cloud native technologies including AWS.

Key Skills:

Snowflake, Database administration, SQL, Database concepts, AWS S3, Glue, Python.

Job Tags

Contract work, Weekend work,

Similar Jobs

Jobleads-US

Registered Health Information Technician (RHIT - Home Health) Job at Jobleads-US

Registered Health Information Technician (RHIT - Home Health) - Ensuring Accurate & Secure Patient Records Company: All Seniors Foundation Location: Los Angeles, CA About Us: All Seniors Foundation believes that reliable, confidential patient records are essential for... 

The University of Kansas Health System St. Francis Campus

Excel | Registered Nurse (RN)- Telemetry, ICU, or Emergency Room Job at The University of Kansas Health System St. Francis Campus

 ...~2-Year Degree ~ Specific Certificationsare required within one year of hire Preferred Job Requirements: ~4-Year Degree ~ At least one year recent experience in a similar healthcare setting. ~ Familiar with Microsoft Office (Word, Outlook, Excel).... 

Centers Health Care

Certified Nursing Assistant (CNA) - Agency Job at Centers Health Care

Richmond Center is hiring Certified Nursing Assistants (CNA) in Staten Island, NY. Now Hiring Straight Through Agency! Now Offering up to $6,000 in Travel Reimbursement! DUTIES: Observing Residents Reporting any health issues to the supervising nurse Taking... 

Peoples Injury Network Northwest

Physical Therapist - Industrial Rehab Job at Peoples Injury Network Northwest

 ...PINN, a brand partner of Upstream Rehabilitation, is looking for an Industrial Rehab Physical Therapist to join our team in Vancouver, WA. Join a busy clinic seeing 300 visits per week! The clinic is staffed by 2 Physical Therapists, 2 Physical Therapy Assistants, 1 Occupational... 

Yalent

Psychiatric Nurse Practitioner (NP) Job at Yalent

 ...Job Description Job Description Yalent is seeking a dedicated Psychiatric Nurse Practitioner (NP) to join our client, AllCare , in delivering compassionate, patient-centered mental healthcare to seniors. In this pivotal role, youll provide evidence-based psychiatric...