Sr. PL/SQL Developer Positions: 2
*Start: Middle of October * End: Through April 2014 Location: Pleasanton, California 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. * *Please send the resume to k...@alliedinformatics.com * Thanks & regards Moiz Khan Allied Informatics Inc. 1815 Satellite Blvd. Suite 302 Duluth, GA 30097 USA. Ph: 770-246-9800 x117 Fax No. 770-246-9098 Email: k...@alliedinformatics.com <kal...@alliedinformatics.com> URL: www.alliedinformatics.com YM :- moizkhan_recruiter Gtalk :- recruiterkhan.it http://in.linkedin.com/pub/moiz-khan/29/952/1a6 Note : We respect your on line privacy. This is not an unsolicited mail.Please reply with Removal instructions in subject line incase your email address to be removed from this mailing list -- You received this message because you are subscribed to the Google Groups "SAP-UK" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-uk+unsubscr...@googlegroups.com. To post to this group, send email to sap-uk@googlegroups.com. Visit this group at http://groups.google.com/group/sap-uk. For more options, visit https://groups.google.com/groups/opt_out.
