Senior Java and Database Developer

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.

• DevelopSQL queries and analyze data to support application development andproduction issues.

• Implementobject-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.

• FollowAgile methodologies (Scrum) and participate in sprints, daily stand-ups.

• Useversion 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 Cloakfor identity and access management, ensuring secure communication through OAuth2.0 and JWT tokens.

• LeverageSAML/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.