Responsibilities:
- Develop and incorporate business processes to produce various reports, data extractions, interfaces, scheduling, data analysis, writing and tunning PL/SQL programs, improve performance.
- Develop and incorporate complex business process to enhance the current applications.
- Write and modify code based on requirement, enhancement and production support with specific emphasis on the development of changes related to application and interfaces 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 specification 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.
Knowledge and Skills:
- 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 hours 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 Skills:
- 5 Years - Strong working Experience with Oracle database
- 5 Years - Strong PL/SQL and SQL experience including writing, tuning, enhancing and improving performance
- 4 Years - Working experience with relational model and translating functional requirement and relational diagram/data model to an application code
- 2 Years - Knowledge of Object Oriented Design concept, XML, UNIX scripting, bi-directional data interfaces
- 2 Years - Scheduling jobs to automate processes, implementing and creating data auditing and reporting functionalities
- 2 Years - Reviewing, analyzing, troubleshooting and resolution of issues related to performance, data integrity, data interfaces
Desired Skills:
- 2 Years - Experience with Web Toolkit, Web services development and file handling, GitLab and CI/CD
Skills Matrix
Skill
Years Used
Last Used
5 Years - Strong working Experience with Oracle database
5 Years - Strong PL/SQL and SQL experience including writing, tuning, enhancing and improving performance
4 Years - Working experience with relational model and translating functional requirement and relational diagram/data model to an application code
2 Years - Knowledge of Object Oriented Design concept, XML, UNIX scripting, bi-directional data interfaces
2 Years - Scheduling jobs to automate processes, implementing and creating data auditing and reporting functionalities
2 Years - Reviewing, analyzing, troubleshooting and resolution of issues related to performance, data integrity, data interfaces
2 Years - Experience with Web Toolkit, Web services development and file handling, GitLab and CI/CD