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

30 Jun 2024

Vacancy expired!

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 OpeningJob Location :

REMOTE until Covid19 restriction is lifted and then ONSITE –

Candidate has to

located within 100 miles of radius to Harrisburg, PADuration : Long Term.Interview Type : Phone and Web/Zoom/VideoRate / 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),
  • OPENFORM, NEWFORM, CALLFORM,
  • 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

    DBMSSCHEDULER, UTLFILE, UTLSMTP, UTLMAIL, UTLTCP and DBMSSTATS.
  • Experience in writing

    dynamic SQL statements using

    EXECUTE IMMEDIATE and DBMSSQL.
  • 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 job

    s.
  • 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,PhEmail: ,Webste: www.lingatech.com