Oracle PL/SQL Developer

Overview

On Site
$60,000+
Full Time

Skills

SQL & PL/SQL
Oracle
Performance Tuning
TOAD
Git
AWS & Azure
Data Warehousing
SDLC
Java

Job Details

Key Technical Skills:
  • SQL:
    Proficiency in writing efficient and optimized SQL queries is crucial.
  • PL/SQL:
    A deep understanding of PL/SQL syntax, data types, control structures, and the ability to develop packages, procedures, and functions is essential.
  • Database Design and Management:
    Experience in designing database schemas, creating tables, views, indexes, and managing database objects is vital.
  • Performance Tuning:
    Skills in identifying, monitoring, and correcting SQL and PL/SQL code for optimal performance are important.
  • Database Administration:
    Knowledge of database administration tasks, including security, backup and recovery, and user management, is beneficial.
  • Oracle Tools:
    Familiarity with tools like Oracle SQL Developer, TOAD, or other relevant IDEs is expected.
  • Version Control:
    Experience with version control systems like Git is helpful for managing code changes.
Key Non-Technical Skills:
  • Problem-Solving:
    The ability to analyze and resolve complex issues related to database and PL/SQL code is essential.
  • Analytical Skills:
    PL/SQL developers need to analyze requirements, understand data models, and design effective solutions.
  • Communication:
    Strong verbal and written communication skills are necessary for collaborating with team members and stakeholders.
  • Attention to Detail:
    Meticulousness in writing code and creating database objects is important.
Additional Desirable Skills:
  • Cloud Computing:
    Knowledge of cloud platforms like AWS, Azure, or Google Cloud can be beneficial.
  • Data Warehousing:
    Experience with data warehousing concepts and technologies can be an advantage.
  • Agile Methodologies:
    Familiarity with Agile or other SDLC methodologies is helpful.
  • Java:
    While PL/SQL is the core language, knowledge of Java can be useful for some Oracle development projects.
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.