Oracle PL/SQL Developer

Oracle PL/SQL Developer

Posted 5 days ago by 1752212943

Apply
Negotiable
Outside
Remote
USA
Apply
Automation Data Analysis Data Definition Language Data Modeling Debugging Dynamic Queries Error Messages Exception Handling Extensible Markup Language (XML) File Servers Generic Programming Java (Programming Language) Oracle Aq Performance Tuning PL/SQL Query Performance Server-Side Software Coding Software Development SQL (Programming Language) SQL*Plus Unix Unix Shell

Summary: The Oracle PL/SQL Developer role requires a seasoned professional with over 8 years of experience in Oracle server-side programming and PL/SQL development. The position emphasizes strong skills in data analysis, automation, and performance tuning, alongside hands-on experience with XML generation and exception handling. The role is remote and classified as outside IR35, indicating a flexible working arrangement and independent contractor status.

Key Responsibilities:

  • At least 8+ years of experience as an Oracle PL/SQL Developer.
  • Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, Job, Schedulers, PL/SQL Web-services, Java Stored Procedures and Oracle AQ.
  • Hands on experience on XML generation inside PL/SQL components.
  • Strong Skills in data analysis, data modeling, development, testing and documentation.
  • Strong skills on automating jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking SQL *Plus.
  • Hands on writing Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets, Arrays & Queues.
  • Strong Skills in Exception Handling extensively debug PL/SQL Code, DDL, DML and display the error messages in the application.
  • Experience in creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
  • Experience in SQL Tunning to improve the query performance by identifying key fields, adding/removing tables/fields, and use of indexes.
  • Good understanding of Oracle Explain Plan.

Key Skills:

  • 8+ years of experience as an Oracle PL/SQL Developer.
  • Strong skills in Oracle server-side programming (SQL, SQL*Plus, PL/SQL Packages, etc.).
  • Experience with XML generation in PL/SQL.
  • Data analysis, modeling, development, testing, and documentation skills.
  • Automation of jobs using UNIX Shell scripts.
  • Experience with Cursors, User-defined Object types, Records, and Tables in PL/SQL.
  • Exception Handling and debugging skills.
  • Experience with Materialized Views and Indexes.
  • SQL Tuning experience.
  • Understanding of Oracle Explain Plan.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:
Description:

  • At least 8+ years of experience as an Oracle PL/SQL Developer.
  • Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, Job, Schedulers, PL/SQL Web-services, Java Stored Procedures and Oracle AQ.
  • Hands on experience on XML generation inside PL/SQL components.
  • Strong Skills in data analysis, data modeling, development, testing and documentation.
  • Strong skills on automating jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking SQL *Plus.
  • Hands on writing Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets, Arrays & Queues.
  • Strong Skills in Exception Handling extensively debug PL/SQL Code, DDL, DML and display the error messages in the application.
  • Experience in creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
  • Experience in SQL Tunning to improve the query performance by identifying key fields, adding/removing tables/fields, and use of indexes.
  • Good understanding of Oracle Explain Plan.
Apply
Similar Jobs
Loading data...