Senior Java and Database Developer

About the job Senior Java and Database Developer

Interview Type : Web Cam Interview Only

Work Arrangement : Hybrid

Engagement Type : Contract

Short Description:

The Georgia Department of Human Services (DHS), Office of Information Technology, is seeking a qualified candidate for a contractor staffing position for a Senior Java and Database Developer on Georgias 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.

• 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.
• Java (Java 17+) features such as records, sealed classes, switch expressions, pattern matching, and enhanced performance improvements
• Node 16+
• ServiceNow, Splunk, Dynatrace
• 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, File I/O etc.
• Testing: JUnit, TestNG, Mockito
• CI/CD: GitHub Actions
• 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.

#J-18808-Ljbffr