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
Click
here to apply!
|