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.
- 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)
- Strong expertise in Oracle PL/SQL
- Experience in writing efficient and optimized SQL queries
- Knowledge of performance tuning techniques
- Working knowledge of MS SQL and MySQL
- BE / MCA (Computer Science, IT, or related field)
- Oracle Database PL/SQL Developer Certified Associate (OCA)
Required
- Strong communication skills with fluency in English
- Good logical thinking and problem-solving ability
- Adaptability and willingness to learn
Desirable:
- Good documentation skills
- Exposure to or knowledge of the Mutual Fund domain is preferred