Oracle Developer- Expert

Job Title : Oracle Developer- Expert

Duration : 30 months

Schedule : 8-hour work days between the hours of 7 : 30 am and 6 pm.

Location : Albany, NY 12229 (Onsite)

Job Description :

Mandatory Requirements

Expert 84+ months

Desired Requirements

84 Months experience using Microsoft Visual Studio to develop / maintain applications in C# and / or ASP.NET for n-tier web deployment.

84 Months experience developing and maintaining web applications that utilize HTML, XML, JSON, AJAX, JavaScript, jQuery, Bootstrap and Cascading Style Sheets.

84 Months experience with Oracle : Database design, PL SQL coding, stored procedures, packages, indexes, triggers, creating tables, etc.,

84 Months experience interpreting and analyzing business requirements and building the logic within an application's code to meet those requirements.

84 Months experience with Service Oriented Architecture (SOA) application integration including development of secure .Net web-services using Windows Communication Foundation (WCF), SOAP / Restful APIs, message and queue processing, and / or an Enterprise Service Bus.

Experience in designing & implementing micro services.

36 Months experience developing applications that follow Web Content Accessibility Guidelines 2.0

48 Months experience developing applications with MVC 5 or later versions.

24 Months experience in designing & implementing CI / CD workflows.

24 Months experience coding and maintaining applications which contain Health Care data that fall under HIPAA Protected Health Information (PHI).

Responsibilities

Daily Tasks will include but are not limited to the following :

1. Execute full software development life cycle (SDLC)

2. Use Microsoft Visual Studio 2017 or higher and write code using MVC Architecture, .Net, JavaScript, Angular, Ajax, HTML, XML and WCF.

3. Prepare scripts to create and modify existing Oracle tables, create indexes, constraints, triggers, views, etc., code stored procedures and packages, convert and migrate data when necessary.

4. Diagnose and troubleshoot various rules, calculations, and data issues on application reports using Crystal Reports.

5. Mentor and assist other programmers, both state and consultant, providing guidance for debugging, troubleshooting, securing and deploying applications, data access, data communications and system architecture configurations.

6. Use a source code repository, such as Tortoise SVN or Visual SVN, or TFS for checking source code in and out, and branching off new versions of the source code.

7. Work within the IT Service Management System to take in incidents and service requests for the application, as well as request services from other ITS groups.

8. Coordinate service requests with various ITS Chief Operating Office personnel for releases and changes for the application.

9. Diagnose and debug production issues reported via ITSM. Escalate critical calls as necessary and join bridge calls to assist in diagnosis.

10. Report status of current tasks and outstanding issues to supervisor