The selected candidate will be responsible for providing guidance and developing conversion scripts for all assessing units as they move to the modernized web-based system. The responsibilities will include developing repeatable scripts/code that can be used for each assessing unit. Specific tasks will include:
Leading the technical design for the conversion of the RPSv4 Sybase ASA databases to the state-wide, enterprise level database data tier within a multi-tenant infrastructure.
Developing a conversion plan for the project.
Coordinating the technical solutions among various technical support groups.
Writing and tuning SQL.
Implementing technical solutions.
Developing system components in support of conversion.
Supporting production tasks including analysis of issue, proposing and implementing solutions for defect resolution.
Coordinating with the development team on development activities and integration testing.
Coordinating with the ORPTS Business team members and the assessing unit contacts to receive current data and identify and resolve data anomalies.
Supporting user testing efforts.
Performance tuning.
Mentoring less experienced staff.
Mandatory Requirements
Experience (8+ Years)
Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large scale software system.
Requirements
This is an 100% Onsite
84 months experience with J2EE technologies including EJB, JDBC, JSP and XML.
84 months experience developing, building, and testing Java EE applications using modern IDE’s, such as Eclipse, Netbeans, or IntelliJ.
60 months experience in writing queries (SQL statements) involving joins and sub-queries of tables.
84 months of experience in performance tuning applications interacting with relational databases.
84 months experience using J2EE frameworks such as Spring or struts and Application Servers such as Tomcat, JBoss, Websphere or Weblogic.
84 months of experience in data modeling, creating logical data models, working with relational databases and experience with XML schemas (definition and automated generation)
84 months of experience in system analysis and design
of multi-tiered transactional systems.