Ravi Yadlapalli
JERSEY CITY,New Jersey
Summary
Database Administrator with 12+ years of experience in designing, installing, upgrading and managing Oracle 11g,12c,19C RAC & Exadata database ,PostgreSQL DBA and AWS RDS Databases(MySQL & PostgreSQL) in large-scale Unix/Linux environments. Professional skills include Performance Tuning, Security, User & Space management, Datagurad,RAC , Golden Gate ,Exadata.
Overview
12
12
years of professional experience
Work History
Oracle Database Analyst (Contract)
Deutsch Bank
New York, NY
07.2022 - Current
- Utilized Metalink for opening tickets, downloading and applying patches.
- Monitored and administered numerous databases in UNIX/Linux environments on Oracle 11gR2 databases.
- Responsible for the creation and management of users, roles, profiles, and privileges.
- Troubleshooted and resolved user connectivity and account lockout issues.
- Planned and implemented backup and recovery strategies.
- Performed capacity planning for efficient database growth.
- Configured Oracle Enterprise Manager (OEM) to automate and monitor numerous databases.
- Responsible for creating and managing tablespaces and datafiles.
Technical Lead
Evoke Technologies
Hyderabad , INDIA
06.2020 - 05.2022
- Assisted in planning and implementing Disaster Recovery and High Availability strategies.
- Perform ongoing database maintenance, patching and upgrading for Oracle 11gR1/11gR2 databases.
- Utilize Oracle diagnostics tools like Explain Plan, SQL Trace, TKPROF, and the AWR to analyze timing & execution plan for tuning. Also use TOP and VMSTATS to understand the impact on memory & CPU processes.
- Design and implement standard and advanced security enhancement and monitoring policies using Fine Grain Access Control (FGAC) and Fine Grain Auditing (FGA).
- Provide guidance and recommendations for efficient use of database resources using various Resource Management techniques.
- Plan and implement backup and recovery strategies using RMAN.
- Utilize Oracle support to troubleshoot and solve critical database issues.
- Work with clients, information architect, system admin, and developers to define information flow helping to transform business requirements into environment specific databases.
- Attend bi-weekly / monthly meetings to understand business needs and provide suggestions for enhancement.
- Assist in the design and implementation of several databases using Data-Flow Diagrams (DFD's) and E/R Models.
- Provide database maintenance using SQL Developer and OEM.
Lead Administrator
Wipro Technologies
Kaulalumpur, Malaysia
07.2016 - 05.2020
- Performed initial installation/creation of numerous 11g databases.
- Implemented conceptual database designs and logical models.
- Planned and implemented backup and recovery strategies.
- Performed capacity planning for efficient database growth.
- Configured Oracle Enterprise Manager (OEM) Grid Control to automate and monitor numerous databases.
Senior Operations Professional
IBM
Bangalore, India
01.2011 - 07.2016
- Developed, tested, and managed backup and recovery plans.
- Responsible for performing routine checks of a certain number of assigned databases to ensure maximum efficiency and availability.
- Supporting database management by utilizing upgrade, tuning, and monitoring techniques.
- Utilize Metalink for opening tickets, downloading and applying patches.
- Assisted in database design and implementation.
Consultant
Infinite Technology Solutions
Bangalore, India
08.2010 - 12.2010
- Implemented and monitored RMAN backup jobs
- Utilized Oracle support to troubleshoot and solve critical database issues.
- Performed ongoing database maintenance, patching and upgrading.
- Provided guidance and recommendations for efficient use of database resources.
Education
Bacheoloer of Technology - Electrical And Electronics Engineering
JNTU
Hyderabad04.2007
Skills
- Data Science Research Methods
- Active Learning
- SQL Server Integration Services (SSIS)
- Metric Report Development
Timeline
Oracle Database Analyst (Contract)
Deutsch Bank
07.2022 - Current
Technical Lead
Evoke Technologies
06.2020 - 05.2022
Lead Administrator
Wipro Technologies
07.2016 - 05.2020
Senior Operations Professional
IBM
01.2011 - 07.2016
Consultant
Infinite Technology Solutions
08.2010 - 12.2010
Bacheoloer of Technology - Electrical And Electronics Engineering
JNTU
Similar Profiles
Ataurrahman HashmiAtaurrahman Hashmi
Assistant Vice President at Deutsch BankAssistant Vice President at Deutsch Bank
Sudheesh MangalasseriSudheesh Mangalasseri
Regulatory Reporting Analyst at Deutsch BankRegulatory Reporting Analyst at Deutsch Bank
Bhavana KengegowdaBhavana Kengegowda
Assistant Vice President- Production Support at Deutsch BankAssistant Vice President- Production Support at Deutsch Bank