Chandan Jena
Bangalore
Summary
Experienced Oracle Database Administrator with 10+ years of experience supporting enterprise production environments. Expertise in Oracle RAC, Data Guard, GoldenGate, RMAN, upgrades, migrations, performance tuning and disaster recovery across Linux, UNIX, AIX, and HP-UX platforms.
Overview
11
11
years of professional experience
Work History
DATABASE ADMINISTRATOR
OpenText
Bangalore
03.2023 - Current
- 10+ years of experience in Oracle Database Administration across enterprise production environments.
- Supported 2,500+ databases in 24x7 mission-critical environments under ITIL-based support frameworks, ensuring high availability and reliability.
- Expertise in Oracle RAC installation, configuration, administration, and troubleshooting.
- Experienced in Oracle Clusterware 19c installation and configuration on RHEL 7.9 Linux.
- Hands-on experience implementing and administering Oracle Goldengate 21.3 environments.
- Managed node additions and removals in Oracle RAC cluster environments.
- Successfully upgraded Oracle RAC Clusters from 12c to 19c and 11g to 19.22.
- Performed Grid Infrastructure upgrades from 19.13 to 19.22 and 12c to 19.22.
- Created and maintained Oracle 19c Grid Infrastructure and Database Gold Images.
- Configured GoldenGate replication for schemas and tables in RAC environments.
- Upgraded Oracle databases from 11g and 12c to 19c using Oracle AutoUpgrade.
- Performed switchover and switchback activities for critical RAC databases.
- Designed and implemented Oracle Data Guard Physical Standby and Cascade Standby solutions oracle RAC.
- Executed rolling patching activities on RAC databases and Grid Infrastructure, achieving minimal downtime and maintaining operational continuity.
- Conducted database performance tuning using AWR, ASH, and ADDM reports to optimize query performance and resource utilization.
- Extensive experience in Oracle RMAN Backup & Recovery and Disaster Recovery planning.
- Strong expertise in remote installation, patching, migration, and upgrades across Linux, UNIX, AIX and HP-UX platforms.
DATABASE ADMINISTRATOR
DXC Technologies
Bangalore
04.2016 - 11.2022
- Client: SBM (State Bank of Mauritius), KOUNI (UK BASE Tourism Company), MSIL (Maruti Suzuki Limited)
- Environment: Oracle 9i/10g/11g on Linux, Solaris, AIX, Windows & HP-UX.
- Performed database administration tasks, including addressing Sev 1/2/3/4 incident tickets, to maintain optimal database performance.
- Worked on Data Guard and set up physical standby database and validating log gaps.
- Worked on role switch over/failover in primary and standby environment.
- Worked on Data guard Upgrade 11.2.0.3 to 11.2.0.4 PRIMARY & STANDBY.
- Applied rolling patch on rac database to minimize the database downtime.
- Identified fragmentation within database objects and reorganized them to reclaim space and enhance overall database performance.
- Add Disks from ASM disk group on live production and standby database.
- Change the protection mode on database and set up Snapshot Standby database for testing purposes.
- Recommend & Setup the new standby database in 11gr2 database with required protection modes based on database criticality as per customer request.
- Converted physical standby database to snapshot standby for testing and reverted it back after successful application testing.
- Cloning and refreshing the production database with development and test environments using Data Pump, Cold/hot backup.
- Generated AWR, ASH, and ADDM reports for the SME and application team.
- Periodically applying Patches /Patch Set/ PSU on production/test/development environments.
DATABASE ADMINISTRATOR
IBM India Pvt. Ltd
Bangalore
06.2015 - 01.2016
- Cloned, refreshed, and synced production database with development and test environments using EXP/IMP, Datapump, cold/hot cloning, and RMAN duplicate database with TAPE backup to ensure consistency across environments.
- Supported a team of 15 DBAs dedicated to managing over 700 databases in 247 availability environments with more than 200 business-critical applications.
- Resolved Severity S1 to S4 tickets, consistently meeting SLA requirements to maintain operational efficiency.
- Implemented scheduled changes for business-critical production databases.
- Upgrade critical database from 9i, 10g to 11gR2 and 12c also apply latest PSU patch.
- Periodically applying Patches /Patch Set/ PSU on production/test/development environments.
- Monitored production databases and executed health check scripts to proactively identify and address potential issues.
- Monitoring the OS performance, reference to the oracle databases running on the host using OS utilities / commands like top, free, vmstat.
- Working for IBM, in GTS (Global Technology Service) division of Data Management competency and its one of the major clients is the Canada's Oil Sands and Energy Company called Suncor. Suncor is one of the largest petroleum resource basins in the world.
Education
MSC IN - CS
Bangalore University
Bangalore01-2013
BCA -
Odisha FM University
Odisha01-2010
+2SC -
Odisha CHSE
Odisha01-2006
MATRICULATION -
Odisha BSE
Odisha01-2002
Skills
- Oracle DBA
- Oracle RAC
- Oracle 19c
- Oracle 12c
- Oracle 11g
- Data Guard
- GoldenGate
- RMAN
- SQL
- PL/SQL
- Performance Tuning
- Disaster Recovery
- Linux Administration
- AIX
- Shell Scripting
- ITIL
- Database Migration
Personal Information
Marital Status: Married
Timeline
DATABASE ADMINISTRATOR
OpenText
03.2023 - Current
DATABASE ADMINISTRATOR
DXC Technologies
04.2016 - 11.2022
DATABASE ADMINISTRATOR
IBM India Pvt. Ltd
06.2015 - 01.2016
MSC IN - CS
Bangalore University
BCA -
Odisha FM University
+2SC -
Odisha CHSE
MATRICULATION -
Odisha BSE