PLSQL Developer (Java)

Job Title:

Total Experience:

Relevant Experience:

Work Location:

Java & PLSQL Developer

80% focus on PLSQL

20% focus on Java

Primary Skills

• Strong hands-on expertise in PL/SQL:
• Writing complex Stored Procedures, Functions, Packages, Triggers
• Working with Joins, Set Operators, Indexes, Constraints
• Merge statements, Data Manipulation & Conversion
• Exception handling, Collections, Cursors
• Performance tuning and query optimization
• Strong knowledge of SQL query writing with analytical capabilities.
• Java Development (Core Java – 20% role):
• Integration and migration tasks
• Troubleshooting and debugging
• Strong experience in Integration and Migration projects.
• Ability to troubleshoot and resolve complex PLSQL issues.
  

Secondary Skills

• ADF Java (preferred but not mandatory).
  

Key Responsibilities

• Design, develop, and maintain PLSQL packages, procedures, and triggers.
• Optimize and tune SQL queries for performance improvement.
• Handle data migration and integration between systems.
• Develop and support Java-based integrations with PLSQL applications.
• Troubleshoot and resolve issues in production and non-production environments.
• Collaborate with business analysts, QA, and development teams to deliver high-quality solutions.
• Ensure adherence to coding standards, best practices, and security guidelines.
• Provide support for rotational shifts and assist in weekend work if required.