Rahul Vishwakarma profile photo 1 on Tal

Rahul Vishwakarma

IT Analyst at Tata Consultancy Services

Mumbai

7+ years of work experience

Tata Consultancy Services
Nov 20241 yr 7 mosPresent

Administer Oracle Database 19c environments across production and non-production instances — covering schema management, stored procedures, data security, user access, and capacity planning for multiple enterprise clients. Installed and configured Oracle APEX on client environments, coordinating with application teams for end-to-end deployment and validation. Developed Shell scripts to automate OEM blackout creation and removal during OS and database patching windows, eliminating false alerting and ensuring clean patching audit trails. Apply Oracle PSU and JDK patches across database instances; extract and analyse Exadata reports to execute Exadata patching in compliance with change control procedures. Add and remove storage from Exadata disk groups; add LUNs to ASM disk groups to support capacity growth across managed environments. Design and maintain high availability and disaster recovery solutions using Oracle Data Guard and Oracle RAC, meeting defined Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). Perform periodic DR drills for all major production databases using switchover/switchback and Flashback techniques to validate recovery readiness. Manage backup and recovery operations using RMAN — full, incremental, and differential backups — with restoration validated through periodic recovery testing. Monitor Oracle alert logs and database health proactively using OEM and automated alerting to identify and resolve issues before they impact production. Analyse AWR reports to identify performance bottlenecks; perform index rebuilding and statistics gathering to maintain optimal query performance under production workloads. Prepare detailed plans of action with timelines for all production database activities; follow ITIL-aligned change control procedures for every production change. Administer Oracle RAC clusters using SRVCTL and CRSCTL commands for cluster resource and service management.
Tata Consultancy Services
Jul 20241 yr 11 mosPresent

Mumbai, Maharashtra, India

Clover Infotech
Aug 20195 yrsJul 2024

Installed and configured Oracle Database Software 11g, 12c, 18c, and 19c along with Oracle Client on Linux and Windows platforms for multiple client environments. Managed Oracle instances and physical database structures — data files, redo log files, and control files (with mirroring) — ensuring structural integrity across managed databases. Performed database upgrades from Oracle 11.2.0.1/11.2.0.3 to 11.2.0.4, 12c, and 19c, following structured upgrade runbooks with pre- and post-upgrade validation. Executed database cloning using cold backup, hot backup, Data Pump, and RMAN methodologies on Linux and Windows to support development, UAT, and production refresh requirements. Installed, configured, and monitored Oracle Data Guard on primary and standby databases; monitored alert log files and log sequences across both environments. Performed periodic DR drills for all major production databases, validating recovery using switchover/switchback and Flashback techniques. Implemented and managed backup policies — daily hot backups and weekly cold backups — for all production databases; restored databases using full and incremental RMAN backups. Managed ASM disk groups, added disks, and handled Exadata storage provisioning and removal to meet capacity requirements. Monitored database performance using AWR, ADDM, and ASH reports; performed index rebuilding and statistics gathering to resolve identified bottlenecks. Performed schema refreshes and created schema objects including Tables, Views, Indexes, and Synonyms as required by application teams. Assigned roles, permissions, and privileges to users; enforced database security policies and managed user access across managed environments. Troubleshot database issues including listener hang, block corruption, and undo management; worked with Oracle Support to analyse and resolve defects and service requests.
Clover Infotech
Aug 20195 yrsJul 2024

Mumbai

Clover Infotech
Aug 20194 yrs 9 mosApr 2024

Mumbai

Education

Bachelor's degree in Computer Engineering, Computer Engineering

Greater Mumbai Education Society High School

20163 yrs2019
Pillai hoc college of engineering and technology

Bachelor of Engineering, Computational Science

Pillai hoc college of engineering and technology

20163 yrs2019

Join Rahul and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Rahul Vishwakarma on Tal

Headline

IT Analyst at Tata Consultancy Services

About

