PL/SQL Developer
Creative Solutions Services, LLC
- New York, New York, United States
- New York, New York, United States
Über
Job Description 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.
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).
Core Skills
Advanced SQL
Frontend: DHTMLX v5.1, Vanilla JavaScript, HTML/CSS
Node.js, Oracle PL/SQL
AWS (proficient)
React
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
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.