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