Send me more jobs like this

Keywords / Skills : Triggers, SSIS packages, SSIS, SQL server, Ms Sql Server, T-SQl, SQL Server Database Design, SQL

5 - 10 years
Posted: 2019-01-24

Nationality
India
Industry
IT/ Computers - Software
Function
IT
Role
Software Engineer/ Programmer
Education
BCA
BE
BTech
BSc
Stream:
Computers
Posted On
24th Jan 2019
Job Description

RESPONSIBILITIES

Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages
Performance tuning the stored procedures and T-SQL.
Assist developers with complex query tuning and schema refinement.
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
Tuning T-SQL queries to improve performance

EDUCATION
Minimum: BS degree in computer science or equivalent

REQUIREMENTS

Bachelor's degree in Computer Science or equivalent.
In-depth knowledge of standard concepts, practices and procedures related to database management
Required 5 years of solid experience with Microsoft SQL Server 2012 and above. Must know SQL inside and out.
Required 5 years T-SQL language (queries, views, procedures)
Required 5 years SQL Server Database Design, Stored Procedure Design and implementation
Experience coding complex stored procedures (using T-SQL).
Experience with developing SSIS packages
Proven analytical problem solving and debugging skills
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
Providing database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments
Monitoring performance and managing parameters to provide fast query responses to front-end users
Excellent English communications skills (written and verbal)


About Company

Cardinal Technology Solutions is a full-services Information Technology Company providing IT consulting and staffing services to Fortune 1000 organizations.As a process oriented organization we recognize that people are the key driver in the IT business and by being people centric in our approach, we create a unique differentiators in harnessing the intellectual energies of the human mind to run your business and build 'best of breed' solutions for your enterprise.
Similar Jobs
View All Similar Jobs
Walkin for you