Oracle PL/SQL Developer

Overview

On Site
$60,000 - $80,000
Full Time

Skills

Oracle
PL/SQL
Database Design & Data Modeling
Performance Tuning
Git
TOAD
Oracle APEX
Java
Data Warehousing
Oracle Financials & Oracle HR
XML

Job Details

Core Technical Skills:
  • SQL and PL/SQL:
    Expertise in writing efficient SQL queries and PL/SQL code is fundamental. This includes understanding SQL statements, functions, procedures, triggers, and PL/SQL control structures, procedures, functions, and packages.
  • Oracle Database Architecture:
    A solid understanding of how the Oracle database works, including its architecture, data storage, and performance characteristics, is crucial for effective development.
  • Database Design and Data Modeling:
    Skills in designing database schemas, creating tables, and defining relationships are essential for building robust and scalable applications.
  • Performance Tuning and Optimization:
    The ability to analyze query performance, identify bottlenecks, and optimize SQL and PL/SQL code is a key skill.
  • Version Control:
    Familiarity with version control systems like Git is important for managing code changes and collaborating with other developers.
Soft Skills:
  • Analytical and Problem-Solving:
    PL/SQL developers often need to analyze complex problems, troubleshoot issues, and develop effective solutions.
  • Communication:
    The ability to communicate effectively with technical and non-technical stakeholders is important for understanding requirements and explaining solutions.
  • Teamwork and Collaboration:
    PL/SQL developers often work as part of a larger team, so the ability to collaborate effectively is crucial.
  • Specific Tools and Technologies:
  • Oracle SQL Developer: A powerful tool for developing, debugging, and managing Oracle databases.
  • TOAD: Another popular tool for database development and administration.
  • Oracle APEX: A low-code development platform for building web applications on top of the Oracle database.
  • Java: While PL/SQL is the primary language, Java is also relevant for Oracle development, particularly for building applications with JDeveloper and ADF.
In addition to these skills, it's beneficial to have experience with:
  • Data Warehousing: Understanding data warehousing concepts and ETL processes.
  • Oracle Applications: Experience with specific Oracle applications like Oracle Financials or Oracle HR.
  • XML Publisher: Knowledge of XML Publisher for generating reports
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.