Oracle APEX, Forms & PL/SQL Developer

Company: LingaTech, Inc.
Location: Harrisburg
Posted on: May 9, 2022

Job Description:

Hi,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. I can be reached at 717-856-8189 any time / even after hours This is regarding a Urgent Job Opening - Oracle, PL/SQL, Forms & APEX Developer with - APEX, PL/SQL, Forms 11g, Reports 10g, Oracle 12c/11g/10g/9i/8i, PL/SQL, Toad, SQL Navigator, SQL Developer, Data Modeling, XML, HTML, APEX, Web Services, JAVA, API, SOA, Agile / Scrum Development methodologies Data Loader, Explain Plan, Cron Jobs, Scheduler, Schemas and UNIX SHELL Scripting) - needed --- Remote - "Candidate should be located within 3 hours drive to Harrisburg, PA Please call me for more details...Ph: 717-856-8189 or email me at sureshatlingatech.com Remote - "Candidate should be located within 3 hours drive to Harrisburg, PA (OR) Local Candidates preferred Title: Oracle, PL/SQL, Forms & APEX DeveloperLocation: Remote - "Candidate should be located within 3 hours drive to Harrisburg, PA (OR) Local Candidates preferred (OR) should Relocate right away"Duration: Long TermInterview Mode: Phone / Video / Skype# OF Openings: 6Start Date: ImmediateVisa Type: ANY - No Visa Restrictions -----------------------------------------------------------------------------------------------------------------------------------------------REQUIRED SKILLS:----------------------------------------------------------------------------------------------------------------------------------------------- Role Oracle, PL/SQL, Forms & APEX Developer - APEX, PL/SQL, Forms 11g, Reports 10g, Oracle 12c/ with 11g/10g/9i/8i, PL/SQL, SQL Developer, Toad, Data Modeling, XML, HTML, APEX, Web Services, JAVA, API, SOA, Agile / Scrum Development methodologies, SQL Navigator, Data Loader, Explain Plan, Cron Jobs, Scheduler, Schemas and UNIX SHELL Scripting) needed: 8+ years of very strong hands-on 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. 2+ years of Oracle APEX experience3+ years of designing and developing Oracle Forms & Reports using Forms11g and Reports 10g.Experience in designing screen layout in Oracle FORM.Experience in Oracle Forms 11G 3-Tier Architecture: UI - forms, Middleware (Oracle Web logic application server).Experience in 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 triggerexecution, Master-Detail relationship, Different triggers associated with Oracle Forms having a master-detail relationship. 8+ years of expert level experience Oracle database design and development.8+ extensive Experience in using Oracle 12c/11g/10g/9i/8i and tools like Toad, SQL Navigator and Data Loader.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, rtc.Experience with Agile / Scrum Development methodologies. 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: 717-856-8189,Email: suresh@lingatech.com,Webste: www.lingatech.com

Keywords: LingaTech, Inc., Harrisburg , Oracle APEX, Forms & PL/SQL Developer, IT / Software / Systems , Harrisburg, Pennsylvania