Post Job Free
Sign in

Database Administrator Sql Developer

Location:
Dayton, NJ, 08810
Posted:
March 19, 2023

Contact this candidate

Resume:

Komal Vishwajit Kamble

Oracle DBA/ RAC/ Goldengate/ Exadata/ Upgrade/ Data Guard/RMAN

*****.*********@*****.***

732-***-****

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



Contact this candidate