Snowflake DBA

26 Nov 2024

Vacancy expired!

PETADATA is looking for a

Snowflake DBA to work with one of our clients

.

Job Location: Morristown, NJ

Work Authorization: W2, Full-time & C2C

Experience: 7+ years of experience

Visa: H1B Visa, TN Visa, , EAD.

Job Description:

PETADATA is looking for a Snowflake Database Administrator who will report to the EnterpriseData Services team to build and maintain the Snowflake SaaS service for building advanced data solutions throughout the OneMain organization. We need hands-on experience in the DBA role using the Snowflake platform.

Roles & Responsibilities:
  • Should be able to develop, build & maintain mission-critical centralized data platforms using Snowflake.
  • You should be able to identify & perform the core administration for the snowflake environment.
  • Able to build the automation to optimize the environment, build pipelines to define metrics-related things in snowflake, and be the key central point of contact for a Snowflake within the organization.
  • Should be able to diagnose and troubleshoot Snowflake database errors.
  • You must have worked with multiple internal user groups include analytics and data science.
  • You can implement the Snowflake user /query log analysis and alerts.
  • Work with heterogeneous user groups from data engineers to data scientists.
  • Must be able to implement data encryption/decryption/masking policies to protect PII/PCI data
  • To demonstrate proficiency in index design, query plan optimization, and analysis require
  • The security audits for the user implement/support automation for production deployment in the Snowflake platform.
  • Should actively work with Snowflake support for raising support tickets and triaging outages.
  • Able to create a Snowflake utilization and capacity plan.
  • Must take On-call responsibilities on a rotational basis for Snowflake database administration.

Required Skills:
  • Hands-on experience in development tools for CI/CD for establishing DevOps for Snowflake.
  • Expertise in Snowflake security features includes authentication, authorization, encryption, masking, secured views, etc.
  • Should have good SQL experience for writing complex SQL transformation includes working with Snowflake system tables.
  • Must have strong database administration skills for maintaining a secure, stable, high-performing, and highly tuned snowflake environment.
  • Should proactively identify, design, and implement process improvements like automating manual processes, optimizing data flow, increasing scalability, etc.
  • Expertise in tuning the database to improve Snowflake queries
  • Expert in technical leadership, fostering a team environment, and providing mentorship and feedback to technical resources.

Preferred qualifications:
  • Bachelor's degree in computer science, computer engineering in a related field is required.
  • Must have 7+ Years of experience in Snowflake DBA.

If you are interested and meet the above job requirements, please submit your resume to

After carefully reviewing your experience and skills, one of our Hiring team members will contact you on the next steps.

  • ID: #23509647
  • State: New Jersey Morristown 07960 Morristown USA
  • City: Morristown
  • Salary: Depends on Experience
  • Job type: Permanent
  • Showed: 2021-11-26
  • Deadline: 2022-01-24
  • Category: Software/QA/DBA/etc