Developing and Maintaining PL/SQL Code: Creating, modifying, and debugging PL/SQL code for stored procedures, functions, triggers, packages, and other database objects.
Database Design and Optimization: Designing database schemas, optimizing SQL queries, and tuning PL/SQL code for performance.
Collaboration: Working with application developers, database administrators, and other stakeholders to deliver database solutions.
Code Reviews: Participating in code reviews to ensure code quality, maintainability, and adherence to coding standards.
Troubleshooting and Debugging: Identifying and resolving issues related to database code and performance.
Documentation: Documenting database designs, code, and procedures.
Testing: Developing and executing test plans to ensure the quality and accuracy of PL/SQL code.
Performance Monitoring and Tuning: Monitoring database performance and identifying areas for optimization.
Data Integrity and Security: Ensuring data integrity, security, and compliance with relevant policies.
Requirements Gathering and Analysis: Participating in requirements gathering and analysis to understand project needs.
Problem Solving: Analyzing and resolving complex database-related issues.

Skills and Experience:

Proficiency in PL/SQL: Strong understanding and experience with PL/SQL programming language.
SQL Expertise: Solid knowledge of SQL for querying and manipulating data.
Database Design: Understanding of database design principles and best practices.
Performance Tuning: Ability to optimize database performance through SQL and PL/SQL tuning.
Problem-Solving: Ability to analyze and resolve complex database issues.
Collaboration: Ability to work effectively with cross-functional teams.
Communication: Strong communication and interpersonal skills.
Version Control: Experience with version control systems like Git

Oracle PLSQL Professionals

Job Description