Unknown Company

Senior Oracle Forms & Reports Consultant (Ref: 5781)

Apply Now Save
sacramento, ca • Posted 4 days ago
Remote Full Time IT & Technology

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.

Required Technical Skills:

  • Oracle Forms & Reports 12c
  • Oracle WebLogic Server
  • Oracle Forms Builder
  • Oracle Database
  • SQL
  • PL/SQL
  • Oracle BI Discoverer
  • Discoverer Administrator
  • Discoverer Desktop
  • Jaspersoft
  • Apache Subversion (SVN)
  • TOAD Developer
  • SQL Developer
  • Unix Scripting
  • Windows
  • PuTTY
  • FileZilla
  • Windows Remote Desktop
  • Technical Documentation
  • Application Maintenance & Support
  • Database Troubleshooting
  • Technical Testing
  • Deployment Support

#J-18808-Ljbffr
Back to Job Search