Oracle APEX and PL/SQL Database Developer

NewGen Technologies

Annapolis Junction, MD, United States

5 days ago

Apply on www.clearancejobs.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www.clearancejobs.com

Tech stack

JavaScript (Programming Language) Application Programming Interfaces (APIs) Ajax (Programming Language) HTML5 Cascading Style Sheets (CSS) Code Review Databases Continuous Integration Data as a Services Relational Databases Database Schema Software Debugging

+32 more

Programming Tools JSON JQuery Oracle Databases Oracle (Applications) Oracle SQL Developer Performance Tuning Query Optimization Oracle Apex Standard Sql Responsive Web Design Secure Coding Software Deployment Software Engineering SQL Stored Procedures PL-SQL SQL Databases Systems Integration Web Applications Apex Code Enterprise Software Applications Application Enhancement Tool Sql Optimization Software Security Software Application Programming Database Performance Git Deployment Automation Front End Software Development Restful APIs Software Version Control Sql Tuning

Job description

The ideal candidate will have strong hands-on experience with Oracle APEX, Oracle SQL, and PL/SQL, combined with front-end development expertise using JavaScript, jQuery, HTML5, and CSS3. The developer will work closely with business stakeholders, technical teams, and database administrators to translate business requirements into secure, scalable, maintainable, and user-friendly applications., * Design, develop, test, deploy, and maintain enterprise applications using Oracle APEX

Develop complex database functionality using Oracle SQL and PL/SQL, including packages, procedures, functions, triggers, views, and dynamic SQL
Build responsive and intuitive APEX user interfaces using HTML5, CSS3, JavaScript, and jQuery
Customize Oracle APEX components, including Interactive Grids, Interactive Reports, forms, Dynamic Actions, LOVs, validations, processes, and shared components
Implement client-side functionality using JavaScript, jQuery, and Oracle APEX JavaScript APIs
Develop and integrate RESTful services and APIs with Oracle APEX applications
Integrate APEX applications with external systems and data sources
Design efficient SQL queries and optimize application and database performance
Troubleshoot and resolve application, PL/SQL, JavaScript, and database-related issues
Implement application security using APEX authentication and authorization schemes, session-state protection, access controls, and secure coding practices
Participate in requirements gathering, technical design, code reviews, testing, and production deployments
Develop reusable APEX components and establish development standards and best practices
Maintain technical documentation for applications, database objects, integrations, and deployment procedures
Provide ongoing production support, debugging, maintenance, and application enhancements

Requirements

We are seeking an experienced Oracle APEX/PL/SQL Developer with 5+ years of professional software development experience to design, develop, enhance, and support enterprise web applications built on Oracle technologies., * TS/SCI FSP Clearance

5+ years of professional software development experience, with significant hands-on development using Oracle technologies
Strong hands-on experience developing applications with Oracle APEX
Advanced knowledge of Oracle SQL and PL/SQL
Experience developing PL/SQL packages, stored procedures, functions, triggers, and other database objects
Strong experience with JavaScript and jQuery, particularly within Oracle APEX applications
Proficiency with HTML5 and CSS3, including responsive web application development
Experience customizing Oracle APEX Universal Theme and application user interfaces
Experience with APEX Dynamic Actions and client-side/server-side processing
Experience developing and customizing Interactive Reports and Interactive Grids
Understanding of AJAX-based processing and communication between APEX pages and PL/SQL
Experience consuming or developing REST APIs / RESTful Web Services
Strong understanding of relational database concepts, data modeling, and SQL performance optimization
Experience troubleshooting applications using browser developer tools and Oracle APEX debugging capabilities
Understanding of application security and secure software development practices
Strong analytical, troubleshooting, and problem-solving skills
Ability to work independently and collaboratively within a development team

Preferred Qualifications

Experience with recent versions of Oracle APEX, including APEX 24.x
Experience with Oracle REST Data Services (ORDS)
Experience integrating Oracle APEX with external enterprise applications and data sources
Experience working with JSON, REST services, and AJAX
Knowledge of Oracle database performance tuning and query optimization
Experience with Git or other source-control systems
Experience with CI/CD and automated deployment processes for Oracle database and APEX applications
Familiarity with accessibility and responsive UI/UX development standards
Experience supporting enterprise or mission-critical Oracle APEX applications

Technical Skills

Primary: Oracle APEX, Oracle SQL, PL/SQL
Front End: JavaScript, jQuery, HTML5, CSS3
Integration: REST APIs, RESTful Web Services, JSON, AJAX, ORDS
Database: Oracle Database, SQL optimization, packages, procedures, functions, triggers, views
Tools & Technologies: Oracle APEX Builder, SQL Developer, browser developer tools, Git/source control