SQL Developer

Job Description:

Candidate should ideally be a B.E/B.Tech graduate with around 3 to 5 years of experience, with core T-SQL scripting , performance tuning, SSIS, NOSQL skills. The current role requires a core T-SQL , NoSQL and SSIS developer. The SQL Developer will be responsible for:

Creating & designing database and all database objects such as tables, views, StoredProcedures, functions etc.

Writing and troubleshooting simple to complex SQL scripts, stored procedures, views, functions, etc. as per the requirement.

Troubleshooting and fixing all performance issues with respect to databases (objects & scripts).

SQL Query tuning and performance tuning.

Develop/migrate existing scripts to SSIS.

Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints, etc.

Maintaining database objects (like tables, views,Stored Procedures) performance by following the tuning tips like normalization, indexes, etc.

Importing and exporting the data from different sources using tools, writing required scripts.

Works closely with other members of the team to accomplish the projects.

Assists project teams to design and develop core business components utilizing  industry-accepted analysis and design standards.

Provides and/or assists with, project management and project leadership.

Create and maintain documentation for all the projects.

Working with NOSQL databases (Mostly on MongoDB) .

PRIMARY SKILLS:

TSQL, SQL, NoSQL, Performance Tuning, SSIS, Import & Export of data from different data sources and from different formats.

SECONDARY SKILLS:

Database Administration

REQUIRED SKILLS:

3+ years of professional experience in working with MSSQL Server 2008 and above.

3+ years of professional experience in writing TSQL scripts.

Thorough experience in SQL query tuning and performance tuning.

Experience in developing and maintaining SSIS packages.

Experience in working with NoSQL databases. MongoDB would be preferable.

Fluent knowledge of MSSQL server DBA.

Should be a good team player and should possess good attitude and work ethics.

Should possess excellent communication and written skills.

PREFERRED SKILLS:

MSSQL DBA.

SSIS.

NOSQL, MongoDB