31 Jul
|
Broadridge Financial Solutions
|
Bengaluru
31 Jul
Broadridge Financial Solutions
Bengaluru
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 Positive 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
📌 Oracle Sql / Pl/sql Developer Senior Member Technical Bangalore (Bengaluru)
🏢 Broadridge Financial Solutions
📍 Bengaluru