Oracle Developer

Oracle Developer

Responsibilities:
• Design develop, test and maintain robust PL/SQL code, including stored procedures, functions, packages, triggers, and views to support various applications
• Be part of the database design and development process ensuring efficient database structure and performance
• Optimize all SQL queries and PL/SQL code for maximum performance, identifying and resolving performance issues
• Develop and implement data migration, transformation and loading processes using PL/SQL and other Oracle tools
• Provide support for existing database applications, troubleshooting and resolving issues within the set SLA.
• Work closely with application developers, business analysts and all the other stakeholders to understand business requirements and translate them into technical specifications.
• Maintain comprehensive documentation of database designs, PL/SQL code and all other technical artifacts.
• Follow and promote best practices in database development, including code reviews, version control and standard compliance.

Skills Required
• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3-5 years of experience as an Oracle Developer.
• Strong proficiency in writing complex PL/SQL code, including stored procedures, functions, packages, and triggers.
• Experience in designing database schemas, creating tables, views, indexes, and constraints.
• Experience with Oracle APEX for web-based application development.
• Proficiency in writing complex SQL queries and optimizing them for performance.
• Familiarity with Oracle tools such as SQL*Plus, SQL Developer, and TOAD.
• Knowledge of data modelling and database design principles.
• Experience with performance tuning and query optimization techniques.
• Understanding of relational database principles and practices.
• Familiarity with version control systems (e.g., Git).
• Experience of Oracle Forms, Reports is a plus.
• Experience in data migration, data transformation, and ETL processes using Oracle tools or custom PL/SQL scripts.
• Understanding of Oracle backup and recovery techniques, including RMAN (Recovery Manager).
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Ability to work independently and as part of a team.
• Attention to detail and commitment to quality.
• Ability to manage multiple tasks and meet deadlines.

Click here to Apply