Reporting to the Manager – Enterprise Systems Planning & Delivery, the role holder will be responsible for development and 3rd line support of the Oracle Enterprise Resource Planning (ERP) application (On-Prem and Fusion), POS Application and bespoke oracle interfaces and software components.

He or she will work with other departments within the company to identify requirements and develop solutions (database design, workflows, user/data interfaces).

The role holder will also configure and/or customize Oracle ERP applications to meet business requirements using various database and software tools, assist in presentations of system functionality to new users and departments and enhance and create user and system documentation as needed.

RESPONSIBILITIES

• Review and provide input on design approach, performance and base functionality. Ensure integration of designs across development team and design, build & test ERP components e.g. interface, conversion and report programs;
• Appropriately monitor interfaces to oracle ERP. Provide training and support on oracle ERP modules and development tools, review & interpret technical manuals for the Oracle ERP system and assist in creating/update Oracle TAR’s.
• Perform integrations between on-premise ERP and Fusion and also integrations to third party systems.
• Ensures the effectiveness of overall systems performance.
• Design and develop front-end tier(s), middle tier(s), and /or back-end database tier(s) for business applications.
• Participate in the capturing of business applications information needs and mapping of the same to the software and /or database components.
• Perform data modeling to analyze and specify data structures within an application system.
• Support new and existing application development by creating modifications and enhancements for Oracle ERP applications and perform high level system design.
• Conduct business user requirements analysis and specification.
• Specify computer system requirements for the solution of complex business problems and formulates designs for their solutions.
• Perform the necessary technical design and development functionality to ensure that business application systems can be effectively developed and implemented.
• Interact with clients to gather and refine requirements.
• Create test plans, test data sets and perform automated testing to ensure all components of the developed systems meet specifications.
• Work directly with the IT support personnel and teams to resolve issues identified and escalated during daily operations.
• Perform root cause analysis for recurring incidents.
• Formalize test plans and implement troubleshooting procedures.

QUALIFICATIONS

• IT, Engineering, Computer Science/Software Engineering.
• Extensive programming experience using Java J2EE, Pl/Sql, VB, SQL,C++
• Extensive experience with databases – data structures, relational data model, Stored Procedures, PL/SQL development or NoSQL DBs.
• Certification in Database systems and RDBMS systems, OCA, OCP or ODI/SOA certifications.
• Extensive experience working with Cloud Native applications and development. Experience in ERP integrations both Fusion and EBS.
• 3 years of work experience in Oracle ERP applications development, which includes system customization and report designs.
• Conversant with OAF development
• 3 years of work experience with RDMS preferably MS SQL Server, Oracle, Sybase, and Informix.
• Experience in data warehousing, business analysis, knowledge in Business Systems modeling and data retrieval
• 4GL for programming – Visual Basic/Oracle Application builder.
• Unix user skills.
• Experience in processes and procedures management.