Summary
Overview
Work History
Education
Skills
Websites
Personal Information
Technical skills
Accomplishments
Timeline
Generic
Prachi Shroff

Prachi Shroff

Mumbai

Summary

Experienced Oracle Database Administrator with 6+ years of expertise in managing and optimizing Oracle databases in enterprise environments. Specializes in high availability, disaster recovery, and performance tuning. Proficient in SQL/PLSQL and Unix shell scripting for automation. Skilled in database security and resolving complex issues. Strong collaborator providing 24/7 support. Able to manage large databases and lead critical operations.

Overview

6
6
years of professional experience

Work History

Senior Oracle Database Administrator

Tech Mahindra Limited (SBI)
Mumbai
09.2023 - Current
  • Collaborated with operations, development, and incident management teams to ensure availability and reliability of databases and deployed software.
  • Developed SQL, PL/SQL scripts to enhance and optimize database performance, supporting development activities.
  • Partnered with stakeholders, including management, developers, and end-users, in designing and implementing databases for commercial applications.
  • Deployed test databases to support concurrent development efforts on production systems.
  • Conducted database installation, tuning, and provided DBA support across development, business analysis, consulting, and Oracle Support teams.
  • Collaborated with managed service providers and internal teams to design database systems and support applications.
  • Automated routine database tasks using SQL and Unix shell scripts, focusing on partition management and space usage.
  • Performed daily database administration, including user management, space monitoring, and performance tuning.
  • Applied and tested Oracle security patches, optimized database performance, and enforced security protocols using roles and privileges.
  • Implemented database backup strategies, performed recovery operations using RMAN, and monitored database health via Oracle Enterprise Manager (OEM).
  • Managed materialized views to shift load from production to reporting servers, improving system performance.
  • Provided 24/7 support during production activities, ensuring smooth transitions and high system availability.
  • Troubleshot clustering and server consolidation issues, resolving node eviction, voting disk corruption, and RAC connectivity problems.
  • Administered Oracle database systems, including Exadata to VM server migration, Transparent Data Encryption (TDE) implementation, and RAC node patching.

Oracle Database Administrator

Clover Infotech Pvt. Ltd.
Mumbai
07.2018 - 08.2023
  • Applied OPatch to Linux, AIX, and Windows environments, performing upgrades and migrations from Oracle 11g to 19c on standalone and RAC databases.
  • Conducted SQL and PL/SQL tuning, utilizing AWR, ADDM, and ASH for performance monitoring and issue resolution.
  • Performed routine database maintenance, such as rebuilding indexes, gathering statistics, and refreshing materialized views.
  • Configured Oracle database security, including Oracle Vault, Oracle Wallet, and Transparent Data Encryption (TDE).
  • Automated database tasks through shell scripting for backup, recovery, and monitoring of database health and storage.
  • Cloned production databases using RMAN duplication, performed regular database monitoring and maintenance via Oracle Enterprise Manager (OEM).
  • Implemented database migration using datapump and export/import utilities, ensuring successful backup and restore processes.

Education

Bachelor of Computer Engineering -

Gujarat Technological University
India
08-2018

Diploma in Computer Engineering -

Gujarat Technological University
India
07-2015

Skills

  • Database Administration
  • Performance Tuning and Optimization
  • Backup and Recovery (RMAN)
  • Disaster Recovery Planning
  • High Availability and Clustering (RAC)
  • Security Management (Roles, Privileges, Patches)
  • Capacity Planning
  • Database Design and Implementation
  • Incident Management
  • Database maintenance and monitoring
  • Oracle 9i/10g/11g/12c/19c
  • RAC (Real Application Clusters)
  • ASM (Automatic Storage Management)
  • Data Guard
  • Goldengate
  • Partitioned tables
  • RMAN (Recovery Manager)
  • Database Cloning
  • Backup Strategies
  • Point-in-Time Recovery (PITR)
  • Tablespace PITR
  • Failover/Switchover
  • AWR (Automatic Workload Repository)
  • ADDM (Automatic Database Diagnostic Monitor)
  • ASH (Active Session History)
  • Oracle Enterprise Manager (OEM)
  • STATSPACK
  • SQL trace
  • Explain plan
  • SQL query optimization
  • Index rebuilding and monitoring
  • Oracle Vault
  • Oracle Wallet
  • Transparent Data Encryption (TDE)
  • Roles and Privileges Management
  • Oracle security patches
  • SQL/PLSQL scripting
  • Unix shell scripting
  • CRON jobs
  • SQL/Unix scripts
  • Red Hat Linux
  • AIX
  • Windows
  • OPatch Utility
  • Grid Infrastructure Installation and Configuration
  • Oracle Database Upgrades
  • Oracle RAC
  • Clusterware
  • Exadata
  • Server consolidation and clustering
  • Oracle Data Pump
  • Export/Import Utilities
  • Transportable Tablespace
  • SRVCTL Utility
  • CRSCTL Utility

Personal Information

  • Date of Birth: 09/14/96
  • Gender: Female
  • Nationality: Indian

Technical skills

Oracle 9i/10g/11g/12c/19c, RAC (Real Application Clusters), ASM (Automatic Storage Management), Data Guard, Goldengate, Partitioned Tables (Maintenance, Archiving, Exchange), RMAN (Recovery Manager), Database Cloning (RMAN Duplication), Backup Strategies (Hot, Cold, Incremental Backups), Point-in-Time Recovery (PITR), Tablespace PITR, Disaster Recovery (Failover/Switchover), AWR (Automatic Workload Repository), ADDM (Automatic Database Diagnostic Monitor), ASH (Active Session History), Oracle Enterprise Manager (OEM), STATSPACK, SQL Trace, Explain Plan, SQL Query Optimization, Index Rebuilding and Monitoring, Oracle Vault, Oracle Wallet, Transparent Data Encryption (TDE), Roles and Privileges Management, Oracle Security Patches (Application and Testing), SQL/PLSQL Scripting, Unix Shell Scripting, CRON Jobs (Backup & Maintenance Automation), SQL/Unix Scripts (Database Monitoring, Partition Maintenance), Red Hat Linux, AIX, Windows, OPatch Utility (Standalone & RAC), Grid Infrastructure Installation & Configuration, Oracle Database Upgrades (Versions 11g to 19c), Oracle RAC, Clusterware, Exadata, Server Consolidation & Clustering, Oracle Datapump, Export/Import Utilities, Transportable Tablespace, Oracle Enterprise Manager (OEM), SRVCTL Utility (Server Control), CRSCTL Utility (Cluster Control)

Accomplishments

For my dedication to the task assigned and for extraordinary service.

Timeline

Senior Oracle Database Administrator

Tech Mahindra Limited (SBI)
09.2023 - Current

Oracle Database Administrator

Clover Infotech Pvt. Ltd.
07.2018 - 08.2023

Bachelor of Computer Engineering -

Gujarat Technological University

Diploma in Computer Engineering -

Gujarat Technological University

Similar Profiles

CREATE PROFILE
Prachi Shroff