Role: Oracle DBA
Location: San Jose, CA
Client: TCS
| Role name: | Database Administrator |
|---|---|
| Role 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 |
| Desirable 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 |
| Country: | United States |
| Branch | City | Location: | TCS – Sunnyvale SAN JOSE San Jose, CA |
| Keywords: | ? 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. |
Mohd Adil | Talent Acquisition
2838 E. LONG LAKE ROAD SUITE 210, TROY, MI 48085
M: 469-552-7783 | Mail: [email protected]
Connect me on – Linkedin
Disclaimer
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.