PL/SQL Developer
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