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.
Bachelors degree in Computer Science Information Technology or a related field.
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 problemsolving 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.
Experience with Oracle APEX for webbased 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.
Oracle Developer
