GA DHS - Senior Java and Database Developer - Abacus Service Corporation

The Georgia Client (Client), Office of Information Technology, is seeking a qualified candidate for a contractor staffing position for a Senior Java and Database Developer on Georgia's Child Welfare technical team in Atlanta, Georgia.

The suitable candidate will be a Java Developer with strong database knowledge. This role will be responsible for developing and maintaining high-quality software applications, ensuring seamless integration with various database systems.
Java Responsibilities
Develop and maintain Java-based applications using core Java and advanced Java (Java 17).
Design and implement microservices using Spring Boot and other relevant frameworks.
Build and consume RESTful APIs and web services.
Integrate with databases , ensuring performance optimization (e.g., SQL databases like PostgreSQL, Oracle).
Write unit and integration tests using JUnit, TestNG, Mockito, or other testing frameworks.
Develop SQL queries and analyze data to support application development and production issues.
Implement object-oriented design principles and patterns for scalable and maintainable codebases.
Ensure adherence to clean code principles and write reusable, modular code.
Troubleshoot and debug Java applications, ensuring optimal performance and security.
Participate in code reviews and provide constructive feedback to peers.
Follow Agile methodologies (Scrum) and participate in sprints, daily stand-ups.
Use version control systems like GitHub for source code management.
Implement and manage CI/CD pipelines using GitHub Actions.
Collaborate with DevOps teams for cloud deployment and infrastructure management (AWS).
Design, configure, and implement Spring Batch jobs for processing large datasets and scheduling tasks.
Implement dynamic web pages and views using JSP (Java Server Pages).
Design and implement authentication and authorization mechanisms using Key Cloak for identity and access management, ensuring secure communication through OAuth 2.0 and JWT tokens.
Leverage SAML/SSO integration for single sign-on and authentication.

• Proficiency in Postgres, PL/SQL and Oracle database technologies.
• Formulating data dictionaries that are congruent with task specifications.
• Creating technical documents that outline the purpose, capacity, and guidelines attached to each database.
• Providing practical guidance on the use and migration of each database.
• Servicing and updating databases, as required.

Database Responsibilities

• Development: Design and implement PL/SQL functions, procedures, and packages to meet business requirements.
• Triggers: Create and manage database triggers for automation of tasks and enforcement of business rules.
• Performance Tuning: Optimize SQL queries and PL/SQL code for performance and scalability.
• Database Design: Collaborate with the data modeling team to create efficient database designs.
• Testing: Conduct unit and integration testing of PL/SQL code to ensure reliability and accuracy.
• Documentation: Maintain documentation for developed code, processes, and database schemas.
• Collaboration: Work closely with application developers, business analysts, and other stakeholders to gather requirements and provide technical support.
• Troubleshooting: Diagnose and resolve database issues, including performance bottlenecks and data integrity problems.

Experience and Technical Skills Required

• Seven (7) years of experience in Java and modern technologies .

Previous experience using
- Java ( Java 17+) features such as records, sealed classes, switch expressions, pattern matching, and enhanced performance improvements
- Node 16+
- ServiceNow, Splunk, Dynatrace
- Spring Framework (Spring Boot, Spring MVC, Spring Data, Spring Security, Spring Batch)
- Microservices Architecture (Designing, developing, and deploying microservices)
- Java Server Pages (creating dynamic web pages and integrating with back-end logic)
- Database Management (PostgreSQL, Oracle and experience with ORM tools like Hibernate)
- RESTful Web Services (API development, consumption, and integration)
- Thorough understanding of REST, SOAP, Web services and API Communication protocols S/FTP/S, HTTP/S, File I/O etc.
- Testing : JUnit, TestNG, Mockito
- Version Control : GitHub
- Build Tools : Maven, NPM
- CI/CD : GitHub Actions
- Frontend Integration : Understanding of HTML, CSS, JavaScript, and Angular 17+
- Security & Identity Management : Experience with OAuth 2.0, JWT tokens, and SAML/SSO integration for authentication and authorization
- KeyCloak Integration : Integrate KeyCloak with Java-based applications and services for API authentication
- Scripting Languages: Proficiency in one or more scripting languages, such as Bash, or PowerShell, Python
- Experience with cloud-based databases (e.g., AWS RDS).
- Proficiency in SQL and experience with relational databases (e.g., MySQL, PostgreSQL, Oracle).
- Knowledge of NoSQL databases (e.g., MongoDB, Cassandra) is a plus.
- Familiarity with agile methodologies.