| Database Administrator || San Jose, CA -- Onsite at San Jose, California, USA |
| Email: [email protected] |
| Hi, This is Anoop from Siri Info Solutions, if you are looking for a job change or available in the job market. Please send me your updated resume at [email protected] or call me at 848-300-5502. Job Title: Database Administrator Location: San Jose, CA (5 Days Onsite) Duration: Contract-2-Hire Job 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. Competencies: Digital : EAS : Oracle Cloud Infrastructure Experience (Years): 6-8 Essential Skills: 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 Troubleshooting Long running transactions and ERP concurrent requests Anoop Chaubey Desk Number: 848-300-5502 EXT-3189 Email: [email protected] Siri InfoSolutions Inc, 3 Ethel Rd, Suite # 302, Edison NJ 08817 -- Keywords: database information technology green card California New Jersey Database Administrator || San Jose, CA -- Onsite [email protected] |
| [email protected] View all |
| Fri Sep 27 21:57:00 UTC 2024 |