Oracle PL/SQL Developer -- Alpharetta, GA/Berkeley Heights, NJ
Envision Technology Solutions · Berkeley Heights, NJ · 3 days ago
On-siteEngineeringFull-time
Hi, Hope you are doing well. We have the below requirement with my client, please let me know if you are looking for a job. Job Title : Oracle PL/SQL Developer Location : Alpharetta, GA/Berkeley Heights, NJ Hire Type : Long Term Contract Job Summary 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 Key Responsibilities 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 toolsData 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 dataCollaboration & 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. Core Technical 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. Saurabh Kumar Team Lead – Recruitment Envision Technology Solutions Direct Number+1 704 745 4743 Email: saurabh.kumar@envisiontechsol.com