SQL Server Tech Lead-L1(T82038)

Experience:
4 - 6 Years
Location:
United States (U.S),Redmond
Education:
UG - Any Graduate - Any Specialization PG - Any PG Course - Any Specialization
Industry Type:
IT-Software/ Software Services
Role:
Team Lead/Tech Lead
Functional Area:
Application Programming, Maintenance

Contact Details
Company Name:
Wipro Technologies
Website:
http://careers.wipro.com/
Executive Name:
Wipro Technologies

Desired Candidate Profile
Qualification: Bachelors Degree, Masters DegreeExperience: 4-6 YEARSSkills: Technical Lead - Responsible for development, support, maintenance and implementation of a complex project module. Works on problems of complex scope, through extensive usage of standard concepts & principles. Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities. Requires extensive knowledge of at least one development technology/ programming language. Expected to continue to build upon domain knowledge and technical/ proprietary skills to reach levels of expertise, while adapting standard principles to new or changed conditions in day to day work. Has the ability to respond to detailed queries. Applies own judgment to independently determine a course of action, which is then executed independently post review. Responsible for coaching, guiding and mentoring junior members in the team to help them scale up faster.Area of expertise: Technology Infrastructure Services
Job Description
Roles and Responsibilities: SQL Server - L4, DB Modeling - L1Skill & Job Requirements: SQL Server - L4 - RDBMS - Exposure to Basic Relational Database Concepts - basic types of databases, data integrity, the relational model,etc. Ability to understand basics of DB Design , Logical modeling , Normalization & De-Normalization Techniques MS SQL , SQL Constructs. Ablility to understand and implement Data Types, Basic SQL SELECT Statements, Restricting and Sorting Data, System Functions, Joins, Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML), Constraints, Views. SQL Query Tuning Basics: Understanding of concepts like Tuning Methodology, SQL Statement Processing, SHOWPLAN, Introduction to the Optimizer, Indexes and Basic Access Methods, Gathering Statistics, Optimizer Hints, Monitoring queries, Optimizing queries.
Keywords: SQL Server Tech Lead - L1T82038