SQL Developer

TALENER GROUP
New York, United States of America
27 days ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 177K

Job location

New York, United States of America

Tech stack

API
Agile Methodologies
Data Integration
Database Development
PostgreSQL
Microsoft SQL Server
Query Optimization
Salesforce
SQL Stored Procedures
SQL Server Integration Services
Snowflake
Database Optimization

Job description

  • Design and develop complex stored procedures, functions, triggers, and views in MS SQL Server and PostgreSQL.
  • Build and maintain SSIS packages to integrate data across different applications.
  • Perform database optimization through query tuning, indexing management, and schema refinement.
  • Create and maintain APIs and develop solutions for data integration tools such as Microsoft SSIS or Informatica.
  • Collaborate with stakeholders in an Agile environment to troubleshoot and resolve data issues.

Requirements

  • 10+ years of experience in SQL development (MS SQL Server and PostgreSQL).
  • Expertise in writing complex stored procedures with a focus on transaction handling and error management.
  • Proven experience with Data Integration tools, specifically Microsoft SSIS.
  • Strong analytical skills with the ability to identify and solve organizational data needs.
  • Excellent communication skills with the ability to work effectively across stakeholder groups.
  • Experience with Snowflake, Salesforce SSIS connections, or Postgres Administration is a plus.
  • Must be local to NYC and able to work on-site in Midtown three days per week., font-size: inherit;">Key Responsibilities:
  • Design and develop complex stored procedures, functions, triggers, and views in MS SQL Server and PostgreSQL.
  • Build and maintain SSIS packages to integrate data across different applications.
  • Perform database optimization through query tuning, indexing management, and schema refinement.
  • Create and maintain APIs and develop solutions for data integration tools such as Microsoft SSIS or Informatica.
  • Collaborate with stakeholders in an Agile environment to troubleshoot and resolve data issues.
Required Qualifications:
  • 10+ years of experience in SQL development (MS SQL Server and PostgreSQL).
  • Expertise in writing complex stored procedures with a focus on transaction handling and error management.
  • Proven experience with Data Integration tools, specifically Microsoft SSIS.
  • Strong analytical skills with the ability to identify and solve organizational data needs.
  • Excellent communication skills with the ability to work effectively across stakeholder groups.
  • Experience with Snowflake, Salesforce SSIS connections, or Postgres Administration is a plus.
  • Must be local to NYC and able to work on-site in Midtown three days per week.
Benefits & Perks:
  • Comprehensive medical, dental, and vision insurance coverage available.
    • <li