Oracle Apex Developer

Overview

Remote
Depends on Experience
Full Time

Skills

Access Control
Acquisition
Amazon Web Services
Apex
Cascading Style Sheets
Cloud Computing
Communication
Conflict Resolution
Critical Thinking
Dashboard
Data Compression
Data Dictionary
Data Management
Database
Database Architecture
Database Design
Database Security
Debugging
Extract
Transform
Load
Forms
HTML
JSON
JavaScript
Management
Migration
OAuth
Optimization
Oracle
Oracle Application Express
Oracle Data Integrator
PL/SQL
Problem Solving
Production Support
Programming Languages
RDBMS
Recovery
Regulatory Compliance
Replication
SQL
SQL*Loader
Scalability
Scripting
Security Clearance
Stored Procedures
Systems Analysis/design
Systems Design
Web Applications
Web Services
Writing

Job Details

Location: 100% remote

Years Experience: 7+ years professional experience

Education: Bachelor s degree in computer science, Software Engineering or IT related field

Work Authorization: ship is required as part of the eligibility criteria to be able to obtain this type of security clearance.

Clearance: Applicants must be able to obtain and maintain up to a Public Trust security clearance.

Key Skills:

  • Highly experience with Oracle database
  • Must have hands-on professional experience with Oracle APEX
  • Experience writing and executing PL/SQL statements
  • At least one Oracle database certification preferred
  • Current or prior Census Bureau experience preferred.

Responsibilities

  • Design and implement database schemas, tables, views, and indexes.
  • Developed procedures, functions and triggers for using PL/SQL.
  • Optimize Oracle database for performance, scalability and reliability.
  • Perform database programming and support systems design.
  • Developer reports using Oracle APEX.
  • Write and execute proficient PL/SQL code.
  • Debug and troubleshoot PL/SQL scripts for stored procedures.
  • Tuning, optimization and troubleshooting multiple environments (20+), stand-alone and pluggable databases, SQL and PL/SQL routines.
  • Analyzing performance issues, diagnosing/resolving affecting database systems.
  • Analyze and improve SQL query performance and identity potential bottlenecks.
  • Ensure database security, access control and compliance with policies.
  • Assist with database migrations and manage Oracle database
  • Design and develop ETL processes to transform data between systems.
  • Experience with Oracle tools such as SQL*Loader, Data Pump, and/or Oracle Data Integrator (ODI).
  • Manage database jobs
  • Manage materialized views
  • Manage connections with external databases
  • Performs data access analysis design, and archive/recovery design and implementation.
  • Develop strategies for data acquisitions, archive recovery, and implementation of a database.
  • Design, build, and maintain structure (e.g. relational) and unstructured databases within a multiple tier environment.
  • Reviews and develops object and data models and the metadata repository to structure the data for better data management and performance.
  • AWS cloud experience highly preferred.

Qualifications

  • 7+ years professional experience
  • Must be able to obtain a maintain a Public Trust Security Clearance
  • Bachelor s degree
  • Oracle development experience supporting large production databases
  • Must have hands-on professional experience with designing, building, and maintaining web applications using Oracle APEX
  • Experience creating interactive reports, forms, dashboards, and workflows
  • Experience optimizing APEX applications for scalability and user responsiveness
  • Integrate APEX applications with REST APIs, web services, and external systems.
  • Proficiency in programming languages such as JavaScript, HTML, CSS, and JQuery
  • Other development experience to include familiarity with REST, OAuth, and/JSON preferred
  • Experience writing and executing PL/SQL statements
  • Experience writing and optimizing PL/SQL code
  • Experience developing complex queries, stored procedures, functions, packages, and triggers.
  • Must have professional experience with Oracle SQL and PL/SQL for Performance tuning
  • Deep knowledge of Oracle partitioning, Indexing and Compression Experience developing complex business logic in the Oracle database using PL/SQL.
  • Monitoring and troubleshooting SQL*Loader/PL/SQL Data Loads for Performance, Coding and Infrastructure issues.
  • Oracle RDBMS experience preferred
  • Experience monitoring and maintaining Oracle database to optimize performance
  • Proven ability to resolve architectural issues in the environment and database infrastructure, as well as develop and maintain an in-depth understanding of the database architecture and the application functionality.
  • Critical thinking and problem-solving abilities to address complex issues involving data movement and data replication. Be able to work independently and have good oral and written communication skills.
  • Must have experience Providing 24X7 and on-call troubleshooting and production support
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.