05 Aug
|
Aabasoft
|
India
- 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.
What we Expect from you?
- 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).
- Solid 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.
What you've got?
- Experience with Oracle APEX for web-based 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 (India)
🏢 Aabasoft
📍 India