Develop and provide support to all system interfaces and coordinate with all team members.
Minimum of 8 years of experience and strong knowledge in Oracle SQL and Advanced SQL.
Very strong knowledge in query tuning and optimization
Should have strong knowledge of all the OTM Schema and OTM tables.
Should have working experience in OTM Database and at least 3 projects should have been implemented.
Should be minimum 2 years of experience in working with Oracle SOA, should have been involved in developing the mappings.
Should have worked in JSON, XML message type and universal standard types like EDIFACT.
To provide technical specifications.
Coordinate with various developers, project managers and analysts to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.
Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.
Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational databases.
Evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components.
Monitor and identify specific programming languages and recommend enhancement to all programs and evaluate all software resolution.
Collaborate with various departments and perform research on all data processing functions.