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