Komal Vishwajit Kamble
Oracle DBA/ RAC/ Goldengate/ Exadata/ Upgrade/ Data Guard/RMAN
*****.*********@*****.***
PROFESSTIONAL SUMMARY
I have 12 years of experience in multiple domains as Oracle Database Administrator which includes 3 years of experience on Exadata Machines (X5, X7, X8-M) and 5 years of experience on Oracle Golden Gate Configuration and Maintenance. I am Having good knowledge in RAC,Dataguard,RMAN,ASM and performance tuning and implemented 2 Node RAC on Linux.
Applied Patch on Exadata’s database and grid Homes as like BP, PSU patches.
Worked with Oracle support team to plan and upgrade/Patch IB switches, Cell Nodes and storages
Monitoring standby databases and troubleshooting if the DB is not in sync with Primary. Migrated database from standalone to DATAGUIARD.
Working and configured Transparent Data Encryption on 12c database and converted non-TDE tablespaces to TDE tablespaces to make more secure on tablespaces.
Manual Database refresh from production to other development environment and doing through RMAN DUPLICATE method from prod to dev/test environment.
Having good knowledge on performance tuning and good exposure to analyze the AWR, ADDM, SQL-T etc.
Extensively worked on switchover and switchback activities during DR drills.
Huge experience in Oracle Real Application Cluster.
Worked on Oracle 11G, 12C and 19C (non-CDB).
Experience in managing 24X7 support to maintain all Databases up and running in Prod and non-prod environments.
Upgraded database from various lower-level version to 11.2.0.4 and 12c and applying PSU patch based on every release from oracle.
Having good Knowledge in Logical backup and restoration using EXPDP/IMPDP.
Experience in Physical backup using RMAN.
Trouble shooting backup level issue RAMN and Involved restore activity (INCOMPLETE/COMPLETE) depends upon the scenarios.
Refreshed database from Production to Development using RMAN backup,Hot backup method and Duplicate method.
Extensively applied Oracle quarterly released patches and bug fix patches.
Having good experience in raising SR for different issues and coordinating with Oracle Support.
Successfully done activities related to Oracle Goldengate Reconfiguration.
Experience in Deploying different code given by Application team using SQL Developer.
Technical skills
Skill Name
Tools/Technology/Platforms
Oracle Database Administration
Oracle 10g,11g,12c,18c,19c
Operating system
Sun Solaris, Linux and Windows
Tools
SQL developer,BMC remedy tool, Swayam monitoring tool
Oracle Goldengate
Monitoring Extract and Replicat of source and target database, Reconfiguration of both source and target database.
Oracle Exadata
X5,X7,X8-M,X9-M
Hardware
AIX server, Sun Solaris and Linux Read hat, Windows,
Networking Technologies
TCP/IP, FTP, HTTP, DNS
PROFESSIONAL EXPERIENCE
Senior Executive Technical Consultant (Oracle/Exadata DBA) September 2022 February 2023
SIMPLE LOGIC IT PVT. LTD.
Project description
This project involves mainly supporting on-site team for any issues identified in Production, development and test Databases Critical to different clients.
Key Responsibility Areas
Managing onsite L1 team Remotely for Different issues.
Upgrading from 12.1.0.2 to 19C for Client.
Production support for Oracle Databases as raised by L1 team.
Performing Physical and Logical backup and error checking for the same.
Configuration of Golden Gate and hand it over to L1 team for Administration.
Implemented Dataguard and having good knowledge on Physical databases, Configuration of the same and hand it over to L1 team.
Preparing plan of action for Refreshing UAT, Development and Test databases using EXPDP and IMPDP and sharing with L1 team for Execution.
Involved in Issue resolution, User communication and interactions and regular support activities.
Develop a plan of action for patching different component of Exadata Machines, and help team to execute it.
Coordinate with Oracle Support for any issues identified on Exadata Machines raised by L1 team.
Working as head for Service Delivery Solution Tool (Ticketing Tool).
Providing training to new joiners
Adding Disk to diskgroup and having good exposure on ASM.
Working and configured Transparent Data Encryption on 12c /19c database and converted non-TDE tablespaces to TDE tablespaces to make more secure on tablespaces
Build multiple standby databases and converted snapshot standby for application testing purpose.
Installation and implementation of oracle 12c and 19c database in various env.
Worked on block level corruption as like physical and logical block corruption.
Performed datafile movement between own diskgroup.
Working on performance tuning based on user request.
Performed Restore activity due to various level of issue.
Configuring RMAN backup for new build database
Worked on schema refresh using Export and import
Performed for Database refresh using RMAN.
Senior Oracle/Exadata Database Administrator December 2021 – August 2022
NETXCELL LTD.
Project description
This project involves supporting Production, development and test Databases 11g, 12C and 19C, patching of different components of X5, X7 and X8-M Exadata Machines, Golden Gate reconfiguration.
Key Responsibility Areas
Monitoring around 30 databases and troubleshooting the errors, archive and space management for all the databases.
Managing profiles, user accounts and password policies.
Upgrading from 12.1.0.2 to 19C.
Production support for Oracle Databases.
Performing Physical and Logical backup and error checking for the same.
Configuration of Golden Gate and Administration.
Configuration of Physical Standby and Administration.
Refreshing UAT, Development and Test databases using EXPDP and IMPDP.
Involved in Issue resolution, User communication and interactions and regular support activities.
Monitoring 7 different Exadata Machines with versions like X5, X7 and X8-M.
Patching of all Exadata Machine components like Cell Server, IB switches and DB nodes using patchmgr utility.
Communicating with Oracle Support for activities like Battery Change and Disk Change for Exadata Machines.
Providing Exachk report as the requirement to Oracle Support.
Applying PSU and bundle patch on every 3 months.
Working on performance tuning based on user request.
Oracle database administration
Performed Restore activity due to various level of issue.
Configuring RMAN backup for new build database
Worked on schema refresh using Export and import
Performed for Database refresh using RMAN.
MAPPS INFOTECH PVT. LTD August 2016 –December 2021
Oracle /Exadata/Goldengate DBA
Project Description
This project involves supporting more than 100 databases (Production/Non-Production/Test) for different issues.
Key Responsibility Areas
Monitoring more than 100 databases and troubleshooting the errors, archive and space management for all the databases.
Applying Oracle quarterly released patches and bug fix patches.
Managing profiles, user accounts and password policies.
Upgrading from 12.1.0.2 to 19C.
Production support for Oracle Databases.
Performing Physical and Logical backup and error checking for the same.
Configuration of Golden Gate and Administration.
Configuration of Physical Standby and Administration.
Refreshing UAT, Development and Test databases using EXPDP and IMPDP.
Involved in Issue resolution, User communication and interactions and regular support activities.
Monitoring Exadata X5-2 machines and applying Quarterly Full Stack Patches for different Exadata components like DB Nodes, Cell Nodes and IB Switches.
Additional responsibility
Taking care of backup failure issue
User creation and grant the required privileges
Involved on Performance issue L1 and L2 level.
Managing the growth of database by monitoring and space management.
Creating database as per the client requirement and managing database files.
Checking alert log files and to make necessary actions to rectify them.
PSI Technologies June 2012 – August 2016
Role: Junior Oracle DBA
Key Responsibility Areas
Supporting Oracle database (10g R2 and 11g R2).
Oracle user creation and resolving space issue on tablespace level.
Scheduled the backup job in crontab.
Creating and Managing User.
Generating and analyzing AWR reports for DB performance analysis.
Resolved various tickets pertaining database issues.
User creation and taken care of tablespace level issue
Managing backup report and taking action based on backup failure
Performing export and import for schema /table level refresh based on customer request.
Taking care of backup failure issue
User creation and grant the required privileges
Involved in Performance issue L1 and L2 level.
EDUCATION
Bachelor of Science, Mumbai (March 2011)
CERTIFICATIONS
Masters in Data Science by Simplilearn and IBM (2021)
Oracle Cloud Infrastructure Associate (2022)
Oracle Database Administrator Professional 19c