WhitePlainsRecruiter Since 2001
the smart solution for White Plains jobs

SQL Developer-Direct Client

Company: Pronix Inc
Location: White Plains
Posted on: July 27, 2022

Job Description:

Greetings!!!This is Sai Pranai from Pronix Inc.Role: Sr. SQL Developer (Direct Client)Location: White Plains, NY (Onsite At least 2 day visit the office)Duration: 12+ Months W2 ONLYResponsibilities of the Sr. SQL/SSIS Developer:

  • The Senior SQL Developer will be responsible for designing, developing, documenting, and supporting the Synchrony-Allegro finance account system of record.
  • This position is responsible for leading a small team to refactor key processing functions of the legacy system into stored procedures with a goal of optimizing current.
  • processing for performance and resiliency.
  • Develop the technical approach, database design, and execution for the refactor of the legacy system of record.
  • Optimize query performance by modifying existing queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing table objects.Requirements for the Sr. SQL/SSIS Developer:
    • B.S. in Computer Science, Mathematics, or Engineering or equivalent work experience.
    • 7+ years of experience in the full life cycle of designing and developing databases and applications using MS-SQL Server.
    • 5+ years' experience developing database solutions in the consumer finance industry.
    • Expertise creating, deploying, and supporting SSIS packages, T-SQL queries, and stored -procedures.
    • Expertise in sophisticated relational database report design, development and maintenance using reporting tools such as MS Access - Writing Transact-SQL Stored Procedures.
    • Relational Database Design/Development to include performance Tuning, error handling via TRY/CATCH with event logging, locking/block management
    • Experience in SSIS, SSRS and Service Broker.
    • Experience developing and maintaining ETL processes that support data movement across platforms in a hybrid environment.

Keywords: Pronix Inc, White Plains , SQL Developer-Direct Client, IT / Software / Systems , White Plains, New York

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest New York jobs by following @recnetNY on Twitter!

White Plains RSS job feeds