Likhita. V

ORACLE DBA

About

Highly skilled Oracle DBA with 5 years of experience in 24x7 production support and administration of large-scale databases (Oracle 11g, 12C, 19C). Proven expertise in ensuring optimal database performance, availability, and security through advanced backup and recovery (RMAN), Data Guard, GoldenGate, and performance tuning. Adept at managing complex OLTP environments and collaborating with cross-functional teams to deliver robust database solutions for critical business operations.

Work

Oracle Cerner Corporation

|

Oracle DBA

→

Summary

Currently serving as an Oracle DBA for Cerner Health Care, a leading health care provider, managing critical production and development OLTP environments with databases up to 12TB.

Highlights

Performed comprehensive database backups and recovery using RMAN (hot and cold), ensuring 100% data recoverability for critical healthcare systems.

Executed data exports and imports via Data Pump (EXPDP/IMPDP) with parameter files and remapping, facilitating seamless data migration and integration for various projects.

Conducted performance tuning and alert log analysis, optimizing database performance and availability by identifying and resolving bottlenecks in real-time.

Managed and configured Automatic Storage Manager (ASM), enhancing storage efficiency and performance for high-volume healthcare data.

Successfully handled GoldenGate scenarios, including resolving trail file loss/corruption and troubleshooting performance and Abend issues, ensuring data replication integrity.

Monitored and troubleshot performance of ATPs, GoldenGate Deployments, Replicats, and Extracts via OCI console, ensuring robust cloud database operations.

Configured and maintained physical standby Data Guard setups, including switchover, failover, and activation, ensuring continuous data availability and disaster recovery capabilities.

Cognizant Technology Solutions

|

Oracle DBA (Sanofi Pharma Aventis Client)

→

Summary

Supported Sanofi Pharma Aventis as an Oracle DBA, managing large-scale production, development, test, and UAT OLTP environments with databases ranging from 600MB to 12TB.

Highlights

Performed critical Dataguard switchover activities, ensuring high availability and disaster recovery for vital pharmaceutical operations.

Managed comprehensive storage, archiving, backup, and recovery processes for multi-terabyte databases, safeguarding data integrity and business continuity.

Optimized database performance and availability through proactive monitoring, SQL query tuning, and strategic partitioning, improving system efficiency.

Administered user access and schemas, enforcing robust security protocols and managing permissions across diverse database environments.

Collaborated with Project Managers, Network Administrators, IT teams, and developers to ensure seamless database operations, security, and availability for critical client applications.

Installed, patched, and upgraded Oracle databases on Linux/AIX platforms, ensuring systems remained current, secure, and performed optimally.

Troubleshot complex database issues using utilities like explain plan and index rebuilds, resolving performance bottlenecks and ensuring operational stability.

Cognizant Technology Solutions

|

Oracle DBA (PepsiCo Client)

→

Summary

Provided Oracle DBA support to PepsiCo Netherlands BV, managing extensive production, development, test, and UAT OLTP database environments ranging from 600MB to 12TB.

Highlights

Successfully executed Dataguard switchover activities, maintaining continuous operation and disaster recovery capabilities for PepsiCo's critical systems.

Implemented and managed robust backup and recovery strategies (RMAN, logical/physical backups) for multi-terabyte databases, ensuring data protection and rapid restoration.

Enhanced database performance and availability through SQL query tuning, index rebuilds, and table re-organization, optimizing data access for business operations.

Administered user and schema access controls, upholding stringent security standards and compliance for sensitive PepsiCo data.

Collaborated cross-functionally with IT and development teams to ensure optimal database performance, security, and availability, supporting business-critical applications.

Conducted installation, patching, and upgrade of Oracle databases on Linux/AIX, maintaining system integrity and leveraging the latest features.

Proactively resolved database issues identified in alert logs and developer feedback, minimizing downtime and ensuring smooth operations.

Education

Krishna University

→
B.Sc Computers

Languages

English

Skills

Performance Tuning & Monitoring

SQL Tuning, AWR Reports, Alert Log Analysis, Active Sessions, Explain Plan, Index Rebuild, Analyze, Memory Management, Trace Files, Trim Files, Audit Logs.

Database Administration

Oracle 10g, Oracle 11g, Oracle 12C, Oracle 19c, OCI (basics), 24x7 Production Support, OLTP Environments, Database Architecture, DBCA, Tablespaces, Profiles, Roles, Privileges, Undo Management, Flashback Query, Control File, Redo Logs, Data Files, Listener, TNS.

Backup & Recovery

RMAN, Complete Backup & Recovery, Tablespace Recovery, Datafile Recovery, Control File Recovery, Online Redo Log File Recovery, Logical Backup, Physical Backup, Flashback Database, Data Pump (EXPDP/IMPDP), Scheduled Backups.

High Availability & Disaster Recovery

Physical Standby Data Guard, Switchover, Failover, Activating Standby, Monitoring DR Site, Dataguard Broker.

Database Security & User Management

User Management, Schema Management, Access Control, Permissions.

Database Migration & Upgrades

Database Cloning, Installation, Patching, Upgrades.

GoldenGate

Trail File Lost/Corrupted, Performance Troubleshooting, Abend Issue Troubleshooting, OCI Console Monitoring, GoldenGate Deployments, Replicats, Extracts.

Operating Systems

Unix, RHEL (Unix), OEL, HP-UX, Linux/AIX.

Database Tools & Utilities

SQL*PLUS, PLSQL, Winscp Developer, Putty, DBCA, ASM (Automatic Storage Management).

Oracle Features

Pluggable Database, Materialized Views, Datalink, Oracle Partitioning, Refreshing Schemas and Tables.