Oracle PL/SQL Developer Job at innovitusa, Denver, CO

UGlKb3M1S0h0bHhJaEZUNGhnanloOW9iS3c9PQ==
  • innovitusa
  • Denver, CO

Job Description

Hiring: W2 Candidates Only

Visa: Open to any visa type with valid work authorization in the USA

We are seeking an experienced Oracle PL/SQL Developer to design, develop, and optimize database solutions supporting mission-critical applications. The ideal candidate has strong SQL/PLSQL expertise, experience with performance tuning, and the ability to collaborate with application teams to build efficient, scalable backend systems.

Key Responsibilities

  • Design, develop, and maintain PL/SQL stored procedures, functions, packages, triggers, and views .
  • Optimize complex SQL queries and PL/SQL code for performance, scalability, and reliability.
  • Collaborate with application developers to integrate backend database logic with front-end systems.
  • Develop ETL processes, data transformation pipelines, and batch jobs where required.
  • Work closely with business analysts and stakeholders to gather requirements and translate them into technical specifications.
  • Perform database tuning, query optimization, and troubleshoot performance bottlenecks.
  • Create and maintain logical and physical data models, database schemas, and documentation.
  • Ensure data integrity, security, and compliance across database environments.
  • Support production systems, participate in on-call rotations, and resolve database-related issues.
  • Develop and maintain scripts for automation, monitoring, and maintenance.
  • Assist in database upgrades, migrations, and patching activities.

Required Skills & Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, or related technical field.
  • 4-8+ years of hands-on experience as an Oracle SQL/PLSQL Developer .
  • Strong experience with Oracle 11g/12c/19c databases.
  • Expertise in writing and tuning complex PL/SQL code (procedures, packages, triggers).
  • Strong SQL query tuning and database performance optimization skills.
  • Experience with Oracle tools such as SQL Developer, TOAD, RMAN , or similar.
  • Solid understanding of RDBMS concepts, indexing, query planning, and data modeling.
  • Experience in ETL processes, batch processing, and large-scale data handling.
  • Knowledge of Unix/Linux shell scripting for automation.
  • Good communication and problem-solving skills.

Preferred Qualifications

  • Experience with Oracle APEX , Oracle Forms/Reports , or Oracle E-Business Suite (EBS).
  • Knowledge of modern data tools and platforms (Informatica, ODI, SSIS).
  • Exposure to cloud environments (Oracle Cloud, AWS RDS, Azure).
  • Familiarity with DevOps practices, CI/CD pipelines, and version control (Git).
  • Experience migrating legacy databases to newer versions or cloud platforms

Job Tags

Similar Jobs

Continuum Therapy Partners

Occupational Therapist / OT - Full-time Job at Continuum Therapy Partners

Part Time OT Opportunity in Leesburg, VA! Join a Passionate Rehab Team at Heritage Hall Leesburg! - Leesburg, VA Continuum...  ...is excited to offer a Part Timeopportunity for a licensed Occupational Therapist at Heritage Hall Leesburg a supportive, collaborative skilled... 

Hasbro

IT Manager Job at Hasbro

 ...creative, and highly committed individualsand we believe the best is yet to come. We are currently seeking a strategic and hands-on IT Manager to lead the information technology function in Mexico . This role is responsible for overseeing all IT operations (Warehouse and... 

Bobcat Transport

CDL A Driver Owner Ops Needed/Home Daily/Local Work Job at Bobcat Transport

 ...Need Class A owner operators with 1 year or more experience Must have container experience...  ...Daycabs or sleepers ok Any year truck just must pass DOT Inspection Local orientation Local work all day shift Home every day Only 200 weekly deductions... 

State Compensation Insurance Fund

SENIOR WORKERS' COMPENSATION CLAIMS ADJUSTER Job at State Compensation Insurance Fund

 ...procedures and Department of Workers' Compensation laws and regulations Proactively and independently, manage, finalize and control (adjust) an inventory Collaborate with a team of claims professionals and other stakeholders Serve as a resource to other team... 

Pinell Studios

Remote Travel Agent Job at Pinell Studios

 ...We are looking for a motivated and detail-oriented Remote Travel Agent to join our team. In this role, you will help clients research, plan, and book their travel experiencesranging from weekend getaways to dream vacations. This is a remote position, giving you the flexibility...