
Oracle SQL + Java Developer
Must Have Technical/Functional Skills:
Primary Skill: Oracle PLSQL.
Secondary: Core Java, Cassandra, Unix.
Experience: Minimum 7 years.
Roles & Responsibilities:
Database Development and Optimization:
Design, develop, and maintain complex PL/SQL packages, procedures, functions, triggers and views for mission critical applications.
Write high-performance, scalable PL/SQL code for large and complex business logic.
Write efficient SQL queries for data extraction and transformation.
Tune PL/SQL code and SQL queries for performance optimization.
Analyze execution plans and apply indexing strategies.
Analyze execution plans, optimize SQL and PL/SQL for performance (bulk operations, indexing, pipelined functions).
Refactor poorly performed queries and stored procedures.
Database Design and Architecture:
Assist in data modeling and schema design for new feature or systems.
Ensure normalization, integrity constraints, partitioning, and effective indexing.
Collaborate with DBAs for capacity planning and system tunning.
Core Java Integration.
Build Java components that interact with Oracle database using JDBC/ORM/Spring frameworks.
Collaborate with Java developers to ensure seamless integration of PL/SQL procedures into application layers.
Debug and enhance backend services built with Java.
Data Handling and ETL Support.
Support ETL operations through PL/SQL logic and scripts.
Assist in data validation, cleansing, and transformation task.
Work with large volumes of data across different systems.
Must Have Technical/Functional Skills:
Primary Skill: Oracle PLSQL.
Secondary: Core Java, Cassandra, Unix.
Experience: Minimum 7 years.
Roles & Responsibilities:
Database Development and Optimization:
Design, develop, and maintain complex PL/SQL packages, procedures, functions, triggers and views for mission critical applications.
Write high-performance, scalable PL/SQL code for large and complex business logic.
Write efficient SQL queries for data extraction and transformation.
Tune PL/SQL code and SQL queries for performance optimization.
Analyze execution plans and apply indexing strategies.
Analyze execution plans, optimize SQL and PL/SQL for performance (bulk operations, indexing, pipelined functions).
Refactor poorly performed queries and stored procedures.
Database Design and Architecture:
Assist in data modeling and schema design for new feature or systems.
Ensure normalization, integrity constraints, partitioning, and effective indexing.
Collaborate with DBAs for capacity planning and system tunning.
Core Java Integration.
Build Java components that interact with Oracle database using JDBC/ORM/Spring frameworks.
Collaborate with Java developers to ensure seamless integration of PL/SQL procedures into application layers.
Debug and enhance backend services built with Java.
Data Handling and ETL Support.
Support ETL operations through PL/SQL logic and scripts.
Assist in data validation, cleansing, and transformation task.
Work with large volumes of data across different systems.