Hi, I hope you are doing great. Please find the below our *direct client requirement *and please send me your consultants resume to *vku...@aptude.com <vku...@aptude.com>*
*Title: Senior MSBI Developer (MDM Experience Must)* *Location: San Diego, CA* *Contract: 6+ Months* * Must have 10 or 10+ years experience* Database Skills Needed in DB Engineer I. Work Skills: 1. Analytical and critical thinking skill, problem solving skill, thorough and detail oriented (i.e., consider all scenarios within a stored proc when troubleshooting, testing, and providing resolutions) (must) 2. Excellent verbal and written communication skills (highly preferred) 3. Excellent collaboration skills in a team environment (preferred) II. Engineering Skills: 4. Experienced in engineering and software development lifecycle (full SDLC). (must) 5. Database Change Management experience (preferred) 6. Understand and follow SDLC testing process and practice, disciplined in testing the solution that covers all related test cases and test scenarios within a given function. (must) III. Technical Skills: 7. Experience working with VLDB (large db, hundreds of GB minimal, millions of rows within table minimal) (highly preferred) 8. Database applications and Architecture design skill (preferred ) 9. Focus on and experienced in engineering for performance (understand there is no separation in function fix vs performance tuning along with the functions fix) (must) 10. Can read and analyze the execution plan and know how to tune query performance based on the plan info (what does each different function and algorithm means and indicate good vs bad performance.) (must) 11. Understand and know how to interpret different Stats IO (must) 12. Understand parameters/data distribution and query plan performance tuning relationship (highly preferred) 13. Understand Data, plan, and stats caching mechanism within database engine (highly preferred) 14. Understand the difference, design, and utilization of different type of indexes (i.e., covered index, clustered index, and unique index.) (must) 15. Understand how index internal engine works (highly preferred) 16. Understand how locking mechanism works within db engine and how to prevent locking (must ) 17. Query and table hints utilization (highly preferred) 18. How does transaction works and how to design and code 'civilized' transactions (must) 19. Different 'Transaction Isolation Levels' and their practical applications (must) 20. Fully understand the difference between similar db coding commands and how should they be utilized for different scenarios and their unique advantages and draw backs. (highly preferred) 21. Understand different type of functions and views and each type's unique application, advantage, limitations, and disadvantage (must) 22. Nested stored procs: when should use them, when should not use them, advantages and draw backs. (highly preferred) 23. Dynamic sql, cursor, trigger (understand their usage, programming, draw back, and how to rewrite into tsql) (must) 24. Table partition and archive design and programming (must) 25. ETL, BCP, batch processing and SSIS package design and development (synchronized vs asynchronized transaction, validation rules, logging, parent vs child package, parameter passing, security management, error tracking, notification, deployment, tuning) (must) 26. Experience in Analysis Services (SSAS), cubes and dimensions design and programming. (preferred) 27. MDX programming (preferred) 28. SSRS design and programming (highly preferred) Vinod Kumar vku...@aptude.com www.Aptude.com Phone#: 630-883-4515 Ext: 408 Yahoo IM: jsm_v...@yahoo.com Skype: jsm_vi...@skype.com -- You received this message because you are subscribed to the Google Groups "Companies Looking for IT Out Staffing & Recruitment" group. To unsubscribe from this group and stop receiving emails from it, send an email to arunsinh+unsubscr...@googlegroups.com. To post to this group, send email to arunsinh@googlegroups.com. Visit this group at http://groups.google.com/group/arunsinh. For more options, visit https://groups.google.com/d/optout.