Company:
Diverse Lynx
Location: San Jose
Closing Date: 19/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
? Experience in performance tuning of database, instances, SGA, I/O, and rollback segment.? Experience in 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), oracle wait events ( DB file sequential read , db file scattered read , GC wait events), Top SQLs Analysis at database level ( CPU/Memory/load)? Expertise in Plan change Analysis of the SQLs while upgradation of databases.? SQL query optimization and instance tuning using TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports, gathering statistics, pinning the objects, running scripts, troubleshooting, bug fixing.? Able to work with oracle support to create SR and troubleshooting and fix the issues.
Digital : EAS : Oracle Cloud Infrastructure
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
? Experience in performance tuning of database, instances, SGA, I/O, and rollback segment.? Experience in 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), oracle wait events ( DB file sequential read , db file scattered read , GC wait events), Top SQLs Analysis at database level ( CPU/Memory/load)? Expertise in Plan change Analysis of the SQLs while upgradation of databases.? SQL query optimization and instance tuning using TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports, gathering statistics, pinning the objects, running scripts, troubleshooting, bug fixing.? Able to work with oracle support to create SR and troubleshooting and fix the issues.
Digital : EAS : Oracle Cloud Infrastructure
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Share this job
Useful Links