Hello,
Local candidates highly preferred with strong Lead experience.
please share profiles to naren...@elementtechnologies.com 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 in OLTP environment for building Dimensional
Modeling, Database query tuning, Performance tuning of Reports and
troubleshooting Oracle Application issues on OLTP and DSS systems.*
*·* *Provided 24x7 supports to 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: naren...@elementtechnologies.com
Web: www.elementtechnologies.com
--
You received this message because you are subscribed to the Google Groups
"oraapps" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to oraapps+unsubscr...@googlegroups.com.
To post to this group, send email to oraapps@googlegroups.com.
Visit this group at https://groups.google.com/group/oraapps.
For more options, visit https://groups.google.com/d/optout.