Java and Database Developer

UNKNOWN; Mechanicsburg (Cumberland County); Hybrid; USD 92,000 - 111,000; Full time

Benefits offered by this job

Day-One Health Coverage

Generous time off

Hybrid schedule with 2 telework days

Salary increases and retirement plans

Employee Assistance Program (EAP)

Job summary

AOPC in Mechanicsburg, PA seeks a Java and Database Developer to support services that exchange information between court case management systems and external agencies. The role emphasizes Java and relational database development, enterprise integrations, and production operations with Spring Boot, Spring Batch, IBM MQ, REST APIs, and scheduled workflows.

Responsibilities include developing and tuning SQL and stored procedures, maintaining Java and database code, investigating production issues,

Qualifications

• Bachelor’s degree with an IT-related major or minor.
• Two years of IT experience involving the analysis, design, and maintenance of databases in overall support of database administration.
• An equivalent combination of education, experience, and/or training may be considered.

Responsibilities

• Develop, debug, maintain, and tune SQL, complex stored procedures, views, triggers, and related database business logic.
• Develop and maintain Spring Boot services, REST APIs, message-based integrations, batch processes, and supporting service-layer code.
• Production support: investigate application issues, data discrepancies, failed integrations, and production incidents, including weekly on-call rotation.
• Integration support: support IBM MQ, APIs, messaging, file transfer, notification, and scheduled-processing workflows across connected application systems.
• Reliability improvements: improve performance, stability, logging, maintainability, availability, and recovery across database and Java components.
• Legacy Application Maintenance: diagnose defects, trace existing business logic, implement targeted fixes and enhancements, refactor Java and database code carefully, and improve performance without disrupting existing integrations.
• Testing and review: test, debug, review, and validate database and Java changes before release according to established procedures.
• Cross-team collaboration: work with analysts, testers, DBAs, developers, and operations staff to deliver reliable changes.

Skills

Java development

Spring Boot

REST APIs

SQL

Batch processing

JDBC/JPA

Education

Bachelor’s degree in IT or related field

Tools

Maven

IBM MQ

Job description

## Java and Database DeveloperApply: Mechanicsburg, PA: Full time: Posted Yesterday: JR100372The AOPC/IT department is seeking a Java and Database Developer to support business-critical services that exchange information between court case management systems and external agencies. This position focuses on Java development and relational database development, along with enterprise integrations and production operations. The work includes Spring Boot, Spring Batch, IBM MQ, REST APIs, and scheduled workflows. The successful candidate will maintain existing Java and database systems, support production operations, troubleshoot application, data, and integration issues, resolve defects, and implement targeted enhancements and controlled refactoring in legacy applications while preserving established business behavior, data integrity, and integration contracts.***AOPC does not sponsor work visas.*** ## **Job Duties*** **Database development: Develop, debug, maintain, and tune SQL, complex stored procedures, views, triggers, and related database business logic.*** **Java development: Develop and maintain Spring Boot services, REST APIs, message-based integrations, batch processes, and supporting service-layer code.*** **Production support: Investigate application issues, data discrepancies, failed integrations, and production incidents, including weekly on-call rotation.*** **Integration support: Support IBM MQ, APIs, messaging, file transfer, notification, and scheduled-processing workflows across connected application systems.*** **Reliability improvements: Improve performance, stability, logging, maintainability, availability, and recovery across database and Java components.*** **Legacy Application Maintenance: Diagnose defects, trace existing business logic, implement targeted fixes and enhancements, refactor Java and database code carefully, and improve performance without disrupting existing integrations.*** **Testing and review: Test, debug, review, and validate database and Java changes before release according to established procedures.*** **Cross-team collaboration: Work with analysts, testers, DBAs, developers, and operations staff to deliver reliable changes.** ## **Minimum Qualifications*** **Bachelor’s degree with an IT-related major or minor, PLUS*** **Two years of IT experience involving the analysis, design, and maintenance of databases in overall support of database administration OR*** **An equivalent combination of education, experience, and/or training may be considered.** ## **Additional Requirements/Preferences*** **Ability to develop and maintain Spring Boot services, REST APIs, Spring batch processes, JDBC/JPA access, and configuration.*** **Experience supporting REST APIs, IBM MQ or another enterprise messaging platform, message-based workflows, scheduled jobs, secure transfers and application logs, with an understanding of service dependencies, failover, retries, timeouts, idempotency and recovery.*** **Significant hands-on experience with SQL and databases such as developing, debugging and maintaining complex stored procedures and database business logic, including triggers, views, joins, scripts, query tuning and data reconciliation.*** **Working knowledge of SAP ASE/Sybase or a comparable database platform.*** **Working knowledge of Maven.*** **Ability to diagnose issues, communicate status clearly.*** **Ability to explain technical findings and take ownership of tested work.*** **Satisfactory criminal background check required.** ## **Key Benefits & Perks*** **Day-One Health Coverage:** **Comprehensive, low-cost medical, dental, vision, and prescription plans for you and your eligible family members starting on your very first day.*** **Generous Time Off: 13 paid holidays, 12 paid sick days, and 12+ paid vacation days per year.*** **Family Support: 6 weeks of paid parental leave for eligible employees, plus access to a Healthcare Flexible Spending Account (FSA).*** **Work-Life Balance: Hybrid schedule offering 2 telework days per week following initial training.*** **Financial & Personal Well-Being: Structured salary increases, retirement plans, and free Employee Assistance Program (EAP) resources.****Salary information****Starting Annual Salary Range: $91,890 - $110,594**