PLSQL Developer

We are seeking an experienced PLSQL Developer to join our dynamic team in Hyderabad, Telangana. As a PLSQL Developer, you will be instrumental in designing, developing, and maintaining high-performance database solutions that drive our core business operations. This role demands a strong understanding of Oracle SQL and PL/SQL, with a focus on creating robust and efficient stored procedures, functions, and packages.

Key Responsibilities

• Develop, test, and implement complex Oracle SQL and PL/SQL procedures, functions, triggers, cursors, and packages.
• Utilize advanced PL/SQL features such as BULK COLLECT, FORALL, and Ref cursors to optimize data processing.
• Write dynamic SQL queries and handle exceptions effectively within PL/SQL blocks to ensure application stability.
• Collaborate with business analysts and other developers to translate business requirements into technical specifications.
• Perform data loading tasks using SQL Loader to integrate external data into Oracle databases.
• Optimize database queries and PL/SQL code for performance using tools like Query Optimizer and Execution Plans.
• Create and manage database objects including Tables, Views, Constraints, and various Index types (B-Tree, Bitmap, Function Based).
• Implement materialized views for data replication in distributed environments to support business continuity.

Requirements

• Minimum of 10-12 years of hands-on experience in Oracle SQL and PL/SQL Development.
• Proficiency in developing and optimizing Procedures, Functions, Triggers, Cursors, and Packages.
• Demonstrated experience with advanced PL/SQL features like BULK COLLECT, FORALL, and Ref cursors.
• Solid understanding of SQL query optimization, execution plans, and indexing strategies.
• Familiarity with database tools such as SQL*Plus and SQL Developer.
• Experience with version control systems like SVN or Git.
• Ability to write dynamic SQL and handle exceptions in PL/SQL effectively.
• Knowledge of Oracle database administration tasks like configuration management, backup/recovery, and performance tuning is a plus.

What We Offer

• Competitive annual compensation package ranging from ₹10,00,000 to ₹14,00,000.
• Opportunity to work on challenging and impactful projects within the insurance broking services domain.
• A supportive and collaborative work environment focused on professional growth.
• Exposure to cutting-edge Oracle database technologies and best practices.
• Additional company benefits as per company policy.