Job Summary:
- 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.
- 3. Troubleshoot and resolve database performance issues and ensure data integrity.
- 4. Collaborate with software developers, business analysts, and system architects to ensure database solutions meet business needs.
- 5. Perform unit testing and assist in system integration and user acceptance testing.
- 6. Document database development, and deployment processes.
Skill Requirements:
- 1. Understanding of oracle pl/sql programming, including writing efficient queries, stored procedures,
triggers, and functions.
- 2. Knowledge of database concepts and ability to design normalized and effective database schemas.
- 3. Familiarity with performance tuning, query optimization, and debugging database related issues.
- 4. Knowledge of database administration tasks such as backup/recovery, security management, and database monitoring.
- 5. Familiarity with version control systems and database deployment tools.
- 6. 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.