drjobs
SQL Developer
drjobs SQL Developer العربية

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs

Job Location

drjobs

- USA

Monthly Salary

drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Req ID : 2621271
Job Title SQL Developer
Location Long Island City NY (Hybrid)
Duration 12 Months
Years of Experience 6yrs

Duties and Responsibilities

  • Perform analysis of the existing EndClient data integration solutions leveraged by the endClient Early Intervention program documenting asis specifications
  • Review and understand data gap analyses and downstream impact analyses
  • Design implement and test replacement data integration solutions supporting the transition to the New York State Early Intervention HUB system including differential data processing from full data sets
  • Design implement and test MS SQL code including stored procedures views functions triggers etc.
  • Migrate and adapt existing Oracle database objects to MS SQL equivalents
  • Remediate the existing SQL database code for all end client Early Intervention systems dependent upon end clients client data integration
  • Perform unit system and integration testing of all developed code and objects
  • Fully support the documentation of the replacement data integration solutions providing data dictionaries topology diagrams and operational guides
  • Required Skills

    • Minimum 5 years of experience developing Microsoft SSIS based solutions.
    • Demonstrated expertise in developing MS SQL SSIS packages that automate data integration processes involving multiple data sources.
    • Strong experience developing & troubleshooting complex MS SQL code including stored procedures views functions triggers etc.
    • Demonstrated understanding of error handling techniques in MS SQL code and Microsoft SSIS solutions.
    • Experience in performance tuning slow and inefficient MS SQL code utilizing various industry tools and methodologies.
    • Very strong analytical skills with ability analyze disparate datasets and produce an efficient and scalable solution.

    Employment Type

    Full Time

    Key Skills

    • Databases
    • SQL Server Management Studio
    • SQL
    • .NET
    • Microsoft SQL Server
    • ssrs
    • TFS
    • Database Design
    • Performance Tuning
    • SSIS
    • T Sql
    • Data Warehouse
    Report This Job
    Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.