Urgently Req // Sr. Oracle PL/SQL Developer // Portland, OR // 12 months

Please forward the resumes to veena@alliedinformatics.com

Job Title : Sr. Oracle PL/SQL Developer

Location : Portland, OR

Duration : 12 months

· Hands on experience on new features of Oracle 10g and 11g

· Gathered business requirements and created Business flow charts, issues and converted them into back-endcode.

· Coordinated and monitored release deployment during the mock and production windows.

· Created Logical and physical designs for OLTP, OLAP and DSS models.

· Expert in doing the data analysis and digging to find out the dependent fields for transformations and

manipulations of data.

· Designed, developed, debugged Packages, triggers, views, tables, indexes, pipe functions, types, XML quires and optimized SQL and Pl/sql code to reduce CPU Overhead, Buffer cache(LIO), Disk read(PIO), consistent read and concurrent read, latch contention using AWR, ADDM, Sql Tuning Advisor, Explain plan(Oracle plan execution), Session snapper scripts, SQL trace, TKprof, Hints, Analytical functions and parallel techniques for Prescription drug event loading, calculating pde event cost in different phases for the member and Plan by considering various business constraints .

· Outlined and created Portioned strategies and materialized view For performance, Data Archive and

replication environment

· Extensively used cursors, collections, Bind variables and Bulk technics to reduce loop overhead

· Created front-end forms and reports by .SCR and .RPT XML files using Jdevloper JAVA frame work.

 

Thanks & regards

Veena Nath

Allied Informatics Inc.

Ph: 770-246-9800 x121  Fax No. 770-246-9098

1815 Satellite Blvd. Suite 302

Duluth, GA 30097 USA.
Email: veena@alliedinformatics.com  URL: www.alliedinformatics.com

Gtalk :- Veena.recruiter27@gmail.com

 

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at http://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.