Lakshmi Perla
Hyderabad
Summary
Experienced Oracle Database Administrator with 3years of expertise in managing RAC and Non-RAC environments, ensuring database performance, and executing seamless migrations on-premises and in AWS. Skilled in backup, recovery, patching, and automation to enhance efficiency and minimize downtime. Proven ability to troubleshoot critical issues, monitor performance, and collaborate with teams to meet project goals. Dedicated to learning new technologies and optimizing database operations.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Oracle Database Administrator
Wissen Infotech
Hyderabad
08.2022 - Current
- Monitored and resolved Oracle database alerts, ensuring database stability and availability.
- Performed addition of datafiles, user management, and profile management across RAC and Non-RAC environments.
- Conducted PSU patching on standalone and RAC databases to enhance security and performance.
- Configured OEM to manage database details, set blackouts, and generate performance reports.
- Created and managed AWS RDS databases and schemas, ensuring high availability and scalability.
- Performed data refreshes across Oracle Databases on-prem and AWS environments, ensuring data integrity.
- Performed DB Migration form on prem to cloud, Trouble shooting steps, VPC, VPC Peering, CloudWatch, Autoscaling.
- Decommissioned databases and schemas for non-required environments.
- Conducted AWR report generation at OEM and server levels to monitor and improve database performance.
- Resolved blocking sessions, inactive sessions, and listener issues, ensuring minimal downtime.
- Administered ServiceNow for incident management, maintaining SLAs, and resolving connectivity issues.
- Automated regular backup procedures using RMAN and AWS snapshots, reducing data loss risks.
- Collaborated with development teams to deploy and maintain databases in production and nonproduction environments.
- Assisted in capacity planning and performance analysis to ensure scalability and reliability.
- Provided training and mentoring to junior DBAs, enhancing overall team performance.
- Ensured compliance with database security policies and best practices.
- Participated in disaster recovery planning and testing, ensuring data redundancy and failover capabilities.
- Developed custom scripts to automate database health checks and streamline routine maintenance tasks.
- Migrated critical databases from on-premises to AWS RDS, minimizing downtime and ensuring data consistency.
- Led database health check initiatives that improved system performance by 20% through proactive tuning.
- Collaborated with network and storage teams to optimize database storage and connectivity performance.
- Designed and implemented database partitioning strategies to manage large data volumes efficiently.
- Conducted performance benchmarking and stress testing for critical production systems.
- Ensured to maintain SOP's and create the SOPs at every critical and simple activity performed.
Education
BTech - ECE
Chirala Engineering college of chirala
ChiralaSkills
- Database Management
- Backup and Recovery
- Monitoring and Alerts
- Patch Management
- Cloud Database Management
- User and Profile Management
- File System Management
- Script Deployment and Automation
- Incident and Problem Management
- Security and Compliance
- Disaster Recovery
- AWS RDS management
Certification
AWS Certified Cloud Practitioner Foundational
Disclaimer
I hereby declare that the information provided above is true and correct to the best of my knowledge.
Projects
Database Performance Tuning, Optimized SQL queries and database parameters to improve performance by 30%. ServiceNow Integration, Automated incident and problem management processes using ServiceNow workflows.
Timeline
Oracle Database Administrator
Wissen Infotech
08.2022 - Current
BTech - ECE
Chirala Engineering college of chirala