Apply on Employer Site

Peer Consulting Resources Inc. · 5 hours ago

PL/SQL Developer

Brooklyn, NY

Contract

Onsite

Senior Level

5+ years exp

Peer Consulting Resources Inc. is a consulting firm specializing in database solutions, and they are seeking a PL/SQL Developer to join their team. The role involves Oracle database development, including data modeling, SQL/PLSQL development, and production support.

AdviceConsultingInformation TechnologySoftware

H1B Sponsor Likely

Hiring Manager

Christy Vimala

Responsibilities

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

Qualification

PL/SQL programmingOracle database developmentSQL query optimizationOracle REST Data ServicesData modelingAPI managementSoft skills

Required

5+ Years of experience in 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

Company

Peer Consulting Resources Inc.

Founded in 2011

Princeton, New Jersey, USA

11-50 employees

https://www.peer-consulting.com

H1B Sponsorship

Peer Consulting Resources Inc. has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (12)

2024 (12)

2023 (4)

2022 (11)

2021 (3)

2020 (11)

Funding

Current Stage

Early Stage

Leadership Team

Vivek Philar

Chief Executive Officer

Company data provided by crunchbase