Summary
Overview
Work History
Education
Skills
Timeline
Generic

Rachana Lakkamgari

Hyderabad

Summary

Over 5.5 years experience as an Oracle and SQL Database Administrator, enhancing database performance and ensuring high availability. Skilled in data migration, storage management, and incident resolution, I effectively managed secure access and optimized system operations, demonstrating strong problem-solving abilities and a commitment to excellence.

Overview

6
6
years of professional experience

Work History

Oracle Database Administrator

Tata Consultancy Services
Hyderabad
08.2019 - Current
  • Set up and managed Oracle database systems across multiple operating systems.
  • Created databases aligning with specific requirements utilizing DBCA.
  • Executed database and grid-level patching.
  • Configured backup and recovery processes using RMAN.
  • Performed database migration (lift and shift) and upgrade of databases.
  • Optimized database operations for improved performance.
  • Created restore points to maintain data integrity and recovery readiness.
  • validation of databases post-server reboot following OS patching.
  • Managed storage operations efficiently.
  • Facilitated shutdown and removal of obsolete database infrastructure.
  • Managed access permissions for new and existing users.
  • Ran scripts across production and non-production databases.

SQL Database Administrator

Tata Consultancy Services
Hyderabad
01.2019 - Current
  • Installed and maintained various versions of SQL Server to ensure optimal performance in Dev and production setups.
  • Designed and optimized database tables, indexes, and views.
  • Experience in logging, mirroring configuration for high availability.
  • Established job schedules for automating diverse database functions.
  • Performed database backup, restore, and recovery.
  • Performed troubleshooting tasks by analyzing server activity and system performance.
  • Controlled database user roles to ensure secure access management.
  • Upgraded and migrated older SQL server instances to newer versions.

Education

Bachelor of Engineering - Electronics and Communication Engineering

CMR Technical Campus
01.2019

Skills

  • Experience with various versions of databases
  • Experience with Windows and Linux operating systems

Timeline

Oracle Database Administrator

Tata Consultancy Services
08.2019 - Current

SQL Database Administrator

Tata Consultancy Services
01.2019 - Current

Bachelor of Engineering - Electronics and Communication Engineering

CMR Technical Campus
Rachana Lakkamgari