Oracle, APEX, Forms & PL/SQL Developer - APEX, Forms 11g, PL/SQL, Reports 10g, Oracle 12c/11g/10g/9i/8i, PL/SQL

Oracle Forms, Forms 11g, Reports 10g, APEX, Oracle 12c/11g/10g/9i/8i, PL/SQL, Toad, SQL Navigator, Data Loader, Explain Plan, Cron Jobs, Scheduler, Schemas, UNIX SHELL Scripting, REST-based APIs, Oracle middleware, Web Services Integration, JAVA, Javascript, XML, HTML, Web Services, API, SOA, SQL Loader, Data Modeling, Oracle databses
Contract W2, Contract Independent, Contract Corp-To-Corp, 12 Months
$55 - $60
Work from home available

Job Description

Hi,

This is regarding a Urgent Job Opening – Oracle, APEX, Forms & PL/SQL Developer - APEX, Forms 11g, PL/SQL, Reports 10g, Oracle 12c/ /11g/10g/9i/8i, PL/SQL, Toad, SQL Navigator, SQL Loader, Data Loader, Data Modeling, Explain Plan, Cron Jobs, Scheduler, Schemas, UNIX SHELL Scripting, REST-based APIs, Oracle middleware,  Web Services Integration, JAVA, Javascript, XML, HTML, APEX, Web Services, JAVA, API, SOA - needed --- REMOTE Candidate has to be located within 2.5 hours Drive to Harrisburg, PA - Long Term Contract.

 

 

Please go through the complete job description thoroughly. If you are interested, please go ahead and send me your most recent updated resume along with your Contact#'s, hourly rate / salary expectation, visa status and your current location.

 

Start Date                   :  Immediate

# of positions             :  1 Opening

Job Location               :  REMOTE until Covid19 restriction is lifted and then ONSITE – Candidate has to located within 100 miles of radius to Harrisburg, PA

Duration                      :  Long Term.

Interview Type           :  Phone and Web/Zoom/Video

Rate / Salary               :  Competitive 

Candidate Type          :  ANY – H1b, TN1, , Citizens

 

-----------------------------------------------------------------------------------------------------------------------------------------------

REQUIRED SKILLS:

-----------------------------------------------------------------------------------------------------------------------------------------------

 

Role: Oracle, APEX, Forms & PL/SQL Developer with APEX, Forms 11g, PL/SQL, Reports 10g,  Oracle 12c/ with 11g/10g/9i/8i, Toad, SQL Navigator, SQL Loader, Data Loader, Data Modeling, Explain Plan, Cron Jobs, Scheduler, Schemas, UNIX SHELL Scripting, REST-based APIs, Oracle middleware,  Web Services Integration, JAVA, Javascript, XML, HTML, APEX, Web Services, JAVA, API, SOA needed:

 

Technical Requirements:

  • 8+ years of Oracle databases design and development.
  • 5+ years of strong hands-on skills with PL/SQL.
  • 5+ years of expertise in designing and developing Oracle Forms & Reports using Forms11g and Reports 10g.
  • 2+ years of strong hands-on APEX experience is a MUST.
  • 3+ years of JAVA and Javascript
  • Strong Oracle database skills with WEB-based application development skillswould be a good combination.
  • Experience developing or using REST-based APIs or using Oracle middleware products.
  • Strong experience using SQL Developer / TOAD.
  • Understanding of Data Modeling.
  • Understanding of Web Services Integration.
  • Performance Tuning, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server.
  • Very good hands-on experience with Data Modeling, XML, HTML, APEX, Web Services, JAVA, API, SOA, etc.
  • Experience with Agile / Scrum Development methodologies.
  • 5 years of experience in designing screen layout in Oracle FORM.
  • Heavy hands-on skills in Oracle Forms 11G 3-Tier Architecture:
  • UI – forms,
  • Middleware (Oracle Web logic application server),
  • Blocks, Triggers, Program Units,
  • Canvas in Forms,
  • Canvas (Content, Tab, Toolbar & Stacked),
  • Canvas pages,
  • Blocks (it’s item/columns),
  • Alerts (Pop- up, notification for message and error handling),
  • LOV (List Of Values),
  • OPEN_FORM, NEW_FORM, CALL_FORM,
  • Oracle Forms for trigger execution,
  • Master-Detail relationship,
  • Different triggers associated with Oracle Forms having a master-detail relationship.
  • Very strong hands-on skills in Oracle APEX.
  • 6+ years of expert level experience Oracle database design and development.
  • 6+ extensive Experience in using Oracle 12c/11g/10g/9i/8i and tools like Toad, SQL Navigator and Data Loader.
  • 6+ years of experience using PL/SQL: writing and creating Stored Procedures, Triggers, Functions AND Packages.
  • Expertise in Creating and Maintaining Database objects like Tables, Indexes, Views, synonyms etc.
  • Experience with developing PL/SQL applications using TOAD.
  • Work on PL/SQL objects and query optimization techniques.
  • Extensive experience in using Oracle seeded packages like DBMS_SCHEDULER, UTL_FILE, UTL_SMTP, UTL_MAIL, UTL_TCP and DBMS_STATS.
  • Experience in writing dynamic SQL statements using EXECUTE IMMEDIATE and DBMS_SQL.
  • Experience in tuning SQL statements using EXPLAIN PLAN.
  • Expertise in loading data from flat files to the Database Tables using SQL * LOADER and EXTERNAL TABLE.
  • Knowledge of UNIX SHELL Scripting and scheduling CRON jobs.
  • Experience in using Oracle concepts Like Table Partitioning, Optimizer hints and Materialized Views (Snapshots).
  • Expertise in using latest features to Optimize Performance (Bulk Collects, Collections, Ref Cursors, Materialized views and Global Temporary Tables.
  • Extensive experience in Project Life Cycle including requirement gathering and Analysis, Database design, Database development, Application development, Test and Support.
  • Expertise in Creating User Schemas and giving them set off permissions.
  • Proficient in writing and tuning Multi-Complex SQL statements, complex joins co-related sub-queries and SQL statements with Analytical functions (Rank, Lead, Lag etc).
  • Experience in Implement high quality and maintainable code.
  • Translate business requirements into development strategies.
  • Work with business users to clarify the requirement.
  • Provide accurate and timely estimates (work breakdown schedules).
  • Document and executes unit and integration tests.
  • Supports the needs and requirements of other applications team.
  • Working knowledge on using new partitioning techniques like Interval, reference and extended composite (List-List, List-Range) partitioning.
  • Strong analytical problem solving and communication skills.
  • Strong in developing efficient logical code for a given specific task.

 

 

Regards,

Suresh,

Recruiting Manager,

Linga Tech Inc,

Ph

Email: ,

Webste: www.lingatech.com

Dice Id : 90957255
Position Id : 7068647
Originally Posted : 10 months ago
Have a Job? Post it

Similar Positions

Oracle Forms & Reports Developer (REMOTE)
  • Super Technology Solutions, Inc.
Oracle Forms & Reports Developer
  • Solomons International
Oracle Forms & Reports developer
  • HSK Technologies, Inc.
Oracle PL/SQL Developer
  • Tucker-Rose Associates, LLC
Oracle SOA Developer
  • nTech Solutions
  • Rockville, MD, USA
Oracle Database Developer
  • Take2 Consulting