Job Seekers, Please send resumes to resumes@hireitpeople.com Short Description:  Application Architect with J2EE Team Lead and ORACLE skills.
***This requisition requires onsite in-person first round interviews only.******Client would prefer candidates local to the Harrisburg, PA Area.***
Complete Description:  The position primarily serves as an Application Architect working for PennDOT at The Keystone Building in Harrisburg, PA, Team Lead and Senior J2EE Developer in PennDOT’s Bureau of Business Solutions & Services.  The incumbent will be responsible for design and development of the Pennsylvania Crash Information Tool.  PCIT is a web application that provides access to Pennsylvania crash data including displays such as data tables, bar charts, pie graphs, and maps.  This J2EE application uses Java/Java Script, and displays the data from ORACLE as well as some data from DB2.  
This is a professional level non-supervisory position which will require mentoring and coordinating of programming activities being conducted by the Java development team. Responsibilities also include J2EE development, working in a WebSphere environment utilizing IBM rational products as the development tools.  Because PCIT is heavily data dependent, the position involves database analysis, using Oracle PL/SQL, developing and maintaining tables, views, queries, stored procedures, triggers and functions.  
Specific Duties:• Responsible for designing, developing, and implementing application infrastructure to provide highly-complex, reliable, and scalable applications.• Able to perform a variety of complicated tasks with minimal or no direct supervision.• Consult with management to clarify systems and programs intent, identify problems, suggest changes, and determine extent of application systems changes required.• Work with stakeholders and management to ensure projects are completed on time and according to organization standards.• Manage the revision of existing PCIT program to increase operating efficiency or adapt to new requirements.• Provide vision, problem anticipation, and problem solving ability to manage issues/risks affecting the PCIT project.• Establish development schedule, and allocate work of personnel based on project plans and timelines, then coordinate project activities with development team members.• Analyze and write Java code, Java script, ORACLE PL/SQL and stored procedures.• Serve as a mentor to team members by conducting code reviews, sharing industry best standards and practices and training junior developers in systems analysis, programming, and program coding.• Foster a positive work environment by mentoring, supporting, and committing to the professional development of application team members.• Utilize configuration management tools, design tools, debugging tools, and any other environment specific tools necessary to create, test, and implement an application.• Diagnose, analyze, troubleshoot and choose appropriate solution to fix data related issues.• Develop Oracle SQL and PL/SQL code, including packages, procedures, functions, views and complex analytical queries.• Consult with personnel in other information systems groups to coordinate activities and ensure that all approved development and deployments are delivered.

SkillRequired / DesiredAmountof ExperienceIT experience development, testing, and project management.Required5YearsWorking with Java/J2EE.Required5YearsExperience defining systems and application architecture.Required3YearsORACLE, MS SQL Server and/or DB2 experience.Required3YearsORACLE development experience that includes writing complex SQL and PL/SQL, and doing performance tuning.Required2YearsStrong oral and written communication skills.Required  Working with geospatial mapping technology.Desired1YearsWorking with Crystal Reports.Desired2YearsWorking with IBM RSA development IDE preferred.Desired1YearsWorking with IBM Rational JAZZ RTC.Desired1Years