GA DHS - Senior Java and Database Developer

Short Description:
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.

Complete Description:
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
nd 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
nd 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.