Description:

• Develop and incorporate business processes to enhance systems.
• Write and modify PL/SQL code based on requirement, enhancement, and production support with specific emphasis on the development and changes related to data bound queries, SQL tuning, PL/SQL enhancements to get improved performance.
• Develop data interfaces, data transfer, relational diagrams, scheduling, and application code.
• Collaborate development activities with other team members.
• Create technical specifications and other documents as required.
• Develop and enhance PL/SQL code, tune SQL code to get better performance.
• Provide emergency release and production support.
• Analyze and write data exchange interfaces, job scheduling.
• Identify issues with the application data, analyze and apply fixes.
• Support change management including test steps; code changes to build the knowledge base.
• Developing relational data models and system designs as needed.
• Provide support for application implementation.
• Collaborate development and integration activities with other team members and stakeholders.
• Work with business groups, internal-external team to understand requirement and implementation.
• Review application server issues, analyze and provide resolution as requested.
• Professional experience working with Web based applications using Oracle as the backend is required.
• In-depth knowledge of Oracle Database, SQL, PL/SQL programming.
• Strong designing, development, and troubleshooting skills required.
• Knowledge of object-oriented design concepts, XML, HTML, UNIX scripting, web scripting tools, Gitlab and CI/CD.
• Knowledge of scheduling, data exchange interfaces, data analysis and troubleshooting of issues required.
• Working experience with data security, data auditing, vulnerability scanning and report generation.
• Good oral and written communication skills are required.
• Applicants must have strong multitasking capabilities and the ability to work on multiple projects/issues simultaneously including off-hour support as required.
• Applicants must have the ability to assess the impact of software upgrades and other environmental changes.
• Candidate should be able to translate functional requirement, build relational model and transfer relational model into technical design and- application code.

Required / Desired Skills

• Strong working Experience with Oracle database (Required 5 Years)
• Strong PL/SQL and SQL experience including writing, tuning, enhancing and improving performance (Required 5 Years)
• Working experience with relational model and translating functional requirement and relational diagram/data model to an application code (Required 4 Years)
• Knowledge of Object Oriented Design concept, XML, UNIX scripting, bi-directional data interfaces (Required 2 Years)
• Scheduling jobs to automate processes, implementing and creating data auditing and reporting functionalities (Required 2 Years)
• Reviewing, analyzing, troubleshooting and resolution of issues related to performance, data integrity, data interfaces (Required 2 Years)
• Experience with Web Toolkit, Web services development and file handling, GitLab and CI/CD (Desired 2 Years)