Oracle PL/SQL Developer Job at SysMind Tech, Irvine, CA

Mm1IVEE5Z0tFdkcvbFJzWDNsUWF5SElVQ1E9PQ==
  • SysMind Tech
  • Irvine, CA

Job Description

Roles & Responsibilities Oracle PL/SQL Developer with 10+ years of experience in Design & Development of N-tier Client Server applications. Expertise in SQL, Advanced Oracle PL/SQL, Database Performance Tuning & Optimization of SQL, UNIX and Shell Scripting . Excellent communication and interpersonal skills and team player. Flexible and capable to work in cross platform environments. Strong knowledge in Oracle 12c/11g/10g/9i/8i database programming using PL/SQL (Stored Procedures, Functions, Triggers, Cursors, Packages, PL/SQL collections) and standard Built-in Oracle Packages . Experience in developing robust and highly scalable applications based on Microservice architecture using Spring Boot and REST API's. Experience in PL/SQL and Query optimization . Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS. Used ETL features like Merge, SQL loader, external tables, pipelined/table functions. Experience with PL/SQL Developer and TOAD . Hands on experience in Oracle Retail Predictive Application Server (RPAS). Works under 24/7 Shift and co-ordination with onsite team for issues tracking and trouble shooting. Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data. Experience in supply chain and retail domain especially in the Logistics area . Hands on experience in the oracle forms and reports 6i in development and support . Hands on experience in the Data Conversion and Data Analysis. Using EXPLAIN PLAN or tuning SQL and PL/SQL code for better performance with the help of Hints, Bulk collection techniques and Indexes. Developed materialized views for data replication in distributed environments. SysMind Tech

Job Tags

Flexible hours, Shift work,

Similar Jobs

Soliant

Occupational Therapist (School-Based) - OT in Danville Job at Soliant

 ...Job Description Job Description Minimum 1+ years occupational therapy experience required. Position: School-Based Occupational Therapist (OT) Company: Soliant Location: Danville, VA About Us: Soliant is a distinguished healthcare staffing agency, committed... 

WELLS

SALES REPRESENTATIVE II Job at WELLS

 ...GENERAL DESCRIPTION The Sales Representative II is responsible for developing profitable projects and be accountable for select client...  ...~ Wellness Incentives ~ Paid holidays ~ Flex spending for medical and daycare ~ Health savings account (HSA)~401(k) plan with... 

CDI Engineering Solutions

Electrical and Instrumentation Engineer Job at CDI Engineering Solutions

 ...Electrical and Instrumentation Engineer CDI Engineering Solutions Westlake, LA 12-18 Month Contract Together We Make Life Better . Our quality...  ..., logic diagrams, loop sheets, specification sheets, power schematics, one-lines diagrams, etc. for electrical,... 

NorthShore

Cardiologist Job at NorthShore

 ...Position Highlights: Position: Cardiologist Location: Glenbrook Hospital, Glenview, IL Full Time/Part Time: Full Time Hours: Monday-Friday, (hours and flexible work schedules) Travel required, Skokie, IL A Brief Overview: Endeavor Health is a fully... 

Uber

Uber Driver: You Could Earn $20.57 Per Hour In Farmers Branch Job at Uber

 ...operator, shuttle driver, bus chauffeur) you might also consider driving with Uber to earn extra money. We also welcome drivers who have worked with other peer-to-peer ridesharing or driving networks. Drivers using the Uber platform come from all backgrounds and industries...