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

dvanced SQL

Frontend: DHTMLX v5.1, Vanilla Javascript, HTML/CSS

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

- Node.js, Oracle PL/SQL, AWS (proficient), React

Transitioning application - improving existing software

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

plus if someone has worked with AI tools etc; but doesn't rely on it Senior Developer Requirements

Must-Have Technical Skills

Oracle & Database (Critical)

Oracle PL/SQL development (4+ years)

Writing functions, procedures, packages, views

Complex business logic implementation

Database performance tuning and optimization

Oracle mod_plsql web framework

Database-driven web application patterns

Understanding of Oracle Application Server deployment

Advanced SQL

Multi-table joins, analytical functions

Query optimization for large datasets

Oracle-specific features and functions Frontend Legacy Technologies (Critical)

DHTMLX Suite v5.1 Professional (2+ years preferred)

Grid components, forms, layouts, charts

Custom component configuration and styling

Event handling and data binding patterns

Vanilla JavaScript

DOM manipulation without frameworks

JAX patterns and asynchronous programming

Cross-browser compatibility considerations

HTML/CSS

Semantic markup for data-heavy applications

CSS for enterprise application styling

Responsive design principles Web Application Architecture

Database-driven web applications

Understanding of thick database, thin application layer patterns

Session management and state handling

Server-side rendering from database procedures

jQuery (2+ years)

DOM manipulation and event handling

JAX integration with Oracle backend

Plugin development and integration Should-Have Technical Skills

Modern Backend Development

Node.js/Express.js (2+ years)

RESTful API development

Oracle node-oracledb connectivity

uthentication and middleware patterns Cloud & DevOps

AWS services: ECS, RDS Oracle, S3, CloudWatch

Docker: Basic containerization concepts

Git: Version control and collaboration workflows Development Environment

Oracle SQL*Plus/SQL Developer/TOAD: Database development tools

JavaScript debugging: Browser dev tools, debugging techniques

Unix/Linux command line: Basic system administration