Tagcor

Required Skills

SQL Tuning Wait Events Histogram Join Methods Nested Loop Hash Join TKPROF SQL Trace Explain Plan AWR and ADDM reports gathering statistics pinning the objects running scripts troubleshooting bug fixing

Work Authorization

US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit

Preferred Employment

Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire

Employment Type

Consulting/Contract

education qualification

UG :- - Not Required
PG :- - Not Required

Other Information

No of position :- ( 1 )
Post :- 10th Sep 2024

JOB DETAIL

? Minimum 8+ 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
? 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

Oracle DBA