Senior Oracle Forms & Reports Consultant (Ref: 5781)

Estrada Consulting, Inc

Sacramento (CA)

On-site

USD 120,000 - 150,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Estrada Consulting, Inc seeks a Senior Lead Oracle Forms & Reports to steer maintenance, enhancement and operations of a large legacy environment in Sacramento. You will lead technical tasks, develop DB objects, and manage deployments across Windows, Oracle 12c DB, and BI tools.

The role emphasizes hands-on development, leadership in a legacy stack, and collaboration with business stakeholders to align IT with operations. DOE rate apply.

Qualifications

Eight+ years of IT experience aligned with business processes.
Five+ years in a lead capacity.
Experience with Oracle Forms/Reports 12c and Oracle DB 12c.
Expert SQL/PLSQL; Oracle BI Discoverer and Jaspersoft knowledge.
Experience documenting designs, deployments, and run books.

Responsibilities

Maintain, enhance, troubleshoot, and support Oracle Forms & Reports.
Develop modules, forms, interfaces, and DB objects; manage SQL/PLSQL.
Diagnose performance issues and document business logic.
Prepare deployment procedures and run books; participate in testing.
Support change/release management; conduct knowledge transfers.
Create and modify Jaspersoft reports; develop BI Discoverer components.

Skills

Oracle Forms/Reports

Oracle WebLogic Server

Oracle Forms Builder

Oracle Database

SQL

PL/SQL

Jaspersoft

SVN

Unix Scripting

Windows

PuTTY

FileZilla

Discoverer

Discoverer Administrator

Discoverer Desktop

SQL Developer

Education

Bachelor's degree in IT/Engineering

Tools

SVN

TOAD Developer

SQL Developer

PuTTY

FileZilla

Windows Remote Desktop

Jaspersoft

Job description

Senior Lead Oracle Forms & Reports (Ref: 5781)

Location: Sacramento, CA Duration: 3 years Rate: DOE

Position Overview:

We are seeking an experienced Senior Lead to support the maintenance, enhancement, and ongoing technical operations of a large-scale legacy Oracle Forms & Reports application environment. The Senior Technical Lead will provide hands-on technical development and support while serving in a lead capacity for application maintenance, troubleshooting, reporting, database development, deployments, and related technical activities.

The ideal candidate will have extensive experience with Oracle Forms/Reports, Oracle WebLogic Server, Oracle Forms Builder, Oracle databases, SQL/PL/SQL, Oracle Business Intelligence Discoverer, Jaspersoft, and related development and support tools.

Minimum Experience:

Minimum of eight (8) years of experience aligning IT systems with organizational business processes.
At least five (5) years of that experience must have been in a lead capacity.

Education:

Possession of a bachelor's degree in an IT-related or Engineering field.
Additional qualifying experience may be substituted for the required education on a year-for-year basis.

Additional Mandatory Qualifications and Required Experience:

Candidates must also possess the following experience:

Minimum of five (5) years of experience developing and supporting technical solutions using Oracle Forms/Reports 12c, Oracle WebLogic Server, Oracle Forms Builder, and Oracle 12c database, including:
- Creating and modifying Oracle database objects.
- Expert-level SQL and PL/SQL knowledge.
- At least two (2) years of this experience in a lead capacity.
Minimum of four (4) years of experience authoring technical documentation, including documents such as:
- Design documentation.
- Deployment procedures.
- Run books.
Minimum of two (2) years of experience using Apache Subversion (SVN) code repository software.
Minimum of four (4) years of experience developing Oracle Forms/Reports code for deployment to a Windows platform.
Minimum of two (2) years of experience using telnet/remote-access tools such as:
- PuTTY.
- FileZilla.
- Windows Remote Desktop.
Minimum of four (4) years of experience using TOAD Developer for Oracle databases and/or equivalent Oracle database utility or diagnostic tools for:
- Troubleshooting database bugs and issues.
- Troubleshooting query performance.
- Diagnosing problems identified through database diagnostic tools.
Minimum of two (2) years of experience using and configuring Oracle Business Intelligence Discoverer, including:
- Discoverer Administrator.
- Discoverer Desktop.
Minimum of two (2) years of experience developing Jaspersoft reports.
Minimum of two (2) years of experience writing SQL and Unix scripts.

Key Responsibilities:

The Senior Technical Lead will support activities that may include:

Maintain, enhance, troubleshoot, and support legacy Oracle Forms & Reports applications.
Develop and modify application modules, forms, interfaces, database objects, SQL/PLSQL code, and related components.
Diagnose and resolve application, database, reporting, and performance issues.
Review existing source code to determine and document business logic.
Perform data conversions and data migrations.
Perform technical testing and support application deployments.
Maintain and support backend and scheduled jobs.
Develop and maintain Oracle BI Discoverer End User Layer (EUL) components, including Business Areas, Folders, and Discoverer Reports.
Create and modify Jaspersoft reports.
Participate in technical planning, design, and solution sessions.
Provide level-of-effort estimates for proposed technical work.
Develop and maintain technical documentation, including interface design specifications, deployment runbooks, modification summaries, data dictionaries, and related technical artifacts.
Maintain source code and scripts within designated code repositories.
Support change and release management activities.
Conduct knowledge-transfer sessions with technical developers and business support personnel.
Participate in project meetings and Agile/Scrum activities.
Work collaboratively with technical and business stakeholders to ensure solutions align with organizational business processes.