Start searching
Back to Jobs
Recently postedTechnology

Oracle PL-SQL Developer

ApexonLeander, TX🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationLeander, TX, United States
OraclePL/SQLSQL

Job description

Role Overview

We are seeking experienced Oracle PL/SQL Developers with strong Oracle database knowledge and expertise in SQL and PL/SQL development. The ideal candidates will be responsible for analyzing production issues, developing and deploying SQL-based solutions, optimizing query performance, and supporting business applications built using Oracle technologies.

Required Skills

  • Strong knowledge of Oracle database concepts.
  • Excellent technical and design skills in Oracle PL/SQL and SQL development.
  • Experience developing stored procedures, packages, functions, triggers, cursors, views, and materialized views.
  • Experience implementing data processing, referential integrity, and business rules using Oracle database objects.
  • Ability to write complex SQL queries and apply advanced PL/SQL concepts.
  • Experience with performance tuning and processing large volumes of data.
  • Strong understanding of relational database concepts, including tables, views, indexes, and tablespaces.
  • Experience designing, developing, implementing, testing, supporting, and documenting business applications using Oracle technologies.
  • Ability to analyze production issues and resolve them by writing and deploying SQL.

Preferred Skills

  • Oracle-approved certification or formal Oracle training.

Key Responsibilities

  • Analyze production issues and identify database-related root causes.
  • Develop, test, and deploy SQL solutions to resolve production issues.
  • Create and maintain PL/SQL procedures, packages, functions, triggers, and other database objects.
  • Develop complex queries to support business requirements and data processing.
  • Optimize SQL queries and PL/SQL code for performance when working with large data volumes.
  • Apply database design principles and enforce referential integrity and business rules.
  • Support implementation, testing, troubleshooting, and maintenance of Oracle-based business applications.
  • Document SQL solutions, test results, and technical changes.

Expected Deliverables

  • SQL queries and PL/SQL code to address production issues.
  • Tested and validated SQL solutions.
  • Performance-optimized queries and database objects, as required.
  • Technical documentation and test results.

Education Requirement

Bachelor’s degree in Computer Science, Information Technology, Engineering, Business Administration, or a related field is preferred.

Similar jobs

Apply