Njtech - Weehawken, NJ

posted 3 months ago

Full-time - Senior
Weehawken, NJ
Professional, Scientific, and Technical Services

About the position

As a Senior SQL Developer with DBA responsibilities at NJTECH, you will play a crucial role in designing and developing large-scale applications that meet the needs of our clients. This position requires a collaborative approach, where you will work closely with team members to refine user requirements through test-driven development (TDD). You will be responsible for creating an end-to-end data pipeline, which involves reading from multiple sources and loading data into the landing layer or SQL tables. Your analytical skills will be essential as you analyze the root causes of incidents and provide effective solutions to ensure system reliability and performance. In addition to your development duties, you will engage in SQL programming and database administration tasks. This includes working on performance tuning and optimization in environments such as MSSQL and Azure SQL. Your expertise will help maintain the integrity and efficiency of our database systems, ensuring that they can handle the demands of our applications and services. You will also be expected to stay updated with the latest cloud technologies and frameworks, particularly those related to Microsoft Azure, to enhance our data management capabilities.

Responsibilities

  • Design and develop large-scale applications.
  • Collaborate to refine user requirements through test-driven development (TDD).
  • Create an end-to-end pipeline to load data from multiple sources to the landing layer or SQL tables.
  • Analyze the root causes of incidents and provide solutions.
  • Perform SQL programming and database administration tasks.
  • Work on performance tuning in MSSQL and Azure SQL.

Requirements

  • 5+ years of experience in SQL programming.
  • Strong experience in performance tuning and DBA activities.
  • Excellent understanding of relational transactional databases like MSSQL and Azure SQL.
  • Experience with cloud platforms/tools, preferably Azure.

Nice-to-haves

  • Experience in TSQL (MSSQL/SYBASE) code development, performance tuning, and query optimization.
  • Extensive batch or ETL creation experience with better error handling.
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using frameworks like Azure Data Factory, Synapse, or Databricks.

Benefits

  • Equal opportunity employer with a commitment to diversity and inclusion.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service