Job Description

TCS is hiring for Oracle DBA (L1 / L2 activities)

Role: Oracle DBA (L1 / L2 activities)

Location:- Chennai/Pune

Experience: 3-10 Years(Relevant)

JD:

Must-Have:
• Should have sound knowledge Oracle RAC / Non-RAC Architecture (SGA/ PGA / Background processes / Physical Logical Structure of database) with parameters settings.
• Should have knowledge / hands-on experience with CDB / PDB such as create, clone & drop.
• Should have hands-on experience of database activities such as Start-up / Shutdown cluster & Standalone DB.
• Monitoring multiple users running sessions, locking / blocking sessions & kill sessions by coordination of application team.
• Should have hands-on experience of RAC / Non-RAC databases such as parameters change, spfile backups.
• Hands-on experience to create datafiles, add datafiles, remove datafiles, resizing datafiles in RAC / Non-RAC databases.
• Hands-on experience to create schema, change schema profiles, password management...