Dear Partner, *ZionTech Solutions, Inc* is a highly recognized provider of professional IT Consulting services in the US.
Here is our open requirement which can be filled immediately. Kindly respond to this requirement with your *consultant resume, contact and current location* info to *speed up the interview process. * *You can reach me on 408 599 7639 and Send resumes to * *prad...@ziontechsolutions.com <prad...@ziontechsolutions.com> * *PL/SQL Developer* *Atlanta, GA* *6+ months (will be extended up to 1 and 2 years)* *No of positions : 5* The resource will perform code reviews of existing software as well as perform complex development functions within a Data Migration project. Technical Analyst/Architect needed to assist with Peformance Tuning and Maintenance of Oracle PL/SQL Stored Procedures. Skills: 4-5 years of experience with Oracle, Oracle PL/SQL, Technical Analysis and performance tuning, development of complex stored procedures/functions with parallel processing, Application Architecture, Data Migration or Conversion. Implicit and explicit cursors, Procedures, Functions, Parameters-Procedure, Exception Handling, Triggers, Collections (Associative arrays, Nested tables, VARRAYs), Manipulating Large Objects (LOB object, BFILEs, SecureFile LOBs), DB Index, knowledge in different types of SQL JOINS, Using Advanced Interface Methods (Calling External Procedures from PL/SQL, C advanced interface methods, Java advanced interface methods), good knowledge in SQL Functions, Performance and Tuning like Understand and influence the compiler, Tune PL/SQL code, Enable intra unit inlining, Identify and tune memory issues, Recognize network issues, Improving Performance with Caching, Describe result caching, Use SQL query result cache, PL/SQL function cache, Review PL/SQL function cache considerations, Analyzing PL/SQL Code (Using DBMS_DESCRIBE, Using ALL_ARGUMENTS, Using DBMS_UTILITY.FORMAT_CALL_STACK, Collecting PL/Scope Data, The USER/ALL/DBA_IDENTIFIERS Catalog View and DBMS_METADATA Package ), Profiling and Tracing PL/SQL Code (Tracing PL/SQL Execution, Tracing PL/SQL: Steps). Thanks & Regards, *Pradeep,* || Technical Recruiter ||*ZionTech Solutions ,Inc* || *|| Tel :* 408-599-7639 || *GTalk:* pradeepzion1 || || prad...@ziontechsolutions.com | *LinkedIn: *http://www.linkedin.com/pub/pradeep-goud/38/876/6ab *Disclaimer:* If you have received this email in error or prefer not to receive such emails in the future, please reply with "REMOVE" in the subject line. All remove requests will be honored ASAP. We sincerely apologize for any inconvenience caused. -- 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 oracle-users+unsubscr...@googlegroups.com. To post to this group, send email to oracle-users@googlegroups.com. Visit this group at http://groups.google.com/group/oracle-users. For more options, visit https://groups.google.com/d/optout.