TriOptus LLC
GA DHS - Senior Java and Database Developer
TriOptus LLC, Atlanta, Georgia, United States, 30383
The GeorgiaDepartment of Human Services (DHS), Office of Information Technology, isseeking a qualified candidate for a contractor staffing position for a
Senior Java and Database Developer
on Georgia'sChild Welfare technical team in Atlanta, Georgia.
The suitable candidate will be a Java Developer with strongdatabase knowledge. This role will be responsible for developing andmaintaining high-quality software applications, ensuring seamless integrationwith various database systems.
Java Responsibilities•
Develop and maintain Java-based applications
using core Java andadvanced Java (Java 17).•
Design and implement microservices
using Spring Boot andother relevant frameworks.• Buildand consume
RESTful APIs
and web services.•
Integrate with databases , ensuring performance optimization(e.g., SQL databases like PostgreSQL, Oracle).• Writeunit and integration tests using
JUnit, TestNG, Mockito , or othertesting frameworks.• Develop SQL
queries and analyze data to support application development andproduction issues.• Implement object-oriented design principles
and patterns for scalable andmaintainable codebases.• Ensureadherence to
clean code principles
and write reusable, modular code.•
Troubleshoot and debug
Java applications, ensuring optimalperformance and security.• Participatein
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.• Implementand manage
CI/CD pipelines
using GitHub Actions.• Collaboratewith DevOps teams for
cloud deployment and infrastructure
management(AWS).• Design,configure, and implement
Spring Batch
jobs for processing large datasetsand scheduling tasks.• Implementdynamic web pages and views using
JSP (Java Server Pages) .• Designand implement authentication and authorization mechanisms using
Key Cloak for identity and access management, ensuring secure communication through
OAuth2.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.• Previousexperience 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, SpringSecurity, Spring Batch)
-
Microservices Architecture
(Designing,developing, and deploying microservices)
-
Java Server Pages
(creating dynamic web pages and integratingwith back-end logic)
-
Database Management
(PostgreSQL, Oracle and experience with ORMtools like Hibernate)
-
RESTful Web Services
(API development, consumption, and integration)
- Thoroughunderstanding of
REST, SOAP, Web services
and API Communicationprotocols 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, andAngular 17+
-
Security & Identity Management : Experience with
OAuth2.0 ,
JWT tokens , and
SAML/SSO integration
for authenticationand authorization
-
KeyCloak Integration : Integrate
KeyCloak
with Java-basedapplications 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.,
AWSRDS ).
- Proficiencyin SQL and experience with relational databases (e.g.,
MySQL, PostgreSQL,Oracle ).
- Knowledgeof
NoSQL
databases (e.g.,
MongoDB, Cassandra ) is a plus.
- Familiaritywith agile methodologies.
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceExperience in Java and modern technologies.Required7YearsJava (Java 17+) features such as records, sealed classes, switch expressions, pattern matching, and enhanced performance improvements.Required3YearsNode 16+Required3YearsServiceNow, Splunk, DynatraceRequired3YearsSpring Framework (Spring Boot, Spring MVC, Spring Data, Spring Security, Spring Batch)Required3YearsMicroservices Architecture (Designing, developing, and deploying microservices)Required3YearsJava Server Pages (creating dynamic web pages and integrating with back-end logic)Required3YearsDatabase Management (PostgreSQL, Oracle and experience with ORM tools like Hibernate)Required3YearsRESTful Web Services (API development, consumption, and integration) Required3YearsCI/CD: GitHub ActionsRequired3YearsKeyCloak Integration: Integrate KeyCloak with Java-based applications and services for API authenticationRequired3YearsScripting Languages: Proficiency in one or more scripting languages, such as Bash, or PowerShell, PythonRequired3YearsProficiency in SQL and experience with relational databases (e.g., MySQL, PostgreSQL, Oracle).Required3YearsQuestions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2!!!! list candidate's email address that will be used when submitting E-RTR.Question3Candidate must be paid the rate of 0000 if selected for engagement therefore the SRP rate cannot exceed 0000. Do you accept this requirement?Question4The maximum mark-up for this engagement's SRP rate is 35%. To be competitive on pricing, a mark-up below the 35% threshold is suggested. Do you agree to propose a mark-up at or below 35%?Question5This assignment is contingent upon customer renewal and availability of adequate funding. Do youaccept this requirement?Question6The selected candidate will be expected to start their engagement no later than 2 weeks (10 businessdays) from the client's selection date. Do you accept this requirement?Question7HYBRID work option: However, the selected candidate must be available to report onsite as directed by the client. Do you accept this requirement?
Senior Java and Database Developer
on Georgia'sChild Welfare technical team in Atlanta, Georgia.
The suitable candidate will be a Java Developer with strongdatabase knowledge. This role will be responsible for developing andmaintaining high-quality software applications, ensuring seamless integrationwith various database systems.
Java Responsibilities•
Develop and maintain Java-based applications
using core Java andadvanced Java (Java 17).•
Design and implement microservices
using Spring Boot andother relevant frameworks.• Buildand consume
RESTful APIs
and web services.•
Integrate with databases , ensuring performance optimization(e.g., SQL databases like PostgreSQL, Oracle).• Writeunit and integration tests using
JUnit, TestNG, Mockito , or othertesting frameworks.• Develop SQL
queries and analyze data to support application development andproduction issues.• Implement object-oriented design principles
and patterns for scalable andmaintainable codebases.• Ensureadherence to
clean code principles
and write reusable, modular code.•
Troubleshoot and debug
Java applications, ensuring optimalperformance and security.• Participatein
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.• Implementand manage
CI/CD pipelines
using GitHub Actions.• Collaboratewith DevOps teams for
cloud deployment and infrastructure
management(AWS).• Design,configure, and implement
Spring Batch
jobs for processing large datasetsand scheduling tasks.• Implementdynamic web pages and views using
JSP (Java Server Pages) .• Designand implement authentication and authorization mechanisms using
Key Cloak for identity and access management, ensuring secure communication through
OAuth2.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.• Previousexperience 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, SpringSecurity, Spring Batch)
-
Microservices Architecture
(Designing,developing, and deploying microservices)
-
Java Server Pages
(creating dynamic web pages and integratingwith back-end logic)
-
Database Management
(PostgreSQL, Oracle and experience with ORMtools like Hibernate)
-
RESTful Web Services
(API development, consumption, and integration)
- Thoroughunderstanding of
REST, SOAP, Web services
and API Communicationprotocols 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, andAngular 17+
-
Security & Identity Management : Experience with
OAuth2.0 ,
JWT tokens , and
SAML/SSO integration
for authenticationand authorization
-
KeyCloak Integration : Integrate
KeyCloak
with Java-basedapplications 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.,
AWSRDS ).
- Proficiencyin SQL and experience with relational databases (e.g.,
MySQL, PostgreSQL,Oracle ).
- Knowledgeof
NoSQL
databases (e.g.,
MongoDB, Cassandra ) is a plus.
- Familiaritywith agile methodologies.
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceExperience in Java and modern technologies.Required7YearsJava (Java 17+) features such as records, sealed classes, switch expressions, pattern matching, and enhanced performance improvements.Required3YearsNode 16+Required3YearsServiceNow, Splunk, DynatraceRequired3YearsSpring Framework (Spring Boot, Spring MVC, Spring Data, Spring Security, Spring Batch)Required3YearsMicroservices Architecture (Designing, developing, and deploying microservices)Required3YearsJava Server Pages (creating dynamic web pages and integrating with back-end logic)Required3YearsDatabase Management (PostgreSQL, Oracle and experience with ORM tools like Hibernate)Required3YearsRESTful Web Services (API development, consumption, and integration) Required3YearsCI/CD: GitHub ActionsRequired3YearsKeyCloak Integration: Integrate KeyCloak with Java-based applications and services for API authenticationRequired3YearsScripting Languages: Proficiency in one or more scripting languages, such as Bash, or PowerShell, PythonRequired3YearsProficiency in SQL and experience with relational databases (e.g., MySQL, PostgreSQL, Oracle).Required3YearsQuestions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2!!!! list candidate's email address that will be used when submitting E-RTR.Question3Candidate must be paid the rate of 0000 if selected for engagement therefore the SRP rate cannot exceed 0000. Do you accept this requirement?Question4The maximum mark-up for this engagement's SRP rate is 35%. To be competitive on pricing, a mark-up below the 35% threshold is suggested. Do you agree to propose a mark-up at or below 35%?Question5This assignment is contingent upon customer renewal and availability of adequate funding. Do youaccept this requirement?Question6The selected candidate will be expected to start their engagement no later than 2 weeks (10 businessdays) from the client's selection date. Do you accept this requirement?Question7HYBRID work option: However, the selected candidate must be available to report onsite as directed by the client. Do you accept this requirement?