Sr. Technical Lead (Oracle forms)

Role: Sr. Technical Lead (Oracle forms)

Location: Can be remote in Northern California

Certs: Oracle

Required to have experience working independently

2+ yrs of State agency experience

Senior Technical Lead (Oracle Forms/Reports)

Position Summary
The Senior Technical Lead is responsible for leading the design, development, deployment, and support of enterprise Oracle Forms/Reports based systems. This role provides technical leadership, ensures high-quality deliverables, mentors developers, and supports mission-critical applications deployed on Unix (Solaris) platforms. The Senior Technical Lead collaborates closely with stakeholders, architects, and operations teams to deliver stable, secure, and well-documented technical solutions.

Key Responsibilities

Lead the development, enhancement, and support of Oracle Forms/Reports 12c applications and Oracle 12c databases.

Provide technical leadership and oversight, including task assignment, code reviews, mentoring, and troubleshooting.

Design, create, and modify Oracle database objects; write and optimize complex SQL and PL/SQL code.

Develop and deploy Forms/Reports code to Unix (Solaris) environments using secure terminal and file transfer tools such as PuTTY and FileZilla.

Troubleshoot and resolve database, application, and performance issues using TOAD and other Oracle diagnostic utilities.

Configure and support Oracle Business Intelligence Discoverer and develop Jaspersoft reports to meet business reporting needs.

Write and maintain SQL and Unix shell scripts to support application functionality, data processing, and system operations.

Author and maintain technical documentation, including system design documents, deployment procedures, and run books.

Manage source code using Apache Subversion (SVN), ensuring version control best practices are followed.

Support production and non-production environments and participate in release management and deployment activities.

Required Qualifications

Minimum five (5) years of experience developing and supporting technical solutions using Oracle Forms/Reports 12c, Oracle Forms Builder, and Oracle 12c Database, including creation and modification of Oracle database objects and expert-level SQL and PL/SQL development.

At least two (2) years of experience in a technical lead capacity.

Minimum four (4) years of experience authoring technical documentation such as design documents, deployment procedures, and run books.

Minimum two (2) years of experience using Apache Subversion (SVN).

Minimum four (4) years of experience developing Forms/Reports code for deployment to a Unix (Solaris) platform, including use of terminal and file transfer tools such as PuTTY and FileZilla.

Minimum four (4) years of experience using TOAD for Oracle and/or equivalent Oracle database utilities and diagnostic tools for troubleshooting database bugs, performance issues, and errors.

Minimum two (2) years of experience using and configuring Oracle Business Intelligence Discoverer.

Minimum two (2) years of experience developing Jaspersoft reports.

Minimum two (2) years of experience writing SQL and Unix shell scripts.