Responsibilities
Provide technical leadership and architectural guidance for RPS modernization
Design conversion architecture for migrating RPSv4 Sybase ASA databases to a statewide, enterprise, multi-tenant data platform
Develop repeatable conversion scripts and code for multiple assessing units
Create and execute a comprehensive conversion plan
Coordinate technical solutions across infrastructure, database, and application teams
Write, tune, and optimize SQL for large transactional systems
Develop system components supporting data conversion and modernization
Support production activities including issue analysis, defect resolution, and performance tuning
Coordinate with development teams on implementation and integration testing
Work with ORPTS business teams and assessing units to validate data and resolve anomalies
Support user testing efforts and mentor junior technical staff

Mandatory Qualifications (Expert Level)
7+ years (84 months) experience with J2EE technologies including JDBC, JSP, and XML
7+ years experience developing, building, and testing Java EE applications using modern IDEs (Eclipse, NetBeans, IntelliJ)
7+ years experience with J2EE frameworks (Spring, Struts) and application servers (Tomcat, JBoss, WebSphere, WebLogic)
7+ years experience writing SQL for relational databases
7+ years experience in system analysis and design of multi-tier transactional systems
5+ years experience in performance tuning database-driven applications
5+ years experience with messaging technologies such as MQ, JMS, or Kafka

Technical Environment
IBM-based enterprise software and hardware environment
Security, Compliance & Training