Sr. Oracle PLSQL Database developer - Senior Member Technical -

Broadridge

3 - 5 years

13 - 14 Lacs

bengaluru

Posted:-1 days ago| Platform:

Apply

Skills Required

sql development oracle performance tuning autosys unit testing oltp sql plsql git sql optimization pl / sql development xml optimization techniques olap jenkins debugging scrum json oracle sql agile agile principles sdlc jira communication skills

Work Mode

Work from Office

Job Type

Full Time

Job Description

Develop, enhance, and maintain Oracle SQL queries, PL/SQL procedures, functions, packages, and triggers.
Work on L3 Development with real-time problem-solving including debugging, performance tuning, and root cause analysis.
Optimize SQL queries for large datasets (millions of rows) to improve application performance.
Implement bulk processing using BULK COLLECT, FORALL, and collections to handle high volumes of data.
Work with cursors, ref cursors, dynamic SQL for complex requirement handling.
Design and maintain database objects (tables, views, indexes, constraints, partitions).
Collaborate with Dev, QA, and Business teams for requirement gathering, triaging, and defect resolution.
Implement error handling, exception handling, logging, and debugging strategies .
Support data migration, transformation, and integration workflows .
Work with tools like GIT, JIRA, Jenkins, AutoSys (or equivalent) for version control and deployment.
Exposure to Agile/Scrum methodologies .

Required Skills Experience:

3 6 years of experience in Oracle SQL and PL/SQL development .
Strong knowledge of SQL optimization techniques (indexes, hints, explain plan, statistics).
Hands-on with PL/SQL programming constructs (procedures, packages, functions, triggers, cursors).
Experience with performance tuning, debugging, and production incident support .
Strong knowledge of SDLC Agile practices.
Experience working with large datasets in OLTP / OLAP environments.
Good understanding of database design normalization .
Strong problem-solving and analytical skills.
Exposure to XML, JSON handling in Oracle will be an added advantage.
Good communication skills for interaction with cross-functional teams.

Nice to Have Skills:

Knowledge of Oracle Advanced Features (Materialized Views, Partitioning, Parallel Query).
Hands-on with Oracle XML DB / JSON functions .
Exposure to AWS RDS / Cloud Databases .
Experience using unit testing frameworks (utPLSQL).

More Jobs at Broadridge

Senior Member Technical

Mumbai

2 - 9 yrs

INR 13 - 14 Lacs

Sr. OTC derivatives _Technology Specialist

Bengaluru

7 - 10 yrs

INR 10 - 15 Lacs

Technology Specialist- ColdFusion Developer

Hyderabad, Bengaluru

2 - 3 yrs

INR 6 - 10 Lacs

Technology Lead

Bengaluru

6 - 13 yrs

INR 20 - 25 Lacs

Senior Process Analyst

Hyderabad

4 - 6 yrs

INR 5 - 6 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.