TCS IS HIRING FOR Database - MS SQL DBA

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

Job summary

Tata Consultancy Services is seeking an experienced Oracle DBA to manage large databases across 11g/12c/19c on UNIX/Linux and Windows. The role emphasizes RAC, Data Guard, patching, migrations, and recovery operations, with strong scripting and performance tuning requirements.

We value expertise in RMAN, Data Pump, GoldenGate and cross-platform administration to ensure high availability and optimal performance of critical data assets.

Qualifications

• Experience with Oracle DBA responsibilities across 11g/12c/19c in UNIX/Linux and Windows environments.
• Strong expertise in RAC, Data Guard architecture, monitoring, troubleshooting for large DB setups.

Responsibilities

• Manage core DBA activities including patching, migration and upgrades.
• Handle redo/undo logs, archive logs, RMAN backups and recovery.
• Utilize Data Guard, GoldenGate and Data Pump for replication and migrations.
• Tune performance using AWR, Explain Plan, TKPROF and RMAN scripts.

Skills

Oracle DBA

SQL & PL/SQL

RAC & Data Guard

Performance Tuning

Backup & Recovery

Large Database Administration

Shell Scripting

AWR & TKPROF

Tools

GoldenGate

RMAN

Data Pump

SQL Loader

Job description

• Oracle DBA with 11g, 12c &19c experience on UNIX (Solaris/Aix /RHEL/Linux) and Windows Operating system. Working experience on Oracle/AWS Cloud is desirable
• Experience in core DBA & RAC, Data Guard implementation, monitoring activities & troubleshooting (RAC,ASM & DG), Strong experience in monitoring and managing large database setups
• Experience in core DBA & RAC, Data Guard implementation, monitoring activities & troubleshooting (RAC & DG), Strong experience in monitoring and managing large database setups
• Good in Oracle RDBMS 11g/12c/19c architecture concepts
• Usage of data dictionary views and Good Knowledge on Golden Gate
• Partitioning of tables
• Experience in database patching.
• Experience in migrating & upgrading databases
• Managing Redo log and Archive log files
• Backup and recovery methods
• Logical backup and recovery using data pump, export/import
• Working experience in RMAN, SQL loader & Data Pump
• Oracle network configuration (listener and tnsnames)
• Strong experience SQL and PL/SQL knowledge
• Shell scripting shell, Born & c shell.
• Should be good in Performance tuning using AWR, Explain Plan and TKprof.
• Should have experience in RAC configuration & administration
• Data Guard (physical standby) administration & implementation