SQL Developer

$135,200 - $145,600/Yr

BCforward - Jersey City, NJ

posted 3 months ago

Full-time - Mid Level
Jersey City, NJ
5,001-10,000 employees
Professional, Scientific, and Technical Services

About the position

BCforward is currently seeking a highly motivated SQL Developer for an opportunity in Jersey City, NJ. The SQL Developer will be responsible for analyzing, designing, and mentoring the team on OLAP database schema design. This role involves designing tables, stored procedures, views, indexes, user-defined functions, and other database objects to support the delivery of multiple Tier 1 and Tier 2 applications. The SQL Developer will also analyze and performance tune SQL queries to reduce response time without impacting application performance. Additionally, the developer will implement and document best practices for database object creation, maintenance, performance tuning, and optimization for future development. The role includes developing and documenting data quality, data discovery, and data lineage measures, and experience in CI-CD (Jenkins/DACPAC) deployments is required. Familiarity with Informatica or SSIS development is considered a plus. This position is a contract placement expected to last for 12 months, with a pay range of $65/hr to $70/hr, depending on various factors such as location and experience.

Responsibilities

  • Analyze, design, and mentor team on OLAP database schema.
  • Design tables, stored procedures, views, indexes, user-defined functions, and other database objects.
  • Analyze and performance tune SQL queries to reduce response time without impacting application performance.
  • Implement and document best practices for database object creation, maintenance, performance tuning, and optimization.
  • Develop and document data quality, data discovery, and data lineage measures.
  • Experience in CI-CD (Jenkins/DACPAC) deployments.

Requirements

  • Strong SQL Server development experience required.
  • 10+ years SQL Server development experience.
  • Ability to analyze and performance tune SQL queries.
  • Experience in designing OLAP database schema.
  • Experience in implementing and documenting best practices for database development.

Nice-to-haves

  • Informatica or SSIS development experience.

Benefits

  • Major medical insurance
  • Health Savings Account (HSA)
  • Dental insurance
  • Vision insurance
  • Employer-provided group life insurance
  • Voluntary life insurance
  • Short-term disability
  • Long-term disability
  • 401k
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service