ORACLE DEVELOPER

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.
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 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.

Aabasoft Career