06 Sep
|
TalentOla
|
Pune
Oracle Performance DBA :
- Analyze and tune SQL queries, PL/SQL code, and database structures to improve performance.
- Monitor and optimize database performance using tools like AWR, ADDM, SQL Trace, and TKPROF.
- Identify and resolve performance bottlenecks, including CPU, memory, disk I/O, and network issues.
- Implement indexing strategies, partitioning, and materialized views to optimize query performance.
- Work with developers to review and optimize application SQL and PL/SQL code.
- Configure and optimize Oracle Database parameters (SGA, PGA, caching, and memory management).
- Provide recommendations for database schema design to enhance performance.
- Automate performance monitoring and alerting using Oracle tools and scripts.
- Collaborate with DBAs, developers, and system administrators to improve overall system efficiency.
- Document performance tuning best practices and create training materials for development teams.
- Valuable communication and troubleshooting skill to drive the major incidents calls from technical troubleshooting perspective.
📌 Oracle DBA_TCS (Pune)
🏢 TalentOla
📍 Pune