Role: Oracle SQL + Java DeveloperLocation: Charlotte, NCOnsite positionFulltime position******NO C2C****
JD:Skill: Oracle SQL + Java DeveloperMust Have Technical/Functional Skills: - Primary Skill: Oracle PLSQL.
- Secondary: Core Java, Cassandra, Unix.
- Experience: Minimum 7 years.
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.
ManikanthSarian Solutions, Inc. Ph: 732-790-2266 X 105
manikanth.d@sariansolutions.com | https://www.sarianinc.com/