Senior Oracle lead

We are seeking a Senior Oracle lead to work remotely from anywhere in Northern California and be 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.

Requirements:

·         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.