Description

This role focuses on a split of 60% Oracle PL/SQL and Unix development and 40% Java development.

Responsibilities

• Develop complex database objects including stored procedures, functions, packages, and collections.
• Write and optimize PL/SQL code using triggers, cursors, bulk collect, and autonomous transactions.
• Build and maintain microservices using Java 17+ and Spring Boot 3.3.
• Implement RESTful web services and manage messaging queues via JMS.
• Perform SQL query tuning and database performance tuning to optimize execution plans.

Required Skills

• 5+ years of experience in software development.
• Expertise in Oracle PL/SQL (10g, 11g, 12c, 19c) and Unix.
• Advanced SQL skills including creating tables, views, constraints, sequences, and synonyms.
• Proficiency in Core Java, J2EE, and Java 17+.
• Hands-on experience with Spring Boot 3.3, Hibernate, and Spring Data JPA.
• Experience building REST APIs with Open API spec/Swagger 2.0.
• Knowledge of Microservices architecture and AWS Kubernetes.
• Experience with Docker, AWS MSK, Kibana, Grafana, and ElasticSearch (AWS OpenSearch).
• Competency in unit testing using JUnit and Mockito.
• Familiarity with PostgreSQL and JMS messaging.

Preferred Skills

• Experience with Oracle Hint and Explain Plan for performance optimization.

Key Skills

Education

Any Graduate