Oracle Apex Developer

Skills

· 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 communications skills an absolute requirement. · Ability to work independently and collaboratively in a fast-paced environment. · Implementing Rest webservices to Fetch and push data. · Experience dealing with large data and developing complex APEX based applications and have understanding creating data model 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.

Description

· 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 webservices 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.

Responsibilities

• · 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.
• · Work on internal and external demos for various project POC’s.
• · 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 modelling purposes.
• · Test Applications as needed and work with the test leads to analyze /address issues.
• · Overseeing daily technical operations
• · . Coordinating with the software development team in addressing technical debt