Job Seekers, Please send resumes to resumes@hireitpeople.com
Detailed Job Description:
- Interact with the customer and participated in user requirement sessions to analyze, gather and design business requirements
- Develop and maintain applications with Oracle Forms, Crystal Reports, Appeon PowerBuilder, PL/SQL, VB.NET, Unix, C#/Powerscript code utilizing the ASP.NET framework 4.0/4.5
- Ensure that the correct data calculations and data display happens by monitoring the SQL jobs, which run in varying frequencies.
- Constant communication with the users and Managers to enhance the ease of the application based on the requirements.
- Modify existing code to satisfy the change requested.
- Developing data models to support new change requirements.
- Normalizing the tables/ relationships to arrive at an effective relational schema without any redundancy to design an OLTP system for the application.
- Work on creating Object Oriented Programming objects like classes and methods using C#/Powerscript to perform the necessary calculations and perform exception handling and displaying the detailed errors.
- Creating and modifying the Oracle database objects including tables, indexes, views, triggers, procedures and functions to support the changing functionality.
- Developing Oracle Forms, Crystal Reports, Appeon PowerBuilder to incorporate the requested enhancements into the current application.
- Perform query optimization using the execution plan and working closely with the DBA's to enhance the performance of the database.
- Troubleshooting to resolve production issues and bugs within the application environment.
- Providing support to the users, ensuring timely and effective resolution.
- Writing detailed classes and methods in C#/Powerscript to connect to the Oracle database to fetch data as well as insert data back into the database.
- Schedule timely code reviews and maintain version control for code reuse.
- Support deployment of code into production and resolve any issue post deployment
- Perform Unit Testing and Regression Testing on the code developed to ensure proper application workflow.
- Write and provide SQL Queries to the users to generate daily/weekly/monthly reports based on the required criteria.
- Work on Migrating Software application from Appeon PowerBuilder 11 to Appeon PowerBuilder 2019 and then migration to Appeon Powerweb application utilizing Power Server and Internet Information Services (IIS)
- Run batch jobs developed in Unix shell script and PL/SQL to send out reports to multiple agencies and email notifications in case of any failures in the application.
- Engaging with customers, providing technical design solutions and providing alternative workflow to ensure that the business does not halt.
- Ensure all automated processes are documented, including how to overcome errors that may occur.
- Design data model to create new interface for online licensing application using PL/SQL procedures, functions, triggers and packages to route data from the load table to its respective primary tables in Oracle 12C/11g database
- Work on migration and resolution of any issues following the Oracle 11g to Oracle 12C on Exalogic platform
- Create new and modifying existing pbls in Appeon PowerBuilder to resolve any issues post software application migration
Education: Bachelor’s degree or equivalent in Computer Science or equivalent in a related field or a foreign equivalent or closely related field with relevant experience.
