Senior Oracle SQL and PL/SQL Developer

Oracle SQL / PL/SQL Developer _Senior Member Technical_ Bangalore

At Broadridge, we've built a culture where the highest goal is to empower others to accomplish more. If you’re passionate about developing your career, while helping others along the way, come join the Broadridge team.

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

Education: 

Bachelor’s / Master’s degree in Computer Science, Information Technology, or related field.

-Applies a theoretical knowledge-base to work to achieves goals through own work
-Characterized by specific functional expertise typically gained through formal education
-May provide guidance to others as a project manager using technical expertise

Key Responsibilities: 

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

We are dedicated to fostering a collaborative, engaging, and inclusive environment and are committed to providing a workplace that empowers associates to be authentic and bring their best to work. We believe that associates do their best when they feel safe, understood, and valued, and we work diligently and collaboratively to ensure Broadridge is a company—and ultimately a community—that recognizes and celebrates everyone’s unique perspective. 

Use of AI in Hiring 

As part of the recruiting process, Broadridge may use technology, including artificial intelligence (AI)-based tools, to help review and evaluate applications. These tools are used only to support our recruiters and hiring managers, and all employment decisions include human review to ensure fairness, accuracy, and compliance with applicable laws. Please note that honesty and transparency are critical to our hiring process. Any attempt to falsify, misrepresent, or disguise information in an application, resume, assessment, or interview will result in disqualification from consideration.

Experience Level

Senior Level