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