PL/SQL and Oracle Database Tuning Expert

A PL/SQL and Oracle Database Tuning Expert is responsible for developing, implementing, and maintaining PL/SQL code and optimizing Oracle database performance. This role involves working closely with application developers, database administrators, and other stakeholders to ensure data integrity, optimize performance, and implement new features.

Job Description

• Responsibilities:Develop and Maintain PL/SQL Code: Create and optimize PL/SQL packages, procedures, functions, and triggers.
• Database Performance Tuning: Perform regular database performance tuning and optimization, including query optimization, indexing strategies, and resource management.
• Collaborate with Teams: Work closely with application developers, database administrators, and other stakeholders to ensure data integrity and optimize performance.
• Data Modeling and Design: Design and implement data models and database structures.
• Backup and Recovery: Implement and manage backup and recovery processes to ensure data protection.
• Code Reviews and Best Practices: Participate in code reviews and contribute to best practices.
• Documentation: Document technical specifications and processes.
• Support: Provide support for database-related issues and daily business operations.