Oracle Database Developer (Cleveland - 5-days Onsite)

Job Description

Oracle Database Developer

\n

Optomi, in partnership with a leading paints and coatings manufacturer, is seeking a senior-level PL/SQL Developer with strong UNIX experience to support database development and system-to-system integrations. The resource will work primarily with PL/SQL development, including packages, procedures, functions, database changes, and data translations. The team operates within three-week development sprints, with tickets assigned and released at the completion of each sprint.

\n

\n

What the right candidate will enjoy!!!

\n

\n
• The opportunity to work on complex database development and system-to-system integration initiatives in a senior-level role.

\n

• A highly independent position where experienced developers can make an immediate impact with minimal oversight.

\n

• Working in a collaborative Agile environment focused on PL/SQL development, data translation, and modernization efforts.

\n

\n

\n

Experience of the right candidate:

\n

\n
• Approximately 6–10 years of relevant experience, with the ability to work independently as an individual contributor.

\n

• Experience with Oracle 19c or newer/current Oracle environments is preferred. The environment is expected to transition to a newer Oracle version in the future, but specific version experience is not critical as long as the candidate is current with Oracle technologies.

\n

\n

\n

Responsibilities of the right candidate:

\n

\n
• Develop and maintain Oracle database objects, including tables, views, procedures, functions, and packages.

\n

• Create and optimize SQL and PL/SQL code for data retrieval, processing, and reporting.

\n

• Support ETL processes for loading, transforming, and validating data.

\n

• Develop and maintain Unix/Linux shell scripts for automation and batch processing.

\n

• Troubleshoot and resolve database, ETL, and data quality issues.

\n

• Perform query and application performance tuning.

\n

• Collaborate with developers, analysts, and business stakeholders to deliver data solutions.

\n

• Participate in code reviews, testing, deployments, and production support activities.

\n

• Maintain technical documentation and adhere to development standards.

\n

• Support ongoing enhancements and maintenance of existing database applications and processes.

\n

\n