Senior Oracle PL / SQL Developer

Roles : Senior Oracle PL / SQL Developer

Location : Remote

Type : Contract to hire (after 6 months)

• 100% REMOTE CST or EST hours

Job Description :

We are hiring a Senior Developer to focus primarily on our Oracle PL / SQL legacy application (Eye Cloud Pro practice management system). This is a database-driven web application serving optical practices with complex business workflows.

Key Architecture : Our system follows a "thick database, thin application " pattern where most business logic (patient billing, insurance validation, inventory workflows) is implemented in Oracle PL / SQL functions and procedures, while the web application layer primarily handles presentation and user interaction through DHTMLX components.

Technology Focus

Primary Focus : Oracle PL / SQL web application with DHTMLX-based frontend Secondary : Node.js APIs and modern tooling Future : React components (distant roadmap)

Oracle PL / SQL web application

Somebody had a good knowledge of Oracle PL / SQL coding and queries, converting that to Node.js

Transitioning application - improving existing software

Leveraging AI, eventually moving out of Oracle PL / SQL to PostgreSQL

Senior Developer Requirements

Must-Have Technical Skills

Oracle & Database (Critical)

Writing functions, procedures, packages, views

Database-driven web application patterns

Multi-table joins, analytical functions

Frontend Legacy Technologies (Critical)

Grid components, forms, layouts, charts

DOM manipulation without frameworks

Semantic markup for data-heavy applications

Web Application Architecture

Understanding of thick database, thin application layer patterns

DOM manipulation and event handling

Should-Have Technical Skills

Modern Backend Development

RESTful API development

Cloud & DevOps

Development Environment