Apply on Employer Site

Thorndale Partners · 2 weeks ago

Sr. Oracle EBS Developer

Nashville, TN

Full-time

Onsite

Senior Level

$120K/yr - $150K/yr

5+ years exp

Thorndale Partners is seeking a Senior Oracle EBS Developer to join their team. The role involves designing and maintaining Oracle database solutions, optimizing performance, and developing PL/SQL procedures to support business logic.

ConsultingRecruitingStaffing Agency

Responsibilities

Designs, develops, and maintains Oracle database stored code and objects, including schema design, table structures, indexes, and data modeling

Optimizes database performance by fine-tuning queries, identifying and resolving bottlenecks, and implementing indexing strategies

Develops complex PL/SQL procedures, functions, triggers, and packages to implement business logic and data manipulation

Creates and maintains database scripts, including stored procedures, views, and materialized views

Performs unit testing and debugging of PL/SQL code to ensure functionality, accuracy, and adherence to business requirements

Proficiently handles creating and parsing XML and JSON structures and their interfaces within Oracle database applications

Troubleshoots and resolves database issues, including performance problems, data corruption, and connectivity errors

Create/extend proprietary applications functionality using Oracle RDBMS, PL/SQL, Oracle Apps Forms, Concurrent Manager utilization, and new Apps Responsibility registrations

Define, install, configure, and maintain all associated Oracle reporting functionality based on the Oracle Business

Qualification

Oracle E-Business SuitePL/SQL programmingOracle database architectureOracle SQLPerformance tuningXML handlingJSON handlingDatabase troubleshooting

Required

Bachelor's degree or related field or directly related year-for-year work experience

5+ Years of experience in the Oracle E-Business Suite

A deep understanding of Oracle database architecture, Oracle SQL, PL/SQL programming, and performance tuning. Experience with Oracle database versions 19c, 12c, 11i are all acceptable

Several years of hands-on experience working with Oracle E-business with a focus on financial applications

Creating efficient, maintainable, and optimized PL/SQL stored code