Dear Candidate , Avhan is looking for MYSQL Developer having 2-4 years experience . JD .
Experience in Microsoft SQL Server T-SQL, Extract, Transform, Load (ETL) data operations.
Experience in design, develop, building and analyzing database management system to include database modeling and design relational database architecture based on Client requirements.
Advanced knowledge of SQL, ability to apply SQL creatively to a wide variety of business requirements.
Adding constraints to the tables, identifying columns for Indexes and using Hints, Index Seek in queries for performance.
Good use of Transaction Isolation levels in the procedure / queries.
Experience in writing Stored Procedures, Triggers, Functions and Complex queries to support application development.
Optimizing (using Execution Plan), Debugging and testing the queries in procedures and others for performance efficiency.
Intermediate knowledge of Service Broker.
Manage Client deliverables on quality, productivity and timeliness.
Database version : Microsoft SQL Server 2008, 2008 R2, 2012, 2014 and MySQL.
Third party tools like SQLToad, RedGate SQL Compare, TFS (Team Foundation Server).
Skills : - Triggers, TSQL and Stored Procedures