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.
