• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 20th Aug 2021

Responsibilities: 
Significant and recent development experience with SQL Server 2008 and 2012. 
Design and create tables, views, triggers, partitions, complex stored procedures, functions, indexes and other database objects 
Support extracting and transforming data using DTS/SSIS Import Export Data, Bulk Insert, BCP and DTS/SSIS Packages 
Analyze database and system response time and determine optimization and tuning recommendation to improve SQL Query  performance 
Document processes and procedures for development and workflow needs 
Working on full life cycle development (SDLC) involving in all stages of development.
Creating the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, stored procedure, constraints, and roles.
Writing the stored procedures and user-defined scalar functions (UDFS) to be used in the SSIS packages and SQL scripts.
Extensively utilizing the joins and sub-queries to streamline complex questions including different table.
Creating and managing the clustered indexes and non clustered indexes and optimized queries using execution plan.

Required Skills: 
Bachelor of Science in Computer Science 
2-5 years’ experience with TSQL including dynamic SQL 
Significant experience in SSIS  development 
Ability to work with Database Team on best practices and abiding coding standards 
Ability to remain calm and work effectively in a fast-paced environment with tight deadlines 
Excellent communication skills