SQL Server Deveoper - Patna, India - Sure4job Manpower solutions

Description

Job Description: SQL Server Developer

Education Qualification: Any Graduate

Minimum Years of Experience:2-3 Years

Key Skills: MS SQL Server

Type of Employment: Permanent

Requirement: Immediate or Max 15 days

Job Responsibilities:

Responsible to work with development team to develop, implement, and manage data base

models for core product development.

Responsible to write SQL database views, tables, and stored procedures to

support engineering product development.

Responsible for designing and maintaining SSIS, T-SQL, and SQL jobs.

Responsible for developing and maintaining complex stored procedures for loading data into

staging tables from OLTP, and other intermediary systems.

Responsible for analysis, design specifications, development, implementation, and

maintenance of DB.

Responsible for designing partitioning of DB for Archive data.

Responsible to ensure that the best practices and standards established for the use of tools

like SQL Server, SSIS, SSRS, Excel Power Pivot/View/Map are incorporated in Data Analytics

solutions design.

Responsible for documenting complex processes, business requirements and specifications.

Technical Skills:

Experience in database design, normalization, query design, performance tuning

Proficient in writing complex Transact SQL code.

Proficient in MS SQL Server query tuning.

Experience in writing stored procedures, functions, views and triggers.

Experience in Indexes, column store index, SQL server column storage, Query execution plan.

Provide authentication and authorizations for Database.

Develop best practices for database design and development activities.

Experience in database migration activities.

Strong analytical, multi-tasking and problem-solving skills.