PL/SQL Developer

Overview

On Site
Accepts corp to corp applications
Contract - longterm

Skills

ORACLE
DATA MODELING
SQL
STORED PROCEDURES
REST
PL/SQL
UNIT TESTING
PERFORMANCE TUNING
API
DATABASE
data services
API Gateway
Database modeling
LIFE CYCLE
CREDIT ISSUES
WEB Database

Job Details

Sr. PL/SQL Developer(Local to Brooklyn NY)

Location- Brooklyn NY 11201

Mode of hire-Contract

Mode Of Work- Hybrid- (Tuesday, Wednesday and Thursday onsite)

Interview: First Round Virtual followed by Onsite interview

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.