*Please Send Profiles to : suma...@bsmsys.com <suma...@bsmsys.com>Role : SQL DB2 DBA DeveloperLocation : Richmond, VADuration : 6+ MonthsInterview : Telephonic + Skype*
*Very strong in Stored Procedures, DB2, DBA is MUST.* *Rate $53/Hr / Need H1B / GC / USC* *Immediate need for a highly skilled stored proc developer to do database work for agg team in DB2*. Need to have *5 years of stored proc*, database sizing, table normalization, data warehouse, *DBA*, *DDL*, and some ground up Database work to move complex data roll ups from Java layer into the database. *Data warehousing* experience will be a big plus *SQL Server, Oracle, SSIS experience* is good to have. *Sample questions asked in last interview are below:* 1. Bind parameters, what they do in DB2, example of bind parameters. 2. What are declarations for table? 3. Type of updates to a table cursor? 4. How are stored procs created in DB2? 5. Experience in writing and dealing with Db2 cursors. 6. Scrubbing and manipulating data, need normalization, indexes, performing quick enough 7. What is actual structure of stored proc? 8. Indexes in Db2. *Thanks,* *Sumanth Pittu* *Talent Acquisition Manager* *732 777 0800 ext. 504* *Gtalk/Yahoo/Skype IM: sumanth.p151* *BSM* - 15 years in business with referable clients - Minority & Women Owned Business Enterprise - Microsoft & Oracle Certified Partner HQ: 2 Tower Center Blvd., 20th Floor, Suite # 2004 | East Brunswick, NJ – 08816 | United States Website <http://www.bsm.us.com/> | Facebook <https://www.facebook.com/pages/BSM-Business-Success-Management/186763063930> | LinkedIn <http://www.linkedin.com/company/bsm-business-success-management> | Twitter <https://twitter.com/BSM_now> The information contained in this e-mail transmission is confidential and may be privileged. It is intended only for the addressee(s) stated above. If you are not an addressee, any use, dissemination, distribution, publication, or copying of the information contained in this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify us in reply *with the word "REMOVE" in the subject line*. We apologize for inconvenience, if any caused. -- You received this message because you are subscribed to the Google Groups "it req" group. To unsubscribe from this group and stop receiving emails from it, send an email to it-req+unsubscr...@googlegroups.com. To post to this group, send email to it-req@googlegroups.com. Visit this group at http://groups.google.com/group/it-req. For more options, visit https://groups.google.com/d/optout.