Oracle Performance DBA Job Description:

1. Analyze and tune SQL queries, PL/SQL code, and database structures to improve performance.

2. Monitor and optimize database performance using tools like AWR, ADDM, SQL Trace, and TKPROF.

3. Identify and resolve performance bottlenecks, including CPU, memory, disk I/O, and network issues.

4. Implement indexing strategies, partitioning, and materialized views to optimize query performance.

5. Work with developers to review and optimize application SQL and PL/SQL code.

6. Configure and optimize Oracle Database parameters (SGA, PGA, caching, and memory management).

7. Provide recommendations for database schema design to enhance performance.

8. Automate performance monitoring and alerting using Oracle tools and scripts.

9. Collaborate with DBAs, developers, and system administrators to improve overall system efficiency.

10. Document performance tuning best practices and create training materials for development teams.

11. Valuable communication and troubleshooting skill to drive the major incidents calls from technical troubleshooting perspective.

📌 Oracle DBA_TCS (Pune)
🏢 TalentOla
📍 Pune