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 requirementsDevelop 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.5Ensure 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 deploymentPerform 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 databaseWork on migration and resolution of any issues following the Oracle 11g to Oracle 12C on Exalogic platformCreate new and modifying existing pbls in Appeon PowerBuilder to resolve any issues post software application migration
Technical Skills: C#, Oracle Forms, Crystal Reports, PL/SQL, VB.NET, Unix, Appeon PowerBuilder, Oracle 11g, Oracle 12C. 
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.