Tagcor

Oracle Apex SQL PL/SQL JavaScript jQuery

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.