"Alerted.org

Job Description

The Developer Apex (Oracle Application Express) role involves developing and managing Oracle APEX applications, ensuring performance, security, and data solutions for critical systems. Responsibilities include all development lifecycle phases and using APEX, SQL, PL/SQL, and various scripting languages.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Skills and Requirements

Bachelor's degree in Information Systems, Engineering, Computer Science or related field from an accredited university.

• Intermediate experience in a Production Oracle APEX ecosystem or higher education equivalent.

• Intermediate experience in Application Administration/Development using Oracle SQL, PL/SQL, and Developer Oracle Application Express (APEX).

• Intermediate hands-on experience with Oracle APEX 4.0/4.1/5.0/19/20 (Oracle Application Express) administration/Development.

• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.

• Intermediate Skill in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.

• Intermediate hands on experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.

• Intermediate experience in developing External Tables, Joins, Indexes and sequences.

• Worked with third party database tools like TOAD and SQL Developer.

• Intermediate knowledge of Oracle APEX 4.0/4.1/5.0/19/20 (Oracle Application Express) administration/Development, Oracle Database, PL/SQL and SQL.

• Intermediate experience in Database design using Normalization and Entity Relationship Diagrams.

• Intermediate experience in using built-in database packages (DBMS_SCHEDULER).

• Intermediate experience in developing forms based on views, tables and procedures in tabular and form layouts.

• Intermediate experience in developing both web layout and paper lay out reports in various styles based on the user requirements.

• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.

• Creating users and maintaining their roles and responsibilities.

• Experience in writing Technical design documents and developing unit test documents.

• Strong ability to organize information, manage tasks and use available tools to effectively contribute to a team and the organization.

• Strong communication and interpersonal skills, ability to interact with people at all levels.

• Valid Class C Texas Drivers License.

• Makes independent technical recommendations.

• Proficient in Microsoft Office Package, including word processing, spreadsheetss, presentation software,electronic mail and scheduling. null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].