• Installing ORACLE DATABASE SOFTWARE 10g, 11g, 12c, 18c, 19c along with Oracle client 10g, 11g, 12c, 18c, 19c . • Monitoring Alert log file and log sequence on both primary and Standby database, Daily monitoring, Daily Hot backup, weekly cold back of Database, Installation and Configuration of Data-guard. • Purging Log files of Oracle database • Cloning from Hot backup of database, Refreshing of Database • Up-gradation database from Oracle 11.2.0.1 and 11.2.0.3 to 11.2.0.4 and 11.2.0.4 to 12c and 19c . • Assigning Roles to the Users, and required privileges. • Performing Schema Refresh activity. • Monitoring & Management of ASM disk groups, adding disks to disk groups • Implementing Backup policy for all major production databases • Working with Oracle Support, Analysis and management of Oracle problems/defects • Performing Database maintenance activity like index rebuilding and Stats gather activity • Monitoring Database performance using AWR, ADDM & ASH report • Creating Schema objects like Tables, Views, Indexes, Synonyms etc. • Management of oracle Instance, physical structure of the database like data files, redo log files, control files (mirroring of the control file) • Export and Import Utilities & Logical backups using full export • Interact with customers to understand their technical queries and provide assistance in resolving them • Configure DR & Monitoring DR, Maintaining DR and periodically DR drill • Troubleshooting Database issues like listener Hang, Block corruption, undo management, etc. • Performing DR-drill activity for all major production databases using switchover switchback technique and Flashback technique. • Oracle Patch installation on Databases

Location

Mumbai

Work experience

Oracle Database Administrator at Tata Consultancy Services, Nov 2024 - Present · 1 yr 7 mos, Administer Oracle Database 19c environments across production and non-production instances — covering schema management, stored procedures, data security, user access, and capacity planning for multiple enterprise clients. Installed and configured Oracle APEX on client environments, coordinating with application teams for end-to-end deployment and validation. Developed Shell scripts to automate OEM blackout creation and removal during OS and database patching windows, eliminating false alerting and ensuring clean patching audit trails. Apply Oracle PSU and JDK patches across database instances; extract and analyse Exadata reports to execute Exadata patching in compliance with change control procedures. Add and remove storage from Exadata disk groups; add LUNs to ASM disk groups to support capacity growth across managed environments. Design and maintain high availability and disaster recovery solutions using Oracle Data Guard and Oracle RAC, meeting defined Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). Perform periodic DR drills for all major production databases using switchover/switchback and Flashback techniques to validate recovery readiness. Manage backup and recovery operations using RMAN — full, incremental, and differential backups — with restoration validated through periodic recovery testing. Monitor Oracle alert logs and database health proactively using OEM and automated alerting to identify and resolve issues before they impact production. Analyse AWR reports to identify performance bottlenecks; perform index rebuilding and statistics gathering to maintain optimal query performance under production workloads. Prepare detailed plans of action with timelines for all production database activities; follow ITIL-aligned change control procedures for every production change. Administer Oracle RAC clusters using SRVCTL and CRSCTL commands for cluster resource and service management.

IT Analyst at Tata Consultancy Services, Jul 2024 - Present · 1 yr 11 mos, Mumbai, Maharashtra, India

Oracle Database Administrator at Clover Infotech, Aug 2019 - Jul 2024 · 5 yrs, Installed and configured Oracle Database Software 11g, 12c, 18c, and 19c along with Oracle Client on Linux and Windows platforms for multiple client environments. Managed Oracle instances and physical database structures — data files, redo log files, and control files (with mirroring) — ensuring structural integrity across managed databases. Performed database upgrades from Oracle 11.2.0.1/11.2.0.3 to 11.2.0.4, 12c, and 19c, following structured upgrade runbooks with pre- and post-upgrade validation. Executed database cloning using cold backup, hot backup, Data Pump, and RMAN methodologies on Linux and Windows to support development, UAT, and production refresh requirements. Installed, configured, and monitored Oracle Data Guard on primary and standby databases; monitored alert log files and log sequences across both environments. Performed periodic DR drills for all major production databases, validating recovery using switchover/switchback and Flashback techniques. Implemented and managed backup policies — daily hot backups and weekly cold backups — for all production databases; restored databases using full and incremental RMAN backups. Managed ASM disk groups, added disks, and handled Exadata storage provisioning and removal to meet capacity requirements. Monitored database performance using AWR, ADDM, and ASH reports; performed index rebuilding and statistics gathering to resolve identified bottlenecks. Performed schema refreshes and created schema objects including Tables, Views, Indexes, and Synonyms as required by application teams. Assigned roles, permissions, and privileges to users; enforced database security policies and managed user access across managed environments. Troubleshot database issues including listener hang, block corruption, and undo management; worked with Oracle Support to analyse and resolve defects and service requests.

Technical Associate at Clover Infotech, Aug 2019 - Jul 2024 · 5 yrs, Mumbai

Technical Associate at Clover Infotech, Aug 2019 - Apr 2024 · 4 yrs 9 mos, Mumbai

Education

Bachelor's degree in Computer Engineering, Computer Engineering, Greater Mumbai Education Society High School

Bachelor of Engineering, Computational Science, Pillai hoc college of engineering and technology