Oracle Apps Technical Consultant

We are on the front line of recruitment, enabling organizations to hire smarter and onboard faster. At First Advantage (Nasdaq: FA), people are at the heart of everything we do. From our customers and partners to our greatest advantage — our team members.

Say hello to a rewarding career and come join a leading provider of mission-critical background screening solutions to some of the most recognized Fortune 100 and Global 500 brands.

About First Advantage

First Advantage (NASDAQ: FA) is a leading provider of global software and data in the HR technology industry. Enabled by proprietary technology and AI, First Advantage’s platforms, data, and APIs power comprehensive employment background screening, identity solutions, and verification services.

Headquartered in Atlanta, GA, we have an internationally distributed workforce of about 10,000 employees spanning 17 countries. With a strong emphasis on innovation, automation, and customer success, First Advantage empowers 80,000 organizations to modernize their hiring and onboarding processes on a global scale.

Job Summary

The Oracle Apps Technical Consultant is responsible for the technical design, development, customization, and support of Oracle E‑Business Suite (EBS) applications. The role involves working closely with functional consultants and business users to translate business requirements into technical solutions while ensuring performance, scalability, and compliance with Oracle standards.

Key Responsibilities

Technical Development

Design, develop, customize, and maintain Oracle E‑Business Suite R12 components.
Develop and modify Rice Components
Create and maintain PL/SQL procedures, packages, functions, and triggers.
Develop and customize Forms, OAF (Oracle Application Framework) pages, and ADF components (as applicable).
Work with Workflow Builder to customize and troubleshoot workflows.

Integration & Data Handling

Design and develop interfaces between Oracle EBS and third-party/external systems.
Perform data migration and conversion using SQL, PL/SQL, and Oracle standard tools.
Troubleshoot and resolve data inconsistencies and reconciliation issues.

Support & Maintenance

Provide production support, including issue analysis, bug fixes, and performance tuning.
Analyze and resolve concurrent program failures, performance issues, and database-related errors.
Monitor and tune SQL queries and PL/SQL programs for optimal performance.

Technical Skills

Required Skills & Qualifications

Strong experience in Oracle E‑Business Suite R12
Expertise in SQL, PL/SQL
Hands-on experience with:
Oracle Reports
BI Publisher (XML, RTF templates)
Interfaces and APIs
Concurrent Programs
Good understanding of Oracle EBS architecture
Experience with Unix/Linux shell scripting
Knowledge of Oracle database objects and performance tuning
We have great people here and are looking for more. Come join us!

Follow Us

Facebook
Instagram
LinkedIn
X
YouTube

Equal Employment Opportunities at First Advantage

First Advantage is an equal opportunity employer. We are committed to providing a workplace and recruitment process that is free from unlawful discrimination, harassment, and retaliation. Employment decisions at First Advantage are based solely on qualifications, merit, and business needs. We do not discriminate in any aspect of employment on the basis of race, color, national origin, ancestry, citizenship, religion, creed, sex, gender identity, gender expression, sexual orientation, marital or family status, pregnancy, age, physical or mental disability, medical condition, genetic information, veteran or military status, or any other characteristic protected by applicable law.