Winfo Solutions - Oracle APEX Consultant (8-10 yrs)

Job Description :

- BE in Computer Science or equivalent experience in the Information Technology field.

- A minimum of 8 years' experience with Oracle APEX, including more recent releases such as 20.

- In-depth knowledge of logical/physical database design and strong experience with Oracle SQL and PL/SQL.

- Good to strong understanding of database interconnectivity and data transfer methods such as REST etc.

- Intermediate or better experience in modern web technologies e. HTML 5, CSS 3, jQuery, JavaScript.

- Awareness of libraries such as the Oracle JavaScript Extension Toolkit (JET) would be very desirable.

- Maintain and enforce APEX, SQL, PL/SQL, JavaScript etc. development and coding standards.

- Experience designing and developing commercial grade web applications using Oracle APEX

- Oracle APEX Oracle EBS Forms/OAF Oracle EBS APIs SQL and PL/SQL A desire to write re-usable, readable code using the most up to date industry standards

- Expertise in developing Apex Applications and UI using features like Interactive Reports, Grids, Dropdown, CSS, JavaScript

- Technical knowledge of Oracle EBS it's data model, APIs, OAF pages, security is expected

- Oracle SQL / Oracle PL/SQL programming experience

- Experience in managing web page layouts with APEX templates and themes

- Ability to design for Industry Best Practice Design in Oracle APEX

- Ability to independently provide time estimates for APEX related tasks

- Proficient SQL scripting skills including stored procedure, functions, and ddl

- Strong communication skills, particularly in translating perceived needs into technical requirements

- Self-motivated and able to work independently in a fast-paced, deadline-driven environment

- Demonstrate strong analytical, critical thinking, troubleshooting and data analysis skills to solve complex issues.

- Experience designing, adapting and implementing technical solutions that are aligned with business strategy.

- Ability to work independently while engaging the customer and providing information to the broader team.

- Excellent written skills, specifically to transform designs into detailed user and technical documentation.

- Thorough understanding of application development project lifecycle and associated methodologies.

- Able to design, develop, test and deploy web applications with very little supervision, if necessary.

- Strong ability to communicate both verbally and in writing with internal and external teams.

- Proven track record of creating intuitive, logical, visually appealing web user interfaces.

- Strong attention to detail, troubleshooting skills and solution orientated mind set.

- Ability to prioritize and multitask on multiple projects or competing requests.

- Comfortable working with and supporting end users questions or requests.

- Experience Apex migration/Upgrade projects

Responsibilities and Duties :

- Should play a solution architect role Should be able to lead and guide the team.

- Designing, developing, testing and documenting new applications and supporting/enhancing existing applications on the APEX platform.

- Perform system analysis and system development tasks.

Analyse functional business requirements to develop solutions and create technical specifications.

- Partner with business analysts, fellow IT resources and end users to evaluate business requirements, minimal viable product requirements, and deliver required features/functions.

- Collaborate with IT business units to ensure that security and architecture requirements are fulfilled.

- Adhere to data architecture guidance and IT best practice methodologies such as the SDLC and Agile etc.

- Continuously identify opportunities for application improvements, performance tuning and resolving issues.

- Collaborate with other IT application owners and leaders to communicate, share and implement best practices.

- Reverse engineer existing applications, including data integrations, and troubleshoot any on-demand problem