Oracle DBA Architect

• Expertise in Oracle Database administration and performance tuning.
• Manage large-scale database environments while collaborating with diverse teams.
• In-depth understanding of database architecture with a strong focus on performance.
• Hands-on experience with production performance support.
• Utilize advanced database optimization and fine-tuning techniques.
• Diagnose and resolve performance and technical issues efficiently.

Key Technical Skills:

• Perform detailed database performance analysis using tools like Oracle Enterprise Manager (OEM), AWR, ASH, OS monitoring tools, and Oracle wait events.
• Advanced knowledge of SQL queries, SQL Trace/Explain plans, and SQL performance tuning.
• Configure and manage Oracle parameters and options effectively.
• Solid understanding of system components such as CPU, RAM, IO, and SAN.
• Troubleshoot and analyze SQL and PL/SQL packages, procedures, triggers, and application code.

Backup and Recovery:

• Design and implement enterprise backup strategies using RMAN, ExpDP, and related tools.

High Availability and Disaster Recovery:

• Hands-on experience with Oracle DataGuard for high availability and disaster recovery solutions.

Upgrades and Patching:

• Troubleshoot and resolve issues related to Oracle database upgrades and patching processes.

Soft Skills:

• Strong written and oral communication skills to effectively convey ideas during meetings, emails, and informal discussions.