PL/SQL Developer – Remote – Contract 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).
Core Skills Advanced SQL Frontend: DHTMLX v5.1, Vanilla JavaScript, HTML/CSS Node.js, Oracle PL/SQL AWS (proficient) React 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 #J-18808-Ljbffr