Sr. Oracle PLSQL Database developer

As an Oracle SQL / PL/SQL Developer at Broadridge, you will be responsible for designing, developing, and optimizing database solutions, ensuring the performance tuning of mission-critical applications. 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 to improve application performance. - Implement bulk processing using BULK COLLECT, FORALL, and collections for handling high volumes of data. - Utilize cursors, ref cursors, and dynamic SQL for complex requirement handling. - Design and maintain database objects such as tables, views, indexes, constraints, and 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 version control and deployment tools like GIT, JIRA, Jenkins, AutoSys (or equivalent). - 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, including indexes, hints, explain plan, and statistics. - Hands-on experience with PL/SQL programming constructs like procedures, packages, functions, triggers, and cursors. - Experience in performance tuning, debugging, and production incident support. - Familiarity with SDLC & Agile practices. - Experience with large datasets in OLTP / OLAP environments. - Understanding of database design and normalization. - Strong problem-solving and analytical skills. - Exposure to XML and JSON handling in Oracle is a plus. - Good communication skills for interaction with cross-functional teams. Nice to Have Skills: - Knowledge of Oracle Advanced Features such as Materialized Views, Partitioning, and Parallel Query. - Hands-on experience with Oracle XML DB / JSON functions. - Exposure to AWS RDS / Cloud Databases. - Experience using unit testing frameworks like utPLSQL. Education: - Bachelors or Masters degree in Computer Science, Information Technology, or a related field. Broadridge is dedicated to fostering a collaborative, engaging, and inclusive environment where associates can be authentic and bring their best to work. The company values the unique perspective of each individual and strives to create a safe, understanding, and valued workplace for all.,