Job Seekers, Please send resumes to swapna@hireitpeople.com
Roles and Responsibilities:
- Supporting the Beacon Application with enhancements to the current functionality, production support, maintenance and daily operations.
- 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 Business Analysts 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.
- Develop and maintain applications with C# code, utilizing the ASP .NET framework 4.0/4.5
- Worked on creating Object Oriented Programming objects like classes and methods using C# to perform the necessary calculations and performed exception handling using try-catch blocks and logging 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 and Reports 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# 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, occurring in bi-weekly sprints.
- Perform Unit Testing and Regression Testing on the code developed to ensure proper application workflow.
- Write and provide SQL Queries to the reporting team to generate daily/weekly/monthly reports based on the required criteria.
- Run batch jobs to send out reports 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.
EDUCATION:
Bachelor’s degree or equivalent in Computer Science, Information Systems, or closely related field with relevant experience.
