5+ years of experience in database development.Office Location: Goregaon Mumbai Primary Responsibilities: Understand requirements from front end applications developers Write advanced queries, stored procedures, cursors, functions & triggers Conduct code reviews Work with high-traffic application servers Manage people and projects on a day-to-day operational level Effective client interaction Required Skills: Functional: MSSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers, Performance Optimization, Database Design, Indexes, Joins, DB Administration, ETL tools like SSAS, SSIS, High Data Volume Processing, Data Integrity Management, DB Backup/Recovery, Cloud Services. Mandatory: Passionate about sports, Problem-solving, Team player, Target & Result oriented. Additional: Team Management, Decision Making & Client Management.
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. 2. Experience in design, develop, building and analyzing database management system to include database modeling and design relational database architecture based on Client requirements. 3. Advanced knowledge of SQL, ability to apply SQL creatively to a wide variety of business requirements. 4. Adding constraints to the tables, identifying columns for Indexes and using Hints, Index Seek in queries for performance. 5. Good use of Transaction Isolation levels in the procedure/queries. Experience in writing Stored Procedures, Triggers, Functions and Complex queries to support application development. 6. Optimizing (using Execution Plan), Debugging and testing the queries in procedures and others for performance efficiency. 7. Intermediate knowledge of Service Broker. Manage Client deliverables on quality, productivity and timeliness. 8. Database version: Microsoft SQL Server 2008, 2008 R2, 2012, 2014 and MySQL. 9. Third party tools like SQLToad, RedGate SQL Compare, TFS (Team Foundation Server).