*Hi,* *Kindly let me know if you are comfortable on below position.*
*Hi,* *Kindly let me know if you are comfortable on below position.* *Position: SQL Tester/Developer* *Location: Atlanta, GA* *Duration: 6 months* *Local Candidates Only who can do face to face interview * *GC and Citizens Only * *Candidate must be have experience with the information listed below.* *Beginner* · Where clauses (in, between, etc) · Update syntax · Inner vs left vs right join understanding and usage · Syntax for altering and creating structures · Temp tables and their usage · Cursors · Basic understanding of the use of indexes · Understanding of what foreign keys are for and how to work around them (cascading deletes etc) · Understands basics of transactions · Understands constraints *Intermediate* · How indexes work, difference between clustered, non-clustered, etc, · Understanding of subqueries · Pivots · Can think through joining a table on itself when relevant · Can generate complex data reports via group with aggregate functions · Can do basic profiling within a monitoring/debugging capacity like reading a log · Understands the difference between OLAP and OLTP and when/where to use OLAP structures · Knows how to use triggers and not to use them · Understands transactions and can layer them handling failures up the stack *Advanced* · Can read an execution plan, and understand how the different parts of the query effect it · Can tune queries with execution hints · Can profile and use traces for identifying and understanding statistics of executions · Knows what the data structures are on the disk · Can use performance counters and understand what the database load and behavior is from monitoring them · Knows how to design an OLAP cube and do advanced data mining with one · Knows how to use triggers and how to use them safely, with minimal risk · Knows how to use distributed transactions even with layers Regards *Mayank* 978-558-4666 x 103 *may...@teknavigators.com* <may...@teknavigators.com> -- You received this message because you are subscribed to the Google Groups "MCMS" group. To unsubscribe from this group and stop receiving emails from it, send an email to mcms+unsubscr...@googlegroups.com. To post to this group, send email to mcms@googlegroups.com. Visit this group at http://groups.google.com/group/mcms. For more options, visit https://groups.google.com/d/optout.