*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 "Hot List" group. To unsubscribe from this group and stop receiving emails from it, send an email to directclienteq+unsubscr...@googlegroups.com. To post to this group, send email to directclienteq@googlegroups.com. Visit this group at http://groups.google.com/group/directclienteq. For more options, visit https://groups.google.com/d/optout.