Job summary:

Job description:

*** Very long term project; Long term - usually goes for 3+ years***remote project but must pick laptop in person at Harrisburg PA *** 37.5 hours per week ***

The candidate must possess strong software engineering skills, and a strong development background in Oracle PL/SQL, Oracle Forms and strong knowledge of an Oracle RDBMS. Prior Commonwealth and Environmental experience not required but preferred.

Initial Tasks to be accomplished:

• Understand the inner workings of the DAMS Application and its interfaces to other Oracle systems.
• Work with the tech lead to design the Oracle DB for the DAMS project in an Agile Scrum environment
• Work with the tech lead to develop the database procedures and functions to support business logic functions and to support web application, creating the infrastructure needed to support database
•  Understand the roles, security and authorization within the DAMS and integrated systems.
• Review selected documentation of the existing systems to become familiar with the system requirements, functionality, and architecture, reporting, etc.
• Generate, Technical and Business Functional documents, system documents.
• Profile and tune selected pieces of the system for better maintainability and performance as necessary.
• Provide mentoring and assistance as required for the transfer of knowledge to other developers and Commonwealth IT staff.
• Aid in production deployments of systems as needed.
• Provide weekly status updates to team manager or other DEP managers as requested.
• Generate reports as needed for executive management, end-users, and BIT staff

Required Skills:

• A Bachelors degree in Computer Science or a related field
• 5-7 years of Oracle PL/SQL writing stored procedures, functions and advanced queries
• 5-7 years experience developing in Oracle Forms
• Sound Knowledge of Oracle DBMS
• Strong experience using SQL Developer/TOAD
• Understanding of Data Modeling
• Understanding of Web services integration
• Performance Tuning, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server
• Strong Communication skills
• Strong Analytical skills

Desired Skills:

• Understating and have exposure of the following technologies:
  • XML, 
  • HTML, 
  • APEX, 
  • Web Services
  • JAVA 
  • PL/SQL API
  • SOA
  • Agile /Scrum Development methodologies  
• Installation of Oracle software like Oracle forms and reports

Contact the recruiter working on this position:

The recruiter working on this position is Nagineni Krishna Sai(Shaji Team)
His/her contact number is +(1) (703) 5742066
His/her contact email is krish@msysinc.com

Our recruiters will be more than happy to help you to get this contract.