Job description

Job Title : Oracle PL/SQL Developer with Performancetuning

Location: Bangalore

Experience: 6 - 12 years

Domain: Banking (Preferred)

Notice period : 0-15days

Mandatory Skills:

• PL/SQL Development
• Writing Complex Queries
• Stored Procedures and Packages
• Performance Tuning

Secondary Skills:

• XML
• JSON

Job Summary:

Key Responsibilities:

• Develop, optimize, and maintain complex PL/SQL queries, stored procedures, and packages.
• Perform query performance tuning to ensure efficient data retrieval and processing.
• Collaborate with business analysts and application developers to design and implement database solutions.
• Troubleshoot and debug database-related issues.
• Work with XML and JSON data structures for data integration.
• Ensure data integrity, security, and consistency across systems.
• Prepare technical documentation and participate in code reviews.
• Troubleshooting production issues in lower environments with strong debugging skills.
• Participate in Production Issue triage Bridge Calls and provide solutions.
• Understanding of Agile methodologies and maintain the Jira Hygiene.
• Automate Unit Tests using Ruby Cucumber.
• Interact with business users, front-end developers, Business Analysts, and QA as part of the development process.
• Collaborate with Production L2 Support and ensure defect backlogs are within threshold.
• Conduct daily status exchanges internally with the team and communicate via email to counterparts/Bank.
• Participate in scrum calls, retrospection meetings, and code reviews.
• Lead and manage a team of developers, Business Analysts, and QA.
• Forecast project resource requirements and manage hiring, onboarding, and offboarding.
• Track progress and make adjustments as needed to keep delivery on track.
• Provide technical leadership and mentorship to the team.
• Participate in Production Incident Bridge calls and provide suggestions/solutions.

Skills

oracle SQL,PLSQL,XML, JSON