Hi,
This is regarding a Urgent Job Opening – Oracle Forms / APEX Developer with Forms 11g, Reports 10g, APEX, Oracle 12c/11g/10g/9i/8i, PL/SQL, Toad, SQL Navigator, Data Loader, Explain Plan, Cron Jobs, Scheduler, Schemas and UNIX SHELL Scripting) - needed --- REMOTE until Covid19 restriction is lifted and then ONSITE – Candidate has to located within 100 miles of radius to Harrisburg, PA - Long Term Contract.
Please call me for more details...Ph or email me at sureshATlingatechDOTcom.
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, EAD, Green Card, Citizens
-----------------------------------------------------------------------------------------------------------------------------------------------
REQUIRED SKILLS:
-----------------------------------------------------------------------------------------------------------------------------------------------
Role: Oracle Forms / APEX Developer with Forms 11g, Reports 10g NEEDED with APEX, Oracle 12c/ with 11g/10g/9i/8i, PL/SQL, Toad, SQL Navigator, Data Loader, Explain Plan, Cron Jobs, Scheduler, Schemas and UNIX SHELL Scripting) needed:
Technical Requirements:
- 5+ years of expertise in designing and developing Oracle Forms & Reports using Forms11g and Reports 10g.
- 3 years of APEX.
- 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.
,
Suresh,
Recruiting Manager,
Linga Tech Inc,
Ph,
Email: ,
Webste: