IDC Technologies’ direct client is looking for below onsite position:
*Job Title:* Senior Oracle PL/SQL Developer *Location:* St. Louis, MO *Duration:* Onsite Long term Contract Note: *H1B copy is must and shre resume at *[email protected] *Job Description: * · Minimum 8+ years of programming experience as an Oracle PL/SQL Developer. · Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. · Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD or SQL*LOADER. · Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. · Create Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based). · Develop Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL and creation of Oracle Objects like Materialized Views, Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections. · Develop materialized views for data replication in distributed environments. · Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. · Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. · Create Packages and Procedures to automatically drop table indexes and create indexes for the tables. · Work extensively on Ref Cursor, External Tables and Collections. · Hands-on experience with Oracle Reports, SQL, PL/SQL, Open Interfaces, and APIs. · Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes. · Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS. · Knowledge on Oracle SOA Suite, Orchestration and Integration Technologies. · Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team *Preferred:* Certification is preferred In case this position interests you please share below details to save on you valuable time; Pay rate expectations: Notice period: Work Authorization status: Current Location: Also share your updated resume to Nitish Rajput at *[email protected]* <[email protected]> Regards: Nitish Rajput *IDC Technologies Inc. | *1851 McCarthy Blvd, Suite #116, Milpitas, CA 95035 Email: [email protected] -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/oracle-users. For more options, visit https://groups.google.com/d/optout.
