Logo
Apollo ITS

Oracle PL/SQL -FullStack Developer

Apollo ITS, Auburn

Save Job
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