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
2022.07 - 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
2020.06 - 2022.05
- 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
2016.07 - 2020.05
- 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
2011.01 - 2016.07
- 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
2010.08 - 2010.12
- 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
2022.07 - Current
Technical Lead
Evoke Technologies
2020.06 - 2022.05
Lead Administrator
Wipro Technologies
2016.07 - 2020.05
Senior Operations Professional
IBM
2011.01 - 2016.07
Consultant
Infinite Technology Solutions
2010.08 - 2010.12
Bacheoloer of Technology - Electrical And Electronics Engineering
JNTU
Similar Profiles
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
Irma HoxhaIrma Hoxha
Operations Expert at Deutsch Bank GroupOperations Expert at Deutsch Bank Group