| HIRING NOW::Oracle APEX Developer::REMOTE(LOCAL FROM PA) at Apex, North Carolina, USA |
| Email: [email protected] |
| From: Sam, Vyze Inc [email protected] Reply to: [email protected] Job Description - Title: Sr. Oracle APEX Developer with Forms, Reports & PL/SQL Location : Remote ( LOCALS ONLY ) Duration: Long term Interview: Webcam Visa : USC /GC /GCEAD/H4EAD MUST HAVE : 10+ years of exp in Information Technology , Candidates should be located within 3 hours drive to Harrisburg, PA , candidate have to updated there resume as sample resume format Sr. Oracle APEX Developer with Forms, Reports & PL/SQL needed Oracle APEX,Oracle Forms 11g, Reports 10g, PL/SQL, Oracle 12c/11g/10g/9i/8i, 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 REQUIRD SKILLS : 10+ years of very strong hands-on experience in Oracle databases design and development and PL/SQL: 7+ years of Oracle APEX experience REQUIRED / MUST. 2+ years of designing and developing Oracle Forms & Reports using Forms11g and Reports 10g. 7+ years of very strong hands-on experience using PL/SQL. ---------------------------------------------------------------------------------------------------------------------------------------------- 7+ years of designing and developing Oracle APEX heavy hands-on experience is a MUST / REQUIRED ---------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------- 2+ 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 (its 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. -------------------------------------------------------------------------------------------------------------------------------------------- 10+ years of very strong hands-on experience in 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. ----------------------------------------------------------------------------------------------------------------------------------------------- 10+ years of expert level experience Oracle database design and development: ------------------------------------------------------------------------------------------------------------------------------------------------ 10+ 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, etc. 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 techniqueslike 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. Keywords: user interface information technology green card procedural language Colorado Pennsylvania |
| [email protected] View all |
| Thu Feb 15 20:25:00 UTC 2024 |