Oracle PL/SQL Developer

Overview

Remote
On Site
Depends on Experience
Contract - W2

Skills

Analytical Skill
Cloud Computing
Collaboration
Computer Science
Conflict Resolution
Data Integrity
Data Processing
Data Warehouse
Database
Extract
Transform
Load
Information Technology
Optimization
Oracle
Oracle Enterprise Manager
PL/SQL
Problem Solving
Query Optimization
Regulatory Compliance
SQL
SQL Tuning
SQL*Plus
Stored Procedures
Toad

Job Details

Position :- Senior Business Analyst

Contract :- W2

Job Description

We are seeking a skilled Oracle Developer with deep expertise in Oracle SQL and a strong background in handling large data volumes. The ideal candidate will be responsible for designing, developing, and optimizing SQL queries and database structures to support high-performance applications and data processing systems.

Key Responsibilities:

  • Develop and maintain complex Oracle SQL queries, including joins, subqueries, indexes, clustered indexes, and partitions.
  • Design and implement efficient database schemas and indexing strategies to support large-scale data operations.
  • Perform SQL performance optimization, including query tuning, execution plan analysis, and resource usage monitoring.
  • Collaborate with data architects and application developers to ensure scalable and reliable data solutions.
  • Troubleshoot and resolve performance bottlenecks in existing SQL code and database configurations.
  • Ensure data integrity, security, and compliance with organizational standards.

Required Skills & Qualifications:

  • Proven experience as an Oracle Developer with strong command of Oracle SQL.
  • Hands-on experience with indexing strategies, clustered indexes, and partitioning in Oracle databases.
  • Demonstrated ability to handle large volumes of data efficiently.
  • Expertise in SQL performance tuning and optimization techniques.
  • Familiarity with Oracle database tools and utilities (e.g., SQL*Plus, TOAD, Oracle Enterprise Manager).
  • Strong analytical and problem-solving skills.
  • Bachelor s degree in Computer Science, Information Technology, or related field.

Preferred Qualifications:

  • Experience with PL/SQL and stored procedures.
  • Exposure to cloud-based Oracle environments.
  • Knowledge of data warehousing and ETL processes.
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.