*Hello,* *we have very urgent position from my direct Client based in Bridgewater NJ, so please share me rite profile to [email protected] <[email protected]> ASAP.*
*STRONG LEAD EXP IS MUST * *NEED LOCAL WITH* *OLTP,OLAP EXP IS MANDATORY * *Position : ORACLE PL/SQL* *Location : Bridgewater NJ* *DURATION : Long term* * AWR reports and SQL Monitoring to debug performance issues is plus.* *The ideal candidate will be lead in gathering requirements, analyze requirements. Development includes fine tuning of PL/SQL packages, stored procedures, functions, and triggers. The ideal candidate will be well versed in both SQL and PL/SQL development, tuning and optimization techniques. Distributed System (Cloud), and Big Data technologies are a plus. * *· Worked in high transacted OLTP & OLAP environment that includes Prod (24x7), QA and Dev.* *· Experience inOLTP environment for buildingDimensional Modeling,Database query tuning, Performance tuningof Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.* *· Provided 24x7 supportsto OLTP and OLAP environment when required* *In this role you will:* *• Provide PL/SQL development, support and maintenance; SQL tuning and optimization techniques* *• Utilize Oracle and other related technologies tools for performance tuning (ie, Explain Plan, PL/SQL Optimizer, DBMS-TRACE packages, AWR reports, SQL Monitoring etc.)* *• Perform stored packages, procedures, functions and trigger development in support of an enterprise level, multi-user, data aggregation, analysis, and reporting system using Oracle and Oracle RAC* *Basic Qualifications:* *• Bachelor’s or Master's Degree in Computer Science or Related Technical Field or Equivalent Experience* *• Must have experience with Java to oracle communication using JDBC drivers.* *• Must have an extensive knowledge of oracle triggers* *• Must have an experience with full and incremental data sync with oracle or other databases* *• 8+ Years experience implementing, supporting, maintaining, and optimizing SQL queries and related database technologies* *• 8+ Years experience utilizing SQL tuning tools (ie SQL Developer, Toad, etc)and developing, tuning and maintaining PL/SQL stored packages, procedures, functions, and triggers* *• 8+ Years experience using Oracle Explain Plan and/or PL/SQL Optimizer for PL/SQL and SQL tuning.* *• 8+ Years experience in fine-tuning SQL and PL/SQL loops, regular expressions, conditional/case statements, etc.* *Thanks & Regards* *Narendra* *Element Technologies Inc.* * 15 Corporate Place South, Ste 209 Piscataway, NJ - 08854* *Phone: 732-562-1005 Ext. 307* *Email: **[email protected]* <[email protected]> *Web: www.elementtechnologies.com <http://www.elementtechnologies.com/> * -- You received this message because you are subscribed to the Google Groups "Exact Match" 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 https://groups.google.com/group/exact-match. For more options, visit https://groups.google.com/d/optout.
