- The Developer (Oracle PL/SQL) will be responsible for developing, testing, implementing, and maintaining Oracle PL/SQL scripts, packages, procedures, and functions.
Key Responsibilities :
- 1. Develop and optimize complex sql queries, stored procedures, triggers, and functions in oracle pl/sql.
- 1. Troubleshoot and resolve database performance issues and ensure data integrity.
- 1. Collaborate with software developers, business analysts, and system architects to ensure database solutions meet business needs.
- 1. Perform unit testing and assist in system integration and user acceptance testing.
- 1. Document database development, and deployment processes.
Skill Requirements :
- 1. Understanding of oracle pl/sql programming, including writing efficient queries,
stored procedures, triggers, and functions.
- 1. Knowledge of database concepts and ability to design normalized and effective database schemas.
- 1. Familiarity with performance tuning, query optimization, and debugging database related issues.
- 1. Knowledge of database administration tasks such as backup/recovery, security management, and database monitoring.
- 1. Familiarity with version control systems and database deployment tools.
- 1. Good problem-solving and analytical skills with a keen attention to detail.
Other Requirements :
- 1.Oracle Certified Professional (OCP) Oracle PL/SQL Developer certification is preferred.