Database Administrator United States

Indrani Kancharla - page *

Indrani Kancharla

Lake Forest, California, United States

***********@*****.*** 949-***-****

linkedin.com/in/indrani-kancharla

Summary

Oracle database administrator with 4.6 years of experience in managing databases, sql/plsql, administration, configuration, migration, upgrades, patching, installation, decommission, performance tuning, user management, tablespace management and 24/7 production support. Skills

Database Administration • Datapump • Recovery Manager (RMAN) • SQL • Query Optimization • ASM • Performance Tuning • Dataguard • Oracle RAC • User Management • Database Management System

(DBMS) • Project Management • Patch Management • Capacity Management Tools

Oracle Enterprise Manager(OEM), APEX, Winscp, ServiceNow and PL/SQL developer. Experience

System Engineer

Tata Consultancy Services

Jan 2022 - Mar 2024 (2 years 3 months)

* Enhanced database performance through tuning and optimization.

* Query optimization and analyzing poor performing queries using explain plan.

* Detecting defects on the query and providing hints to the query for better performance.

* Applied weekly patches for both production and non-production databases.

* Created essential database objects, including tables, indexes, sequences, and user profiles.

* Set up and maintained Oracle RAC (Real Application Clusters) for high availability and performance.

* Implemented and tested backup strategies using RMAN, ensuring data integrity and minimal downtime. Senior Analyst

Capgemini

Oct 2020 - Jan 2022 (1 year 4 months)

* Managed databases, user accounts, tablespaces, and backups.

* Handled operations and maintenance on Oracle core IT servers and private IaaS (cloud) servers.

* Performed schema, table, and database refreshes on 12c, 18c, and 19c databases using expdp and impdp.

* Installed, created, and decommissioned database software as needed.

* Reorganized tablespaces for optimal performance.

* Worked with Oracle multitenant container databases (CDB) and pluggable databases (PDB).

* Provided 24/7 production support to ensure continuous system availability. Indrani Kancharla - page 2

Analyst

Capgemini

Aug 2019 - Sep 2020 (1 year 2 months)

* Addressed performance issues such as listener service disruptions, agent issues, and connectivity problems.

* Monitored database performance and resolved critical alerts in Oracle Enterprise Manager (OEM).

* Generated and analyzed AWR and ADDM reports for performance insights.

* Managed daily DBA tasks using Oracle utilities and tools, including monitoring space and memory requirements.

* Proficient in Linux commands for efficient database management.

* Regularly checked alert logs, archive logs, trace files, and verified backups and tablespace availability.

* Handled incident resolution, problem identification, and root cause analysis for ongoing system reliability. Education

MGVR College of Engineering

Bachelor of Technology - BTech, Electrical, Electronics and Communications Engineering

2015 - 2019

Licenses & Certifications

Oracle Cloud Infrastructure 2022 Certified Foundations Associate - Oracle Issued Apr 2023 - Expires Apr 2025

OC4007254

Google Cloud Certified Associate Cloud Engineer - Google Issued Jun 2023 - Expires Jun 2026

13xPEG

AWS Certified Cloud Practitioner - AWS

Issued Oct 2024 - Expires Oct 2027

50dc00d2f87d48d8ae1f35e363f6cc26

Contact this candidate