PL/SQL Developer

Job Title: PL/SQL Developer

Location: Remote

Type: Contract

Job Description:

We are hiring a Senior Developer to focus primarily on our Oracle PL/SQLlegacy 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
• Advanced 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
• A 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
• AJAX 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
• AJAX 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
• Authentication 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