*Visa copy & PIA must for submission* *GCEAD/GC/USC** Only*
*Job Title:** Oracle Developer* *Duration:3 months* *Location:**Stamford, CT, US* *Qualifications:* The candidate for the above-captioned position should exhibit the following requirements:- Prepare finalized solution approach for the RighTrack II Oracle database. RighTrack II currently uses Oracle 10g with the optimizer_features_enable set to only ‘8.1.7’. The target state is to reside on Oracle 12c and leverage the latest enhancements to the Oracle optimizer. Place under analysis the critical and most frequently executed SQL statements in the system. Document the execution times observed in the present 10g environment and measure this against the times observed in an Oracle 12c environment. Solving poor performing queries will involve SQL and table object modifications to ensure SQL queries perform as well or better in the 12c environment. Recommendations should be made if gains can achieved even in cases where the execution times perform as well as the 10g environment. *Summary of qualification:* Strong experience developing and optimizing SQL queries in the latest Oracle RDBMS environments Strong experience analyzing query execution paths using Explain Plan Understanding of the Oracle cost-based optimizer and statistics Strong experience solving non-optimal execution paths Strong experience writing and maintaining stored PL/SQL Experience in performance tuning Upgrade experience is a must from 10g to 12c is desirable *Technical skills:* Language: SQL and PL/SQL Software: Toad, Oracle SQL Developer, SQL/Plus Database: Oracle OS: Windows, Linux, Unix Server: Oracle *Need following details for quick process:* *Full Name:* *Contact:* *Email:* *Current location(city & state):* *Relocation:* *Availability:* *Visa Status:* *Skype Id:* *Education:* Regards Syam Krishnan *Technical Recruiter* *Join my groups to receive my requirements everyday * *https://groups.google.com/d/forum/erp-non-erp-req* <https://groups.google.com/d/forum/erp-non-erp-req> || *Tel : **703-831-8282 Ext: 241* ||*s...@canopyone.com* <s...@canopyone.com> | -- You received this message because you are subscribed to the Google Groups "SAP Resource Center" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-resource-center+unsubscr...@googlegroups.com. To post to this group, send email to sap-resource-center@googlegroups.com. Visit this group at https://groups.google.com/group/sap-resource-center. For more options, visit https://groups.google.com/d/optout.