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.