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
Apply tot his job
Apply To this Job