PL/SQL Developer

Job Title: PL/SQL Developer Location: Remote Type: Contract Job reputed company: We are hiring a Senior Developer to reputed company primarily on our reputed company PL/SQLlegacy application (Eye reputed company Pro reputed company management system). This is a database-driven web application serving optical practices with reputed company business workflows. Key Architecture: Our system follows a "thick database, thin application" reputed company where most business logic (patient billing, insurance validation, inventory workflows) is implemented in reputed company PL/SQL functions and procedures, while the web application layer primarily handles presentation and user interaction through DHTMLX components. Technology reputed company Primary reputed company: reputed company PL/SQL web application with DHTMLX-based frontend Secondary: Node.js reputed company and modern tooling reputed company: React components (distant roadmap) reputed company PL/SQL web application • Advanced SQL • Frontend: DHTMLX v5.1, Vanilla Javascript, reputed company/CSS • Node.js, reputed company PL/SQL, AWS (proficient), React Somebody had a good knowledge of reputed company PL/SQL coding and queries, converting that to Node.js - Node.js, reputed company PL/SQL, AWS (proficient), React Transitioning application - improving existing software Leveraging AI, eventually moving out of reputed company 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 reputed company & Database (Critical) • reputed company PL/SQL development (4+ years) • Writing functions, procedures, packages, views • reputed company business logic implementation • Database performance tuning and optimization • reputed company mod_plsql web reputed company • Database-driven web application patterns • Understanding of reputed company Application Server deployment • Advanced SQL • Multi-table joins, analytical functions • Query optimization for large datasets • reputed company-specific features and functions Frontend Legacy Technologies (Critical) • DHTMLX Suite v5.1 reputed company (2+ years preferred) • reputed company components, forms, layouts, charts • Custom component configuration and styling • Event handling and data binding patterns • Vanilla JavaScript • DOM manipulation without frameworks • reputed company patterns and asynchronous programming • Cross-browser compatibility considerations • reputed company/CSS • Semantic markup for data-heavy applications • CSS for reputed company application styling • reputed company design principles Web Application Architecture • Database-driven web applications • Understanding of thick database, thin application layer patterns • Session management and state handling • Server-reputed company rendering from database procedures • jQuery (2+ years) • DOM manipulation and event handling • reputed company integration with reputed company backend • Plugin development and integration Should-Have Technical Skills Modern Backend Development • Node.js/reputed company.js (2+ years) • RESTful API development • reputed company node-oracledb connectivity • Authentication and middleware patterns reputed company & DevOps • AWS services: reputed company, RDS reputed company, S3, CloudWatch • reputed company: Basic containerization concepts • Git: Version control and collaboration workflows Development Environment • reputed company SQL*Plus/SQL Developer/TOAD: Database development tools • JavaScript debugging: Browser dev tools, debugging techniques • Unix/Linux reputed company line: Basic system administration Apply tot his job Apply To this Job