Aarushi Khatri
Delhi
Summary
Accomplished IT professional with a robust background at TCS, specializing in Oracle database management and cloud migrations. Demonstrates proven expertise in RMAN backup strategies and SQL tuning, with a strong aptitude for technical troubleshooting. Successfully led disaster recovery drills and implemented database hardening measures, ensuring optimal performance and security in high-pressure environments.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Assistant Consultant
TCS
01.2023 - Current
- Managed RAC clusters, ASM disk groups, CRS troubleshooting.
- Managing Exadata/OCI databases
- Use the OCI Portal for Exadata/DB patching for Exadata OCI databases..
- Administered Data Guard environments and DR drills.
- Handled GoldenGate replication, lag troubleshooting.
- Performed PSU/CPU patching, 12c→19c upgrades.
- Executed RMAN backup strategies, PITR, restore drills.
- Performed SQL tuning via AWR/ASH/ADDM.
- Led OCI migrations using RMAN and Datapump.
- Implemented vulnerability patches and DB hardening.
- Perform DB Refresh, Schema Refresh, Table Refresh.
- Implemented proactive monitoring using AWR, ASH, OEM, DataDog, and custom scripts to detect lock escalation.
- Set up database standard and customized monitoring on Datadog.
- Create the table partitioning.
- Create the service request on MOS using the OCI portal and MOS for any technical issue or outage in the DB.
- Actively involved in global project transitions across multiple regions, ensuring a smooth handover of database operations and technical workflows.
- Conduct Detailed Design (DD) sessions with stakeholders, architects, and technical teams to discuss database solutions, architecture, and project deliverables.
- Lead and support knowledge-sharing sessions, onboarding, and mentoring of new team members to ensure a smooth transition and upskilling.
Specialist
HCL
05.2015 - 12.2022
- Installed and upgraded Oracle DBs (11g/12c→19c).
- Performed space mgmt and schema admin.
- Used datapump/exp/imp for DB refreshes.
- Managed Commvault-based backups/recovery.
- Diagnosed alert logs, long SQL, locking issues.
- Generated AWR tuning recommendations.
- Coordinated Oracle SR cases.
- Decommissioned DBs, created DBs via DBCA.
Technical Support Engineer
The Phone support
Jaipur
03.2014 - 05.2015
- Provided technical assistance to customers via phone,Remote desktop and email support.
- Diagnosed hardware and software issues to resolve customer inquiries efficiently.
Education
B.Tech - CSE
Sagar Institute of Research Technology & Science
Bhopal01.2013
XII & X -
St. Johns Sr. Sec. School
Damoh, MPSkills
- Exadata OCI, AWS, RDS, and Azure Cloud
- Oracle 11g, Oracle 12c, Oracle 19c
- AWR, ASH, ADDM
- RMAN backup/recovery and Data Pump
- Performance monitoring and tuning
- On-prem cloud migration/lift-shift
- Patch management
- SQL tuning
- Data Guard administration
- Report generation
- Oracle RAC/ASM management
- Database hardening
- Oracle enterprise manager
- Space/memory management
- Incident management, change management
- ITIL processes
- Oracle Exadata management
- Capacity planning
- Compliance, security management, audits
Certification
- OCI Foundations
- AWS Cloud Practitioner
- Azure Fundamentals (AZ-900/SC-900)
- ITIL
Accomplishments
- Reduced ETL query runtimes by 70%.
- Migrated On Prem Oracle database to OCI.
- Automated capacity planning & monitoring dashboards.
Affiliations
- Actively involved in global project transitions across multiple regions, ensuring smooth handover of database operations and technical workflows.
- Conduct Detailed Design (DD) sessions with stakeholders, architects, and technical teams to discuss database solutions, architecture, and project deliverables.
- Create and update Documents of Understanding (DOU) for project knowledge transfer, inter-team responsibilities, and process alignment.
- Develop, maintain, and enhance Standard Operating Procedures (SOPs) to establish consistent operational workflows and improve team efficiency.
- Lead and support knowledge-sharing sessions, onboarding and mentoring of new team members to ensure smooth transition and upskilling.
- Participate in cross-functional collaboration with global teams in cloud, infrastructure, and application domains to align on project goals and technical solutions.
- Continuously work on personal skill enhancement through labs, certifications, and hands-on practice in Oracle RAC, ASM, Data Guard, GoldenGate, and cloud technologies.
Languages
English
First Language
Timeline
Assistant Consultant
TCS
01.2023 - Current
Specialist
HCL
05.2015 - 12.2022
Technical Support Engineer
The Phone support
03.2014 - 05.2015
B.Tech - CSE
Sagar Institute of Research Technology & Science
XII & X -
St. Johns Sr. Sec. School