Apollo ITS
Roles: Oracle PL/SQL -FullStack Developer
Location: Remote
Type: Contract
**100 REMOTE**
Job Description: We are hiring
2 contractors
(1 senior, 1 mid-level) 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)
Senior Level -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 Mid-Level Developer Requirements Must-Have Technical Skills Database Foundation
Oracle PL/SQL
(1-2 years or strong SQL background with willingness to learn)
Basic function and procedure development Understanding of Oracle data types and built-in functions Query writing and optimization fundamentals
SQL
(2+ years)
Complex SELECT statements with joins Data manipulation (INSERT, UPDATE, DELETE) Understanding of indexes and performance concepts
Frontend Development
JavaScript
(2+ years)
ES5/ES6 fundamentals DOM manipulation and event handling Asynchronous programming (callbacks, promises)
HTML/CSS
(2+ years)
Semantic markup and accessibility CSS layout and styling Basic responsive design
Should-Have Technical Skills Web Framework Experience
DHTMLX or similar commercial JavaScript frameworks
Data grid components Form handling and validation Layout management systems
Database-driven web applications
Understanding of server-side rendering State management in web applications Data validation patterns
Development Practices
Git version control : Branching, merging, pull requests Code debugging : Browser tools, error handling Testing mindset : Manual testing, bug reproduction Project Context & Environment Application Architecture
Hybrid system : Legacy Oracle PL/SQL web app + modern Node.js APIs Primary focus : Oracle PSP (practice management system) Database : Oracle with 500+ custom functions and procedures Frontend : DHTMLX grids, forms, and layouts with jQuery Users : Optical practices (doctors, staff, billing, inventory management) Development Environment
Multi-environment setup : dev, staging, prodeast, prodwest AWS infrastructure : ECS, RDS Oracle, API Gateway Version control : Git with GitHub Enterprise Deployment : Docker containers + Oracle Application Server Typical Development Tasks
Enhancing existing Oracle PL/SQL business logic Creating new DHTMLX-based user interfaces Integrating frontend components with Oracle backend Performance optimization of database queries Bug fixes in legacy JavaScript code Data migration and schema updates
**100 REMOTE**
Job Description: We are hiring
2 contractors
(1 senior, 1 mid-level) 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)
Senior Level -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 Mid-Level Developer Requirements Must-Have Technical Skills Database Foundation
Oracle PL/SQL
(1-2 years or strong SQL background with willingness to learn)
Basic function and procedure development Understanding of Oracle data types and built-in functions Query writing and optimization fundamentals
SQL
(2+ years)
Complex SELECT statements with joins Data manipulation (INSERT, UPDATE, DELETE) Understanding of indexes and performance concepts
Frontend Development
JavaScript
(2+ years)
ES5/ES6 fundamentals DOM manipulation and event handling Asynchronous programming (callbacks, promises)
HTML/CSS
(2+ years)
Semantic markup and accessibility CSS layout and styling Basic responsive design
Should-Have Technical Skills Web Framework Experience
DHTMLX or similar commercial JavaScript frameworks
Data grid components Form handling and validation Layout management systems
Database-driven web applications
Understanding of server-side rendering State management in web applications Data validation patterns
Development Practices
Git version control : Branching, merging, pull requests Code debugging : Browser tools, error handling Testing mindset : Manual testing, bug reproduction Project Context & Environment Application Architecture
Hybrid system : Legacy Oracle PL/SQL web app + modern Node.js APIs Primary focus : Oracle PSP (practice management system) Database : Oracle with 500+ custom functions and procedures Frontend : DHTMLX grids, forms, and layouts with jQuery Users : Optical practices (doctors, staff, billing, inventory management) Development Environment
Multi-environment setup : dev, staging, prodeast, prodwest AWS infrastructure : ECS, RDS Oracle, API Gateway Version control : Git with GitHub Enterprise Deployment : Docker containers + Oracle Application Server Typical Development Tasks
Enhancing existing Oracle PL/SQL business logic Creating new DHTMLX-based user interfaces Integrating frontend components with Oracle backend Performance optimization of database queries Bug fixes in legacy JavaScript code Data migration and schema updates