Oracle Developer

IRESH TECHNOLOGIES LLC

United States

5 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Agile Methodology Code Review Databases Data Integration Extract Transform Load (ETL) Database Schema Revision Control Systems Oracle Databases Oracle (Applications) Oracle Forms Oracle SQL Developer Oracle Warehouse Builder

+16 more

Performance Tuning Scrum Methodology Query Optimization Shell Script Software Engineering SQL Stored Procedures PL-SQL SQL Databases Subversion Enterprise Software Applications Database Optimization Git Database Migration Toad (Software) Restful APIs Oracle Cloud Infrastructure

Job description

We are seeking an experienced Oracle Developer with 12+ years of hands-on experience in Oracle database development, PL/SQL programming, performance tuning, and enterprise application support. The ideal candidate should have strong expertise in designing, developing, optimizing, and maintaining Oracle database solutions while collaborating with cross-functional teams in an Agile environment., * Design, develop, and maintain Oracle database applications.

Develop complex PL/SQL packages, procedures, functions, triggers, and views.
Write and optimize SQL queries for high-performance applications.
Perform database performance tuning and query optimization.
Analyze business requirements and provide technical solutions.
Create and maintain database objects, data models, and ETL processes.
Support application development teams with database integration.
Troubleshoot production issues and provide timely resolutions.
Perform database migrations, upgrades, and deployments.
Work closely with QA and business stakeholders during testing.
Participate in code reviews and follow development best practices.
Maintain technical documentation and database standards.

Requirements

12+ years of Oracle Development experience.
Strong experience with Oracle Database 12c/19c/21c.
Expert in SQL & PL/SQL.
Experience with Stored Procedures, Packages, Functions, Triggers, Views.
Oracle Performance Tuning.
Oracle Data Modeling.
Experience with Oracle SQL Developer, TOAD.
Oracle Forms & Reports (Preferred).
ETL/Data Integration experience.
Oracle Data Pump.
Unix/Linux Shell Scripting.
Git, SVN or other Version Control tools.
REST APIs integration.
Agile/Scrum methodology.
Strong troubleshooting and analytical skills.
Excellent communication skills., * Oracle Certified Professional (OCP) is a plus.
Experience with Oracle Cloud (OCI) is preferred.
Experience supporting enterprise applications.
Financial, Healthcare, Insurance, or Government domain experience is a plus.