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 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.
- ID: #43716856
- State: Pennsylvania Harrisburg 17101 Harrisburg USA
- City: Harrisburg
- Salary: $55 - $60
- Job type: Contract
- Showed: 2022-06-30
- Deadline: 2022-08-28
- Category: Web/HTML/info design