Rohit K Pawar
Ilkal, Karnataka
Summary
Detail-oriented and dedicated IT professional with over 1.5 years of experience as an Oracle Database Administrator, complemented by Java Full Stack development training. Proficient in managing and maintaining Oracle database environments, ensuring high availability, backup/recovery, and performance tuning.
Overview
3
3
years of professional experience
Work History
Software Engineer
Volkswagen Group Technology Solutions India Pvt. Ltd
Pune
08.2023 - Current
- Expertise in Oracle 19c, 11g, and 10g on various Unix platforms (Linux, Solaris) involving database creation, refresh, user management, RMAN, Data Pump Export and Import utilities.
- Experience in shell scripting and Oracle utilities like Oracle Enterprise Manager (OEM), SQL Developer, SQL*Plus, and TOAD.
- Involved in Installation, Performance Tuning, Backup and Recovery, RDBMS Patching, Security, Oracle Enterprise Manager (OEM), Standby Database, and Database Upgrade from earlier versions to 19c.
- Creation of databases, instances, tablespaces, data files, undo/rollback segments.
- Proficient in creating tables, indexes, synonyms, views, sequences, profiles, constraints, triggers, and stored procedures.
- Hands-on experience in Backup & Recovery using RMAN, Data Pump, and custom SQL scripts.
- Proficient in tools like LogMiner, SQL*Loader, and Data Pump (expdp/impdp).
- Capable of handling daily DBA tasks: space and memory monitoring, performance tuning, alert log and archive log checks, and backup verification.
- Experience in configuring and maintaining Oracle Data Guard (Physical Standby) with real-time log shipping and failover readiness.
- Experience in installation and administration of Oracle RAC (Real Application Clusters).
- Worked as a 24x7 Production DBA and also supported application development teams.
- User and Role Management: Managing users, roles, and privileges with security best practices.
- Proficient in monitoring system resources, managing disk usage, memory allocation, and implementing redundancy solutions.
- Backing up and restoring database, Backup and recovery plan using Dump and Load command, Creating Logical Device names, using backup server for backup and recovery, Step by step recovery of database after crash.
- Proactive and efficient in timely delivery of all assignments, always enthusiastic to take up new challenges.
Project Intern
DANA Incorporated
Hubli
01.2022 - 06.2022
- Built interactive Power BI dashboards for the HR team and the Supply Chain team.
Education
Bachelor of Engineering - Computer Science And Engineering
KLE Technological University
Hubli06-2023
Pre University Course - PCMB
Spandana P.U Science College
Ilkal03-2019
High School Diploma -
S.V.M English Medium High School
Ilkal04-2017
Skills
- Operating System: Linux, Windows
- Languages: SQL, C, C, Java, HTML, CSS, JavaScript
- GUI Tools: OEM
- Databases: 19c, 11g, 10g
- DB Tools: SQL*Plus, Export & Import utility, OEM, DBCA, RMAN, TOAD, Oracle Apex
- Software applications: MS Office, Power BI
Hobbies
- Playing chess and carrom
- Playing PC games
- Drawing
Timeline
Software Engineer
Volkswagen Group Technology Solutions India Pvt. Ltd
08.2023 - Current
Project Intern
DANA Incorporated
01.2022 - 06.2022
Bachelor of Engineering - Computer Science And Engineering
KLE Technological University
Pre University Course - PCMB
Spandana P.U Science College
High School Diploma -
S.V.M English Medium High School
Similar Profiles
Shraddha ShindeShraddha Shinde
Software Engineer at Volkswagen Group Technology Solutions IndiaSoftware Engineer at Volkswagen Group Technology Solutions India
Mayur KumbhareMayur Kumbhare
Senior Business Analyst at Volkswagen Group Technology Solutions IndiaSenior Business Analyst at Volkswagen Group Technology Solutions India
Hrishikesh Mahesh ThatteHrishikesh Mahesh Thatte
Design Engineer {For Client SKODA Auto Volkswagen} at Volkswagen Group Technology Solutions India, VWITSDesign Engineer {For Client SKODA Auto Volkswagen} at Volkswagen Group Technology Solutions India, VWITS
NAGAVENU HJNAGAVENU HJ
Civil Site Engineer at CLASS 1 contractorCivil Site Engineer at CLASS 1 contractor
Jinso P JoseJinso P Jose
Assistant Manager - Finance & Accounts at NEWMEAssistant Manager - Finance & Accounts at NEWME