About the Role:

We are seeking a skilled Oracle Developer with 2-3 years of experience in Oracle PL/SQL development. The ideal candidate will be responsible for designing, developing, and optimizing database solutions, ensuring high performance and responsiveness to business requirements, preferably within the mutual fund domain.

Key Responsibilities:

• Develop and maintain PL/SQL code, including:
  • Stored Procedures
  • Functions
  • Triggers
• Handle exception management and ensure robust error handling mechanisms
• Work with cursors and collections for efficient data processing
• Perform query optimization using tools such as EXPLAIN PLAN and indexing techniques
• Analyze and interpret execution plans to improve database performance
• Collaborate with cross-functional teams to understand requirements and deliver solutions
• Maintain proper documentation of development activities (desirable)

Required Technical Skills:

• Strong expertise in Oracle PL/SQL
• Experience in writing efficient and optimized SQL queries
• Knowledge of performance tuning techniques

Desirable Technical Skills:

• Working knowledge of MS SQL and MySQL

Educational Qualification

• BE / MCA (Computer Science, IT, or related field)

Certifications (Preferred):

• Oracle Database PL/SQL Developer Certified Associate (OCA)

Soft Skills & Competencies:

Required

• Strong communication skills with fluency in English
• Good logical thinking and problem-solving ability
• Adaptability and willingness to learn

Desirable:

• Good documentation skills

Domain Knowledge:

• Exposure to or knowledge of the Mutual Fund domain is preferred