Hi There,
Dear Partner,
Vaptech Inc is a leading consulting firm located in New Jersey. We Provide End to End applications for various industry domains - finance, insurance, retail, and healthcare.
Please submit resumes for the below Requirement.
| Job Title: | Sr. PL/SQL Developer |
| Primary Skills: | ORACLE,PL/SQL,SQL,TESTING |
| Secondary Skills: | 1+ Years of Exp is a MUST |
| Rate: | 75/hr |
| Duration: | 6-9 Months |
| Location: | Pleasanton, California |
| Description: | Sr. PL/SQL Developer
Positions: 2
Start: Middle of October (SOW has to be signed)
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. |
| | Click here to submit for this position online and to speed up the process. |
Thanks and Regards,
Harry
Vaptech Inc.
15Corporate Place South, Suite #201
Piscataway,NJ-08854
Phone:732-767-0700 X 3007
Fax:732-767-9669
www.vaptech.com
harry@vaptech.com
Skype:Hemant1801
--
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to it-jobs-in-usa@googlegroups.com.
Visit this group at
http://groups.google.com/group/it-jobs-in-usa.
For more options, visit
https://groups.google.com/groups/opt_out.
No comments:
Post a Comment