Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic
JAYASHREE SAHOO

JAYASHREE SAHOO

Bangalore

Summary

  • Having 9 years of experience as Oracle Database Administrator.
  • Proficient in Administering, Troubleshooting, Monitoring and Maintenance of Oracle Databases of different versions on various platforms.
  • Worked on various activities of Oracle DBA , RAC (Real Application Cluster) , standalone, Dataguard, Oracle Golden Gate , Recovery.
  • Core expertise in Oracle binary Installation, Creation of DB.
  • Hands on experience in Oracle Database Replications using Dataguard and Golden Gate.
  • Hands on experience database restoration, refresh activity rman,expdp and impdp.
  • Worked in Patching, Upgradation of database.
  • Core expertise on Performance Tuning via AWR/ASH/ADDM reports.
  • Worked on slowness issue by tuned SQL statement.
  • 1+ years of experience as Oracle Exadata Administrator (Basic Knowledge).
  • Having good and strong communication skills for direct client interaction and communicating ideas clearly and effectively.
  • Skilled at learning new concepts quickly, working well under pressure and experience on taking proactive actions to maintain healthy Database and best service to customer.

Overview

9
9
years of professional experience

Work History

Senior Oracle Database Administrator

Tata Consultancy Services (TCS), Iron Mountain
Bangalore
12.2020 - Current
  • Daily and weekly maintenance of all the databases to improve their performance by gatherstats (schema/table), index rebuilding, and purging of old and unwanted data.
  • Good knowledge of ASM technology, such as managing ASM disk groups, including the addition and deletion of disks.
  • Hands-on experience on data growth analysis, historic performance analysis.
  • Proficient experience in converting databases from Snapshot to Physical and vice versa, and well-versed in DR Drill Activities.
  • Installed and configured Oracle Database software, components, and tools.
  • Created and maintained database objects such as tables, indexes, views, triggers, stored procedures.
  • Worked on DR Drill (Switch over and switch back) activity.
  • Hands-on Experience, DR configuration.
  • Worked on Oracle Client Installation, Database creation, listener creation.
  • Managed Performance Tuning, proactive monitoring of Systems and Databases.
  • Created and tuned SQL statement, programs to ensure they process at an optimal level and by using a minimum resource.
  • Experience in applying CPU and PSU patches on production and development databases.
  • Installing and Monitoring OS Watcher, TFA for OS level resource for the Performance issues.
  • Managing export/import activities, database designing (create database objects like table, views, and indexes, etc.) for application deployment activities.
  • Worked on user management, such as profile, account status, and limit.
  • Hands-on in creation and managing of database links.
  • Monitoring Production DB archive logs and DR archive logs, applying sync status on a daily basis. Doing manual log transfer and recovery by taking incremental backup if there is a huge log difference.
  • Expertise in taking backups using RMAN, incremental backups, archive backups, and full database.
  • Analyzing Tables Statistics and Rebuilding Indexes
  • Coordinating with Oracle support, third-party vendors, and the development team for issue resolution.
  • Having work experience on 9i, 10G, 11G, and 12c, 19c databases with multiple operating systems.
  • Monitored database performance and tuned accordingly.
  • Upgraded the databases from older versions to newer ones while ensuring minimal downtime.
  • Tested new database features before introducing them into production environment.
  • Managed multiple databases across different environments like development, testing and production.
  • Ensured data integrity through regular validation checks on data quality and consistency.
  • Provided 24x7 on-call support for critical incidents related to databases.

Oracle Database Administrator

Wipro
Mysore
11.2015 - 12.2020
  • Managed over 40 client databases, ensuring high performance, availability, and reliability.
  • Conducted daily and weekly database maintenance to enhance performance, including gathering statistics, index rebuilding, and purging outdated data.
  • Managed ASM disk groups by adding and removing disks to optimize storage.
  • Analyzed data growth trends and historic performance for capacity planning and optimization.
  • Converted databases between Snapshot and Physical modes, participated in Disaster Recovery (DR) drill activities, including switchover and switchback.
  • Used Oracle GoldenGate for data replication, including adding tables and using Flashback SCN backup for synchronization.
  • Configured and maintained DR environments, ensuring high availability and data protection.
  • Installed Oracle Client, created databases, and configured listeners for new instances.
  • Applied CPU and PSU patches on both production and development environments to maintain database security and stability.
  • Installed and monitored OS Watcher and TFA to address OS-level performance issues.
  • Managed export/import operations and database design activities, including the creation of tables, views, and indexes for application deployments.
  • Handled user management tasks, including profile configuration, account status monitoring, and setting limits.
  • Created and managed database links to facilitate secure inter-database communication.
  • Monitored production and DR archive logs, ensuring synchronization by performing manual log transfers and recovery using incremental backups when required.
  • Expert in taking full, incremental, and archive backups using RMAN to ensure data integrity.
  • Analyzed table statistics and rebuilt indexes to enhance query performance.
  • Coordinated with Oracle support, third-party vendors, and the development team to resolve technical issues.
  • Worked on Oracle databases versions 9i, 10g, 11g, 12c, and 19c across multiple operating systems for over 40 clients.

Education

M. Tech - IT

Vellore Institute of Technology
01.2020

BSc -

Gangadhar Meher University
01.2015

Newton College of Science, Sambalpur
01.2012

BSE -

Budharaja High School, Samalpur
01.2010

Skills

  • Operating Systems: Windows (98, XP), MS-DOS, UNIX, Linux, AIX, Sun Solaris, HP-UX
  • Programming Languages: SQL, HTML, Oracle HTML, PostgreSQL
  • Database Technologies: Oracle (9i, 10g, 11g, 12c, 19c), RAC, ASM, Oracle GoldenGate (OGG), Exadata, Veridata, IBM Change Data Capture (CDC)
  • Oracle Tools & Utilities: Data Pump, EXP/IMP, RMAN, OEM, DBCA, NETCA, CRSCTL, SRVCTL, AWR, ASH, ADDM
  • Tools & Software: PuTTY, Secure IT, E Helpline, BIRT, Event Grid, ServiceNow, Toad

Languages

Odia
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Bengali
Beginner (A1)
A1

Timeline

Senior Oracle Database Administrator

Tata Consultancy Services (TCS), Iron Mountain
12.2020 - Current

Oracle Database Administrator

Wipro
11.2015 - 12.2020

M. Tech - IT

Vellore Institute of Technology

BSc -

Gangadhar Meher University

Newton College of Science, Sambalpur

BSE -

Budharaja High School, Samalpur

Similar Profiles

CREATE PROFILE
JAYASHREE SAHOO