{"schemaVersion":"jobsearcher.job.v1","id":"d1fac150a858222cf492bc34","url":"https://jobsearcher.com/jobs/d1fac150a858222cf492bc34","canonicalUrl":"https://jobsearcher.com/jobs/d1fac150a858222cf492bc34","title":"PL/SQL Developer","description":"PL/SQL Developer – Remote – Contract\n Job Description\n 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.\n Key Architecture\n 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.\n Technology Focus\n Primary Focus: Oracle PL/SQL web application with DHTMLX-based frontend.\n Secondary: Node.js APIs and modern tooling.\n Future: React components (distant roadmap).\n Core Skills\n \n Advanced SQL\n Frontend: DHTMLX v5.1, Vanilla JavaScript, HTML/CSS\n Node.js, Oracle PL/SQL\n AWS (proficient)\n React\n \n Senior Developer Requirements\n Must-Have Technical Skills\n Oracle & Database (Critical)\n \n Oracle PL/SQL development (4+ years)\n \n Writing functions, procedures, packages, views\n Complex business logic implementation\n Database performance tuning and optimization\n \n \n Oracle MOD_PLSQL web framework\n \n Database-driven web application patterns\n Understanding of Oracle Application Server deployment\n \n \n Advanced SQL\n \n Multi-table joins, analytical functions\n Query optimization for large datasets\n Oracle-specific features and functions\n \n \n \n Frontend Legacy Technologies (Critical)\n \n DHTMLX Suite v5.1 Professional (2+ years preferred)\n \n Grid components, forms, layouts, charts\n Custom component configuration and styling\n Event handling and data binding patterns\n \n \n Vanilla JavaScript\n \n DOM manipulation without frameworks\n AJAX patterns and asynchronous programming\n Cross-browser compatibility considerations\n \n \n HTML/CSS\n \n Semantic markup for data-heavy applications\n CSS for enterprise application styling\n Responsive design principles\n \n \n \n Web Application Architecture\n \n Database-driven web applications\n \n Understanding of thick database, thin application layer patterns\n Session management and state handling\n Server-side rendering from database procedures\n \n \n jQuery (2+ years)\n \n DOM manipulation and event handling\n AJAX integration with Oracle backend\n Plugin development and integration\n \n \n \n Should-Have Technical Skills\n Modern Backend Development\n \n Node.js/Express.js (2+ years)\n \n RESTful API development\n Oracle node-oracledb connectivity\n Authentication and middleware patterns\n \n \n \n Cloud & DevOps\n \n AWS services: ECS, RDS Oracle, S3, CloudWatch\n Docker: Basic containerization concepts\n Git: Version control and collaboration workflows\n \n Development Environment\n \n Oracle SQL*Plus/SQL Developer/TOAD: Database development tools\n JavaScript debugging: Browser dev tools, debugging techniques\n Unix/Linux command line: Basic system administration\n \n \n #J-18808-Ljbffr","company":"Creative Solutions Services","rawCompany":"creative solutions services","city":"Prescott","state":"AZ","isRemote":false,"isActive":false,"createdAt":"2026-06-02T13:03:01.331Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1254.00","title":"Web Developers","slug":"web-developers"},{"code":"15-1251.00","title":"Computer Programmers","slug":"computer-programmers"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"PL/SQL Developer","description":"PL/SQL Developer – Remote – Contract\n Job Description\n 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.\n Key Architecture\n 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.\n Technology Focus\n Primary Focus: Oracle PL/SQL web application with DHTMLX-based frontend.\n Secondary: Node.js APIs and modern tooling.\n Future: React components (distant roadmap).\n Core Skills\n \n Advanced SQL\n Frontend: DHTMLX v5.1, Vanilla JavaScript, HTML/CSS\n Node.js, Oracle PL/SQL\n AWS (proficient)\n React\n \n Senior Developer Requirements\n Must-Have Technical Skills\n Oracle & Database (Critical)\n \n Oracle PL/SQL development (4+ years)\n \n Writing functions, procedures, packages, views\n Complex business logic implementation\n Database performance tuning and optimization\n \n \n Oracle MOD_PLSQL web framework\n \n Database-driven web application patterns\n Understanding of Oracle Application Server deployment\n \n \n Advanced SQL\n \n Multi-table joins, analytical functions\n Query optimization for large datasets\n Oracle-specific features and functions\n \n \n \n Frontend Legacy Technologies (Critical)\n \n DHTMLX Suite v5.1 Professional (2+ years preferred)\n \n Grid components, forms, layouts, charts\n Custom component configuration and styling\n Event handling and data binding patterns\n \n \n Vanilla JavaScript\n \n DOM manipulation without frameworks\n AJAX patterns and asynchronous programming\n Cross-browser compatibility considerations\n \n \n HTML/CSS\n \n Semantic markup for data-heavy applications\n CSS for enterprise application styling\n Responsive design principles\n \n \n \n Web Application Architecture\n \n Database-driven web applications\n \n Understanding of thick database, thin application layer patterns\n Session management and state handling\n Server-side rendering from database procedures\n \n \n jQuery (2+ years)\n \n DOM manipulation and event handling\n AJAX integration with Oracle backend\n Plugin development and integration\n \n \n \n Should-Have Technical Skills\n Modern Backend Development\n \n Node.js/Express.js (2+ years)\n \n RESTful API development\n Oracle node-oracledb connectivity\n Authentication and middleware patterns\n \n \n \n Cloud & DevOps\n \n AWS services: ECS, RDS Oracle, S3, CloudWatch\n Docker: Basic containerization concepts\n Git: Version control and collaboration workflows\n \n Development Environment\n \n Oracle SQL*Plus/SQL Developer/TOAD: Database development tools\n JavaScript debugging: Browser dev tools, debugging techniques\n Unix/Linux command line: Basic system administration\n \n \n #J-18808-Ljbffr","datePosted":"2026-06-02T13:03:01.331Z","dateModified":"2026-06-02T13:03:01.331Z","hiringOrganization":{"@type":"Organization","name":"Creative Solutions Services","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Prescott","addressRegion":"AZ","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"d1fac150a858222cf492bc34"},"url":"https://jobsearcher.com/jobs/d1fac150a858222cf492bc34"}}