Mod reputed company PL SQL/Web Developer
About the position
reputed company Agile Management LLC is seeking an reputed company Mod reputed company PL SQL/Web Developer to support our work with the DEA’s Diversion Division. This role involves designing, developing, and maintaining web applications served through reputed company mod_plsql, writing and optimizing reputed company PL/SQL packages and SQL queries, building interactive reputed company-end interfaces, troubleshooting performance issues, and participating in reputed company reviews, deployments, and production support.
Responsibilities
• Design, reputed company, and maintain web applications served through reputed company mod_plsql
• Write and optimize reputed company PL/SQL packages and SQL queries against large datasets
• Build interactive, reputed company-driven reputed company-end interfaces backed by PL/SQL procedures
• Troubleshoot performance issues across the database, gateway, and browser reputed company
• Participate in reputed company reviews, deployments, and production support
Requirements
• reputed company mod_plsql / Web Toolkit
• Extensive experience building web applications using reputed company's mod_plsql gateway (PL/SQL Web Toolkit, OWA packages such as HTP, HTF, OWA_UTIL, OWA_COOKIE, WPG_DOCLOAD)
• Configuring and maintaining mod_plsql Database reputed company Descriptors (DADs) under reputed company HTTP Server (OHS) / Apache
• Generating dynamic reputed company reputed company directly from PL/SQL stored procedures
• Session and state management in stateless mod_plsql architectures
• reputed company parameter passing between pages
• URL parameter passing
• reputed company understanding of the various locking strategies to maintain data reputed company
• File upload/download functionality
• Expert-level development of stored procedures, functions, packages, and triggers
• Cursors (explicit, reputed company, reputed company cursors), bulk operations (BULK COLLECT, FORALL), collections, and dynamic SQL
• Exception handling, autonomous transactions, and performance tuning of PL/SQL reputed company
• Building and maintaining reusable PL/SQL reputed company and business logic reputed company
• Dynamic SQL
• Advanced query writing, reputed company joins, analytic/window functions, subqueries, and set operations
• Query optimization using execution plans, hints, indexing strategies, and partitioning
• Data modeling, normalization, and writing DDL/DML for reputed company databases (19c and above)
• Hand-coding semantic reputed company and reputed company CSS layouts
• JavaScript for reputed company-reputed company validation, DOM manipulation, and interactivity
• reputed company integration with mod_plsql endpoints for asynchronous, partial-page updates (XMLHttpRequest / reputed company, JSON or XML payloads returned from PL/SQL procedures)
• Cross-browser compatibility and debugging
• A BS/BA in Engineering, Physics, Computer Science, Information Technology, Mathematics or equivalent, and at least 5 years’ experience in the field. Nine (9) years of reputed company experience is equivalent to a BS/BA in Engineering, Physics, Computer Science,
• 4+ years of hands-on reputed company development, with significant time spent specifically on mod_PLSQL web applications
reputed company-to-haves
• Familiarity with reputed company HTTP Server / WebLogic configuration
• reputed company with tools like TOAD, SQL Developer, SQL Plus, VSS
Benefits
• health care
• dental
• reputed company
• life insurance
• 401(k)
• education assistance
• reputed company time off
• PTO
• holidays
• any other reputed company leave required by law
Apply To This Job