Applications Developer tasks / Forms and Reports, PL/SQL are not required.
Applications DBA tasks and/or Application Technical Consultants Tasks are not required.
Handling tickets and application support to the end-users. When an issue is received, it needs to be analyzed and resolved - In case, if the issue requires the support of development, then transfer the issue to development team with the inputs. Monitor and help development team to complete the task - In case, if the issue requires support from Oracle, then raise SR and co-ordinate with oracle support team till closure - In case, if the issue requires to run diagnostics requests, SQL’s or any other required to identify or resolve the issue, then run those required (data fix SQL’s when Required) and update SR’s and co-ordinate with oracle support team till closure - In case, if the issue requires the support of Database Technical Consultants/DBA, then Describe and transfer the issue to Technical Consulting team with the inputs. Monitor and help Technical team to complete the task - Preparing MD050/MD060 documents for any customizations - Preparing Test Cases, Test Data & testing. - Interaction with client/end users & updating the issue status. - Training the end users and preparing end user training material. - There will also be interaction with other modules consultants/Technical Consultants/DBAs/Developers - Creation of process documents & its updating if required
Functional consultant should know the basic SQL and the important tables and how to run diagnostics and SQL’s. Data Loader is an easy to use tool, hence it is better to know it. Knowledge of discoverer is a plus.