Location: Remote
Duration: 7+ Months
Note:
Candidates MUST be able to come onsite to pick up laptop
Job Description:
- Seeking PL/SQL resource with object oriented concept to 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 business process 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 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.
- 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.
- Strong working Experience with Oracle database
- Strong PL/SQL and SQL experience including writing, tuning, enhancing and improving performance
- Working experience with relational model and translating functional requirement and relational diagram/data model to an application code
- Knowledge of Object Oriented Design concept, XML, UNIX scripting, bi-directional data interfaces
- Scheduling jobs to automate processes, implementing and creating data auditing and reporting functionalities
- Reviewing, analyzing, troubleshooting and resolution of issues related to performance, data integrity, data interfaces