Snowflake Database Administrator

20 Nov 2024

Vacancy expired!

Role: Snowflake DBA w

Duration: Long Term contract / Full Time

Location: Morristown, NJJob Description:
  • The Snowflake Database Administrator will report to the Enterprise Data Services team and will building and maintaining Snowflake SaaS service for building advanced data solution through- out the OneMain organization. This is completely hands-on DBA role using Snowflake platform.
  • The candidate will be play central critical role for identifying performing core database administration for Snowflake environment, build automation to optimize the environment, build pipelines to define metrics related to all things snowflake and be key central point of contact for Snowflake within the organization.
  • 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.
  • Work with heterogeneous user groups from data engineers to data scientists.
  • Implement data encryption/decryption/masking policies to protect PII/PCI data
  • 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
  • Provide technical leadership, fosters a team environment, and provides mentorship and feedback to technical resources.
  • On-call responsibilities on rotational basis for Snowflake database administration.
  • Good SQL experience for writing complex SQL transformation including working with Snowflake system tables
  • Strong database administration skills for maintaining secure, stable, high performing and highly tuned snowflake environment
  • 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.
  • Experience with Development Tools for CI/CD for establishing DevOps for Snowflake.

  • ID: #23051875
  • State: New Jersey Morristown 07960 Morristown USA
  • City: Morristown
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2021-11-20
  • Deadline: 2022-01-16
  • Category: Software/QA/DBA/etc