PL​/SQL Developer

PL/SQL Developer – Remote – Contract

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.

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.

Primary Focus:
Oracle PL/SQL web application with DHTMLX-based frontend.

Secondary:
Node.js APIs and modern tooling.

Future:
React components (distant roadmap).

• Advanced SQL
• Frontend: DHTMLX v5.1, Vanilla JavaScript, HTML/CSS
• Node.js, Oracle PL/SQL
• AWS (proficient)
• React

• Oracle PL/SQL development (4+ years)
  • Writing functions, procedures, packages, views
  • Complex business logic implementation
  • Database performance tuning and optimization
• Oracle  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

• 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 Java Script
  • 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

• 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

• Node.js/Express.js (2+ years)
  • RESTful API development
  • Oracle node-oracledb connectivity
  • Authentication and middleware patterns

• AWS services
  : ECS, RDS Oracle, S3, Cloud Watch
• Docker
  :
  Basic containerization concepts
• Git
  :
  Version control and collaboration workflows

• Oracle SQL
  * Plus/SQL Developer/TOAD
  :
  Database development tools
• JavaScript debugging
  :
  Browser dev tools, debugging techniques
• Unix/Linux command line
  :
  Basic system administration