PL/SQL Developer

Envision, Inc

Fanwood, NJ, United States

3 days ago

Apply on www.disabledperson.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

8 years minimum

Working hours

Regular working hours

Job source

www.disabledperson.com

Tech stack

Java (Programming Language) Application Programming Interfaces (APIs) Amazon Web Services Amazon S3 Business Logic Unix Databases Continuous Integration Data Governance Data Integration Extract Transform Load (ETL) Data Migration

+21 more

Relational Databases Database Queries DevOps Python (Programming Language) Automation of Marketing Oracle Databases Oracle (Applications) Oracle SQL Developer Performance Tuning Application Data SQL Stored Procedures PL-SQL Scripting Cloud Platform System Analytic Functions Backend Amazon Relational Database Service Toad (Software) Database Rules and Triggers Oracle Cloud Infrastructure Software Version Control

Job description

We are seeking a highly skilled Oracle SQL/PL-SQL Developer to design, develop and manage high-performance relational database solutions. You will be responsible for creating robust data models, writing advanced server-side programmatic logic, and aggressively tuning complex queries to ensure maximum data throughput and application stability, * Database Programming: Design, write, and maintain robust, high-performance database objects like stored procedures, packages, functions, and database triggers.

Business Logic Integration: Code complex business rules directly into the Oracle database layer using PL/SQL for security and processing speed.
Performance Tuning: Diagnose, troubleshoot, and optimize sluggish SQL statements using available tools
Data Modeling: Design efficient relational database architectures including schemas, tables, primary/foreign key relationships, and indexes.
ETL Pipeline Development: Build, manage, and scale Extract, Transform, Load (ETL) data integration workflows to ingest external application data
Collaboration & Integration: Interface with backend application developers (e.g., Java engineering teams) to align front-end APIs with data tier structures.
Migration & Maintenance: Author deployment scripts, execute data migration runs, and maintain comprehensive schema version control.

Requirements

Oracle Database Expertise: Proficient experience with recent versions (e.g., Oracle 19c or 21c).
Advanced PL/SQL Mastery: Proven capability utilizing collections, bulk operations, analytical functions, and ref cursors.
Tuning Methodologies: Hands-on experience partitioning tables, managing optimizer statistics, and modifying query execution paths.
IDE Tools: High familiarity with database interfaces, specifically Oracle SQL Developer, Toad, or PL/SQL Developer.
Scripting Language : High familiarity and experience with UNIX scripting.

Preferred / “Nice-to-Have” Skills

Cloud Environments: Experience managing or mapping databases on cloud infrastructures like AWS (Amazon RDS/S3) or Oracle Cloud Infrastructure (OCI).
Complementary Languages: Basic competency with Python, or core Java.

CI/CD Paradigms: Understanding of DevOps data practices such as database version