Please share the Profile------- <[email protected]> [email protected] <[email protected]>
*Title : Sr. PL/SQL Developer* *Duration : 6+ Months* *Location : Pleasanton, California* Positions: 2 EAD/GC/Citizen Here's a little background on the project: The CA Diamond 950 Scalability project is to remediate the existing legacy application to scale to handle a membership volume of 1.9MM members and an annual claims/encounters receipt volume of at least 17MM transactions by 1/1/2014, and a membership volume of 7MM members and an annual claims/encounters receipt volume of at least 100MM transactions by 1/1/2015. Required skills: - 10 years of extensive hands-on experience with *performance tuning* of SQL and PL/SQL for Oracle 10g DB-based applications in fast-paced, dynamic optimization projects. - Must have strong analytical skills with solid design and development skills implementing complex business logic, with experience in converting nested PL/SQL into plain SQL, - addressing performance impacts with functional indexes and different types of joins, and using Hints for Query Optimizer. - Must have experience performing extensive sql tuning utilizing SQL Trace, TK Prof, Explain plan, V$ views to optimize database and application performance. - Experience with design and development of automated text scripts for verification of business logic is a plus. Top 3 - 5 Daily responsibilities are: a) Analysis of Oracle PL/SQL code for performance impacts, b) reviewing execution plans and identifying potential problems, c) coding and unit testing application code to address performance impacts, d) create and enhance stored PL/SQL routines, triggers, and SQL*Loader scripts for data loads/data validations/summaries and business rule implementation, and, e) SQL and application tuning using SQL Trace, Explain, etc. Key issues for Technical Screening: *- Must have strong Performance Tuning and not just basic development experience. * MUST HAVE VERY STRONG COMMUNICATION SKILLS *Alok Kumar* Source InfoTech Inc. Cell---732-692-8205 Fax: 732-909-2282 Email: [email protected] <[email protected]> IM---kumaralok.recruiter [email protected] -- You received this message because you are subscribed to the Google Groups "Oracle Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oracle-users. For more options, visit https://groups.google.com/groups/opt_out.
