Sr. PL/SQL Developer Job at Pentangle Tech Services | P5 Group, Brooklyn, NY

ZExYRDZ5QXh0ck9LSFdYYyt4akhiaXZ3ZlE9PQ==
  • Pentangle Tech Services | P5 Group
  • Brooklyn, NY

Job Description

Sr. PL/SQL Developer

  • Oracle database development life cycle, including data modeling, architecture design, SQL/PLSQL development, unit testing, and production support.
  • Good exposure of new Oracle version’s inbuilt functions and features.
  • Create, enhance, and maintain reusable database objects.
  • Perform SQL query optimization and tuning to maximize speed and scale.
  • Apply working knowledge of Oracle REST Data Services (ORDS) and API Gateway Cloud for database integration and API management.
  • Demonstrate deep expertise in PL/SQL programming, covering:

Advanced data types – BLOBs CLOBs, cursors, and exception handling. Collections and merge statements

Analytic functions, Index, views, and materialized views. Table functions, stored procedures, functions, and packages. Database triggers and dynamic SQL. External tables and object programming. SQL built-in functions, joins, and aggregate functions. Comprehensive performance tuning techniques

Job Tags

Similar Jobs

Inova

Biomedical Engineer 2 Job at Inova

 ...Inova Fairfax Hospital Clinical Engineering is looking for a Biomedical Engineer 2 to join the Team. This role will be full-time day-shift from Monday - Friday. The Biomedical Engineer 2 is responsible for the preventative maintenance and repair of medical equipment... 

Cella

Recipe Editor (Remote) Job at Cella

 ...client, we are in search of an organized and detail-oriented Recipe Editor to join their growing Editorial Team. The ideal candidate...  ...Microsoft Word, Excel, Google Docs, and Adobe InDesign. Skilled in copy editing, proofreading, AP style , and ensuring adherence to... 

Trillium Construction Services

Field Technician Job at Trillium Construction Services

Trillium Construction is now hiring Fleet Technicians! We are looking for Fleet Technicians to support the field operation, diagnostics, and maintenance of our robotic and high-tech mechanical fleet assets in and around the Austin area. This role requires a unique combination...

Aims Community College

Part-Time: Assistant Instructor, Police Academy Job at Aims Community College

 ...search field located on the top center of the screen. For assistance, please contact the recruitment team at (***) ***-****. Minimum...  ...necessary to be successful in this position. Assistant instructors support the lead Police Academy instructor in developing the... 

Relay Express, Inc.

Warehouse Operations Manager-Early AM Job at Relay Express, Inc.

 ...focus of this position is to maintain contractor and employee relationships in order to...  ...SOP and ensure all inbound and outbound deliveries are completed daily. Responsible for...  ...relationships locally that include the1099 Independent Contractor pool Other duties as...