SQL Developer-Direct Client
Company: Pronix Inc
Location: White Plains
Posted on: July 27, 2022
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,
- Experience in SSIS, SSRS and Service Broker.
- Experience developing and maintaining ETL processes that
support data movement across platforms in a hybrid
Keywords: Pronix Inc, White Plains , SQL Developer-Direct Client, IT / Software / Systems , White Plains, New York
Didn't find what you're looking for? Search again!