Snowflake Database Engineer Snowflake DBA Direct client

HCL Global Systems
Westlake, TX
15 May 2024

Vacancy expired!

Position: Snowflake Database Engineer – Snowflake DBA

Location: Westlake, TX

Duration: Long-term

Requirements:

  • Hands on snowflake admin experience (AWS preferred).
  • Hands on DBA experience with MPP systems and large data warehouses.
  • Scripting and automation experience Shell/Perl/Python

Qualifications:
  • Bachelors or master’s in engineering, Information Systems, Computer Science or Information Technology or equivalent experience
  • 3-4 years of hands-on experience with Snowflake Administration (AWS preferred but Azure is okay too)
  • 5+ Years of hand on DBA experience with MPP systems and large Data warehouses
  • 5+ years of scripting and automation experience using Shell / Perl / Python
  • Proficiency in Snowflake platform Architecture, function/feature
  • Understanding User/Data/Network Security
  • Awareness of DB Optimization techniques pertinent to Snowflake
  • Monitoring, alerting of the Snowflake platform
  • Understanding of data ingress & egress patterns between Snowflake & different CSPs
  • Proficiency in SQL and Procedural languages of any major RDBMS like Oracle, DB2, Postgres or SQL Server
  • Participating in on-call rotation & production support
  • Working experience on MPP systems like – Netezza, Teradata, Greenplum, Hadoop etc.
  • Working experience and good understanding of big data eco systems like Hadoop
Responsible for Enterprise Snowflake SysDBA operations, CTG Database operations & Platform Engineering, Data masking & Data ingestion platform for CTG. He is part of the CIO Tech Group and is in the operations center of excellence for all groups. All Snowflake ops, analytical platform run under Reddy. ML, data scientist work is included. This data has grown to 2.5 terrabytes. They have had to work extremely hard for 2.5 years to get this. The reason is that they have capacity limits on the other data warehouses so they needed to move everything to the cloud/snowflake. Now they are running prod ops on this and trying to scale it.

The Expertise and Skills You Bring
  • Your ability to support multiple RDBMS like Postgres, Snowflake, SQL server, DB2 & Netezza in addition to Oracle
  • You bring 5+ years of SQL & PL/SQL experience or other Database programming languages
  • Your able to participate in DB design discussions and offer consulting services to Business and Data modelers.
  • Your able to participate in Logical/Physical design discussions with Architects and Application teams.
  • You bring the competencies and Architectures related to High Availability, Disaster Recovery & Business Continuity.
  • You bring the experience in backend programming languages like PL/SQL, T-SQL, NZ SQL etc.
  • You have scripting experience with Unix shell, Python, Perl, C,
  • You are familiar with Java, J2EE, Embedded SQL, Forms, Reports, etc.
  • You are able to support other RDBMS like Postgres, Snowflake, SQL server, DB2 & Netezza
  • Your able bring Application experts and other infrastructure teams together for finding optimal solutions to issues related to capacity, security, performance
  • The Senior DBA will be expected to be an Oracle technical expert in database domain.
  • Skills (effective communication, able to work with teams, presentation skills) required for the role
  • ID: #40914159
  • State: Texas Westlake 76262 Westlake USA
  • City: Westlake
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-05-15
  • Deadline: 2022-07-12
  • Category: Et cetera