Oracle Exadata

Tata Consultancy Services; Chennai District; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Tata Consultancy Services in Chennai seeks an experienced Oracle DBA for 24x7 database administration. You will handle installation, patching, upgrade planning, and performance tuning across Oracle RAC and standalone databases, with a focus on automation via shell scripting.

Responsibilities include Data Guard, OEM monitoring, and DB migrations, working in a multi-OS environment (AIX, Linux, Windows) with strong problem solving and communication skills.

Qualifications

• L3 DBA with expertise in administering databases 24x7 and strong architecture understanding.
• Strong knowledge in Oracle RAC and standalone database maintenance/troubleshooting (12c/11g/19c).
• Experience with ASM, RMAN, OEM, and datapump technologies.
• Expertise in shell scripting and automation.
• Proficient in performance/SQL tuning and optimization.
• Experience with Data Guard configuration and DG broker.
• Experience with multitenant CDB/PDB databases and GoldenGate replication.

Responsibilities

• Role involves L3 DBA responsibilities with 24x7 database administration and architecture understanding.
• Maintain and troubleshoot Oracle RAC and standalone databases across 12c/19c.
• Manage ASM, RMAN backups, OEM monitoring, and Datapump workflows.
• Develop shell scripts to automate routine tasks and deployments.
• Tune performance and SQL queries to optimize system efficiency.
• Configure and manage Data Guard and DG Broker environments.
• Plan and execute DB upgrades and migrations (12c/19c, 19c).
• Administer databases on AIX, Linux and Windows OS environments.
• Demonstrate strong problem solving and communication skills.
• Support rotational shifts/on-call and mentor junior DBAs.
• Administer Oracle Enterprise Manager (OEM 12c/13c) monitoring.
• Perform quarterly patching for Oracle databases (12c/19c).
• Handle multi-master replication in heterogeneous DBs with GoldenGate.

Skills

System Administration

Performance Tuning

Infrastructure Monitoring

Shell scripting

Tools

Shell scripting

Job description

Must Have

System Administration

Install, configure, patch, and upgrade Oracle Grid Infrastructure and databases on Exadata (on-premise or OCI).

Performance Tuning

Monitor system performance (CPU, I/O) and optimize SQL queries by utilizing Smart Scan and Columnar Compression.

Infrastructure Monitoring

Monitor Exadata cell nodes, storage, and InfiniBand network switches.

Role & responsibilities

• L3 DBA with expertise in administering various databases(24*7) and strong understanding of architecture.
• Strong Knowledge in Oracle RAC & Standalone database maintenance/troubleshooting - (19c/12c/11g)
• Strong knowledge in features such as ASM,RMAN(Backup & Recovery),OEM, Datapump technologies
• Expertise in Shell scripting and automation.
• Good Experience in performace tuning/SQL tuning and Optimization.
• Experience in Dataguard configuration and DG broker
• Good exposure in planning/working on DB upgrades 12c/19c and Installation/Migration.
• Good experience in AIX, Linux and Windows OS environment based DB administration.
• Strong Problem solving and communication skills.
• Prefer flexible team player for rotational shifts/On-call support.
• Oracle enterprise manager administration, monitoring through OEM 12c and OEM 13c.
• Hands on experience in Oracle database quarterly patching (latest 12c/19c releases)
• Understanding & Experience in handling Multitenant architecture databases ( CDB/PDB )
• Experience with data replication using GoldenGate(OGG) in a multi-master (bi-directional) heterogeneous DBs.
• Should be able to mentor, manage and lead a team of L1/L2 DBAs.