Oracle PLSQL developer with XML and JSON

United States Digital Space LLC; Karnataka; On-site; INR 900,000 - 1,300,000; Full time

Job summary

United States Digital Space LLC in Bangalore is seeking an experienced Oracle PLSQL developer to analyze, design, and code Oracle SQL, PL/SQL, XML DB, and JSON with a focus on performance tuning.

You will also troubleshoot production issues, work in an Agile environment, and collaborate with business users and frontend developers. A Bachelor's degree is required; notice period is 0-15 days.

Qualifications

• Bachelor’s Degree with 4-5 years of relevant experience as Oracle PLSQL developer.
• Strong SQL programming, PL/SQL functions, scripting experience.
• Hands-on with Oracle SQL, PL/SQL, XML DB, JSON and performance tuning.
• Writing tuned SQL queries, PL/SQL routines, stored procedures, triggers and views.
• Troubleshooting production issues in lower environments with debugging skills.
• Knowledge of performance improvement techniques for design decisions.
• Participate in production incident triage and Jira hygiene.
• Understanding of Agile methodologies and Jira usage.
• Unit tests and automation using Ruby Cucumber.
• Database environment setup and scripting for objects in data dictionary.
• Collaborating with business users and frontend developers.
• Coordinate with L2 support and client services to meet NPS.

Responsibilities

• Closely work with the team to resolve concerns and drive deliverables.
• Forecast project resourcing and manage hiring/onboarding.
• Conduct feedback reviews, recognitions, and appraisals for the team.
• Highlight team pulse to leadership and take action when needed.
• Lead and manage a team of developers, analysts, and QA.
• Lead multiple delivery streams to achieve product outcomes.
• Plan and schedule delivery with scope, milestones, and timelines.
• Identify risks and develop contingency plans to mitigate issues.
• Communicate with stakeholders to keep everyone informed.
• Track progress and adjust to stay on track.
• Provide mentorship and technical leadership to the team.
• Work with L2 Support and Client Service Management to ensure NPS.
• Participate in production incident bridge calls and propose solutions.
• Ensure Jira hygiene and adherence to best practices.
• Conduct sprint retrospectives and act on outcomes.
• Participate in scrum of scrums and cross-squad meetings.

Skills

Oracle PLSQL

SQL

XML

JSON

PL/SQL functions

Triggers

Stored procedures

Performance tuning

Education

Bachelor's degree

Job description

Role description

Role: Oracle PLSQL developer with XML and JSON

Experience: 5-10 years

Location: Bangalore

Notice period: 0-15 days

Primary Skills: Oracle PLSQL, functions, triggers, advanced features of PLSQL, XML, JSON, stored procedures.

Detailed Job Description

• Bachelor’s Degree with 4-5 years of relevant experience as Oracle PLSQL developer
• Primary Skills: DataBase Developer with strong SQL programming, SQL queries, PL/SQL functions, scripting
• Hands‑on experience analyzing, designing and coding medium to large requirements using Oracle SQL, PL/SQL, XML DB, JSON, performance tuning, etc.
• Writing effective and tuned SQL queries, PL/SQL functions, stored procedures, triggers, cursors, materialized views
• Troubleshooting production issues in lower environment with strong debugging skills
• Knowledge of database performance improvement techniques to make decisions or suggest designs based on requirements and challenges
• Participate in production issue triage bridge calls and provide solutions
• Understanding of Agile methodologies and maintain Jira hygiene
• Thorough unit tests and automation using Ruby Cucumber
• Database environment setup – generating scripts for creating and amending tables and other objects in data dictionary
• Interacting with business users / counterparts to assist them with problem investigation
• Interacting with front‑end developers as part of the development process
• Collaborating with production L2 support and ensuring defect backlogs are within threshold
• Assigned tasks executed independently
• Daily status exchange internally with team and email communications to counterparts / bank
• Conducting/participating in scrum calls and retrospection meetings
• Performing code reviews for the team
• Participating in innovative initiatives

Roles & Responsibilities

• Closely working with the team, ensuring concerns/issues are resolved and motivating effective deliverables
• Forecast project resourcing requirements and ensure effective end‑to‑end hiring and onboarding/offboarding
• Conduct feedback review sessions, recognitions, and appraisals for the team
• Timely highlight team pulse to leadership and take required actions
• Lead and manage a team of developers, business analysts, and QA
• Lead multiple delivery streams to deliver successful product outcomes
• Plan and schedule delivery process, including scope, milestones, and timelines
• Identify and manage delivery risks and develop contingency plans to mitigate issues
• Communicate with stakeholders to ensure everyone is informed about progress
• Track progress and adjust as needed to keep delivery on track
• Provide guidance and mentorship to team members to ensure they have necessary skills and support
• Provide technical leadership and guidance to the team while working with clients or stakeholders to meet expectations
• Work with L2 Support and Client Service Management team to ensure NPS
• Participate in production incident bridge calls and provide suggestions/solutions
• Ensure Jira hygiene and best practice adherence
• Conduct sprint retrospectives and act on outcomes
• Participate in scrum of scrums and cross‑squad meetings to discuss dependencies across systems

Skills

• Databases
• PL/SQL
• SQL
• Oracle