Oracle Apex Developer

TechDigital Group; Morrisville (NC); On-site; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a skilled Oracle APEX Developer to lead the design, development, and maintenance of applications that meet business requirements. This role involves collaborating with analysts and stakeholders to create efficient database designs, integrating applications with various systems, and optimizing database performance. The ideal candidate will have a strong background in Oracle technologies, SQL, and web development, and will thrive in a fast-paced, collaborative environment. Join a dynamic team where your expertise will drive innovation and contribute to impactful projects in the tech landscape.

Qualifications

• Proven experience as an Oracle APEX Developer with strong SQL and PL/SQL skills.
• Ability to work independently and collaboratively in fast-paced environments.

Responsibilities

• Lead development and maintenance of Oracle APEX applications to meet business needs.
• Collaborate with teams for data integration and oversee daily technical operations.

Skills

Oracle APEX

SQL

PL/SQL

JavaScript

jQuery

RESTful web services

Database performance tuning

Communication skills

Education

Oracle APEX certification

Oracle Certified Professional (OCP) certification

Tools

Oracle Database

HTML

CSS

AJAX

Job description

Mandatory Skills - Oracle Apex, SQL, PL/SQL, JavaScript, jQuery

1. Lead design, develop, and maintain Oracle APEX application to meet business requirements.
2. Collaborate with business analysts and stakeholders to understand application requirements and translate them into efficient database designs.
3. Integrate Oracle APEX applications with other systems and databases as needed.
4. Write complex SQL queries, stored procedures, functions, triggers, and packages to implement business logic. Optimize database performance by analyzing query execution plans, indexing strategies, and tuning SQL statements.
5. Provide technical guidance and mentorship to junior developers on Oracle APEX development best practices.
6. Participate in code reviews and contribute to the continuous improvement of development practices.
7. Implement Rest webservices to Fetch and push data.
8. Perform database migrations, upgrades, and patching as required.
9. Develop and maintain technical documentation including data models, schema diagrams, and standard operating procedures.
10. Stay up to date with the latest Oracle technologies and best practices.
11. Review and validate solution design and ensure it covers all the technical aspects.
12. Coordinate with the offshore teams on the development activities and participate in solution design discussions.

Other Responsibilities:

1. Perform other work-related duties as assigned. Participates as a member of a high-performance team for targeted / strategic initiatives. Attends training or learning opportunities to broaden knowledge.
2. Work on internal and external demos for various project POC's.
3. Work closely with various integration teams like Oracle SOA, Azure data bricks team etc. for data integration.
4. Work with data analysts to analyze and locate the correct data for data modelling purposes.
5. Test Applications as needed and work with the test leads to analyze/address issues.
6. Overseeing daily technical operations.
7. Coordinating with the software development team in addressing technical debt.

Qualifications
QUALIFICATION REQUIREMENTS

1. Proven work experience as an Oracle APEX Developer.
2. Strong knowledge of Oracle PL/SQL and SQL.
3. Experience with Oracle Database design and performance tuning.
4. Proficiency in web technologies such as HTML, CSS, JavaScript, jQuery, and RESTful web services.
5. Strong communications skills an absolute requirement.
6. Ability to work independently and collaboratively in a fast-paced environment.
7. Implementing Rest webservices to Fetch and push data.
8. Experience dealing with large data and developing complex APEX based applications and have understanding creating data model, DDL and using Oracle Database 19c.
9. Evaluate and validate solution interfaces, integration points and dependencies.
10. Liaising with the engineering team for project completion.
11. Reviewing ongoing operations and rectifying any issues.
12. Understanding project requirements and developing detailed structure.
13. Implementing best practices and coding standards.
14. Experience with Agile development methodologies is a plus.

Technologies: Oracle APEX, SQL, PL/SQL, Oracle database, JavaScript, CSS, HTML, JQUERY and AJAX
Preferred Qualifications:

1. Oracle APEX certification.
2. Oracle Certified Professional (OCP) certification.
3. Knowledge of data warehousing concepts and ETL processes.
4. Familiarity with healthcare or clinical research industry.
5. GxP, Life Science domain knowledge, Clinical Trials.