Yashwanth Kumar
Tech Lead
Bengaluru
Summary
Experienced Oracle Apps DBA with over 9+ years of expertise in managing and optimising Oracle E-Business Suite environments. Proficient in database administration, performance tuning, backup and recovery, and ensuring high availability of Oracle systems.
Overview
10
10
years of professional experience
2
2
Certifications
Work History
Tech Lead , Oracle DBA and Apps DBA
Tech Mahindra
Bengaluru
08.2022 - Current
- As a POC ,Scheduling and Supporting the Planned Work (Downtime Activities) as per customer request.
- Implementation of Application and Databases (12c/19c).
- Extensively using the Export/Import Utilities
- Backup and Recovery using RMAN
- Supporting Oracle Golden Gate by Setting up Manager and Creating parameter File for it.
- Troubleshooting the Extract and Replicat process.
- Application and Database Cloning and Patching
- ASM Storage : Checking Archive space, Disk Related activities.
- Generating AWR, SQLHC for performance analysis.
IT Senior Systems Consultant
Oracle Solutions Services India Pvt LTD
Bengaluru
01.2018 - 08.2022
- As a Senior consultant involved in planning & execution of the scheduled activities.
- Involved in developing Oracle Apex application to track all the activities we perform across our org for different clients.
- Administration of EMCC for monitoring and acknowledging of alerts.
- Worked on Oracle quarterly refreshes or as per the Developers request.
- Apps patching and maintenance.
- Deploying the different kind of patches like RPD, Application WAR files etc
- Knowledge on Microsoft Active Directory
- Maintenance of WebLogic Servers on cloud Environments.
- Generating AWR, SQLHC for performance analysis.
Analyst
Cognizant Technology Solutions
Bengaluru
12.2014 - 01.2018
- Installation of Oracle 11g/12c/19c database/ R12 Applications on Linux
- Creating users in Oracle Applications/Siebel/Agile
- Verify Primary and Secondary database archive sync activities.
- Supported OGG process, monitoring and troubleshooting the Extract and Replicat process.
- Creating and managing application users and granting privileges as per approval.
- Monitoring alert logs and troubleshooting of database related issues.
- Checking growth of tablespaces, adding, renaming & resizing of datafiles.
- Managing archive log files, taking backup and free up the space.
- Patching:DB Patching (using opatch/opatchauto utility )
- Application Patching (Normal Patching/online patching using adpatch utility ) Application Patching (using ADOP –utility R12.2)
- Cloning: DB Cloning using RMAN Duplicate & Normal restore
Education
Bachelor of Engineering - Computer Science
Visvesvaraya Technological University
Skills
Database Management: Oracle Database 11g/12C/19C
High Availability: RAC , Dataguard , Golden Gate
Oracle EBS : R12 , 11i
Operating System : Linux , Unix, Solaris
Backup & Recovery : RMAN , DataPump
Performance Tuning : SQL Tuning, AWR , ADDM
Scripting : Shell Scripting, PL/Sql , Python
Certification
Oracle Autonomous Database Cloud 2019 Specialist
Personal Information
- Father's Name: Mahadeva D
- Date of Birth: 06/08/1990
- Gender: Male
- Nationality: India
Accomplishments
Built Oracle Apex application to track all the activities performed across our org for all the clients we have been supporting.
Timeline
Tech Lead , Oracle DBA and Apps DBA
Tech Mahindra
08.2022 - Current
IT Senior Systems Consultant
Oracle Solutions Services India Pvt LTD
01.2018 - 08.2022
Analyst
Cognizant Technology Solutions
12.2014 - 01.2018
Bachelor of Engineering - Computer Science
Visvesvaraya Technological University