Job Role: Oracle SQL + Java Developer

Job Type: Full time/ Permanent

Location : Charlotte, NC

Job Description :

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

Thanks & Regards,

Jahangir Valande | Centraprise Global