Job Description
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.
8-12 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.
Design develops, 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.
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.
Proficiency in writing complex SQL queries and optimizing them for performance.
Familiarity with Oracle tools such as SQL Developer, ODI.
Knowledge of data modelling and database design principles.
Experience with performance tuning and query optimization techniques.
Understanding of relational database principles and practices.
Familiarity and understanding in banking domain and reconciliation are a plus.
