Oracle Apex Developer

Responsibilities:Lead design, develop, and maintain Oracle APEX application to meet business requirements.Collaborate with business analysts and stakeholders to understand application requirements and translate them into efficient database designs.Integrate Oracle APEX applications with other systems and databases as needed.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.Provide technical guidance and mentorship to junior developers on Oracle APEX development best practices.Participate in code reviews and contribute to the continuous improvement of development practices.Implement REST web services to fetch and push data.Perform database migrations, upgrades, and patching as required.Develop and maintain technical documentation including data models, schema diagrams, and standard operating procedures.Stay up to date with the latest Oracle technologies and best practices.Review and validate solution design and ensure it covers all the technical aspects.Coordinate with the offshore teams on the development activities and participate in solution design discussions.Other Responsibilities:Perform other work-related duties as assigned. Participate as a member of a high-performance team for targeted/strategic initiatives. Attend training or learning opportunities to broaden knowledge.Work on internal and external demos for various project POCs.Work closely with various integration teams like Oracle SOA, Azure Data Bricks team, etc. for data integration.Work with data analysts to analyze and locate the correct data for data modeling purposes.Test applications as needed and work with the test leads to analyze/address issues.Oversee daily technical operations.Coordinate with the software development team in addressing technical debt.Qualifications:Proven work experience as an Oracle APEX Developer.Strong knowledge of Oracle PL/SQL and SQL.Experience with Oracle Database design and performance tuning.Proficiency in web technologies such as HTML, CSS, JavaScript, jQuery, and RESTful web services.Strong communication skills are an absolute requirement.Ability to work independently and collaboratively in a fast-paced environment.Experience dealing with large data and developing complex APEX based applications with an understanding of creating data models, DDL, and using Oracle Database 19c.Evaluate and validate solution interfaces, integration points, and dependencies.Liaising with the engineering team for project completion.Reviewing ongoing operations and rectifying any issues.Understanding project requirements and developing detailed structure.Implementing best practices and coding standards.Experience with Agile development methodologies is a plus.Technologies:

Oracle APEX, SQL, PL/SQL, Oracle database, JavaScript, CSS, HTML, jQuery, and AJAX.Preferred Qualifications:Oracle APEX certification.Oracle Certified Professional (OCP) certification.Knowledge of data warehousing concepts and ETL processes.Familiarity with the healthcare or clinical research industry.GxP, Life Science domain knowledge, Clinical Trials.This is a remote position.

#J-18808-Ljbffr