Oracle SQL

Charlotte, North Carolina

SARIAN Co
Apply for this Job
Role: Oracle SQL + Java Developer

Location: Charlotte, NC

Onsite position

Fulltime position

NO C2C

JD:

Skill: Oracle SQL + Java Developer

Must 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.

Manikanth

Sarian Solutions, Inc.

Ph: X 105

Date Posted: 07 May 2025
Apply for this Job