PL/SQL Oracle Developer

Overview

Remote
Depends on Experience
Contract - W2
No Travel Required

Skills

Computer Science
Analytical Skill
Apex
Collaboration
Conflict Resolution
Data Integrity
Data Manipulation
Database Design
Database Performance Tuning
Data Modeling
Data Warehouse
Database
Extract
Transform
Load
Information Technology

Job Details

Job Title: PL/SQL Oracle Developer

< data-start="200" data-end="223">Job Summary:</>

We are looking for a skilled PL/SQL Oracle Developer to design, develop, and maintain Oracle database applications. The ideal candidate will have strong expertise in PL/SQL programming, database design, performance tuning, and working with large-scale enterprise applications.

< data-start="508" data-end="540">Key Responsibilities:</>

  • Design, develop, and optimize complex PL/SQL packages, procedures, triggers, and functions.

  • Write efficient SQL queries for data manipulation and reporting.

  • Perform database performance tuning, query optimization, and troubleshooting.

  • Work closely with business analysts and application developers to translate requirements into database solutions.

  • Ensure data integrity, security, and compliance with organizational policies.

  • Create and maintain technical documentation for database solutions.

  • Support production systems, troubleshoot issues, and implement fixes.

  • Collaborate with cross-functional teams for database design, migration, and upgrades.

< data-start="1225" data-end="1269">Required Skills & Qualifications:</>

  • Bachelor s degree in Computer Science, Information Technology, or related field.

  • 9 years of hands-on experience in Oracle PL/SQL development.

  • Strong knowledge of Oracle 11g/12c/19c databases.

  • Expertise in writing stored procedures, triggers, functions, and packages.

  • Experience in query performance tuning and optimization.

  • Familiarity with data modeling and database design concepts.

  • Ability to work with large datasets and complex queries.

  • Strong problem-solving and analytical skills.

< data-start="1793" data-end="1821">Preferred Skills:</>

  • Experience with Oracle Forms, Reports, or APEX.

  • Exposure to UNIX/Linux shell scripting.

  • Knowledge of ETL tools and data warehousing concepts.

  • Familiarity with Agile/Scrum methodologies.

  • Oracle certification (OCP/OCA) is a plus.

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.