Job Title

Oracle Database Administrator Performance Analyst

Mandate Skills

Oracle DBA, Oracle DB Performance Analyst

Technical/Functional Skills -MUST HAVE SKILLS

• Minimum 5+ years' Experience in the Software Industry
• Understanding of Software design patterns, SDLC, Continuous Integration and Continuous Delivery
• A drive to get things done in a highly collaborative and agile development environment.
• Strong analytical and problem-solving skills
• Oracle database concepts and Architecture
• Overall system performance tuning
• SQL Tuning, Wait Events, Histogram, Join Methods (Nested Loop, Hash Join, Merge join cartesian)
• Index scan Methods (Range Index scan, Fast full index scan, Skip scan index methods)
• AWR report, TKPROF analysis and interpretation
• Troubleshooting Long running transactions and ERP concurrent requests

Roles & Responsibilities

• Oracle database concepts and Architecture
• Installation experience on various Oracle database versions
• Knowledge on code tree build and maintenance.
• Knowledge on Oracle RDBMS patching on single node and RAC environments
• Knowledge on Oracle Cluster Ready services (CRS), Data Guard, RMAN backup/recovery methods and maintenance of ASM
• Oracle RAC administration and performance analysis
• Overall system performance tuning
• SQL Tuning, Wait Events, Histogram, Join Methods (Nested Loop, Hash Join, Merge join cartesian)
• Index scan Methods (Range Index scan, Fast full index scan, Skip scan index methods)
• AWR report, TKPROF analysis and interpretation
• Troubleshooting Long running transactions and ERP concurrent requests