Talent's Information
-
Location
Bengaluru, India
-
Rate
$12.0 per Hour
-
Experience
12 Year
-
Languages Known
English,Hindi
Available for
About Nagesh
Having around 12 years of experience as Oracle database administrator with RAC, Exadata, ODA, OCI, EXACC and Goldengate
Having knowledge in configuring Data pump, Extract and Replicate Groups for database migrations and schema migration.
Experience in applying Exadata cell, Compute DB node, IB switches and DB patching.
Having experience in setting NSG rules, Block volume and boot volume replication in OCI.
Having experience in creating MT’s and DB’s and security rules in OCI.
Experience in applying DB patching on Cloud env.
Experience in GI and DB upgrade from 12.1.0.2 to 19c on Exadata and cloud env.
Experience in configuring database backups on Cloud env.
Having experience in migrating databases from legacy env to Exadata and ODA env.
Installation Oracle 12c,19c binaries using silent mode and GUI and Database Creation Manually and using DBCA
Good knowledge on performance tuning.
Working on SR's with Oracle Support and generating Exacheck, RDA report as per request.
Having experience on Installing grid agent on database servers.
Creating ASM database and adding space to the diskgroups.
Managing Oracle Users, Roles, and Privileges & Creating Database Objects.
Setup and configured Oracle Physical Standby database (Data Guard)
Excellent Administration skills in handling RAC databases
Hands on experience in Oracle Utilities like Exp/Imp and Data Pump, RMAN
Knowledge in Backup and Recovery strategies like User managed backups and RMAN backup.
Performance Tuning and SQL Query tuning using utilities such as Explain Plan and AWR reports and ADDM report
Tech Stack Expertise
-
Oracle
Oracle 9I,Oracle11g,Oracle 10G,Oracle 11G,Oracle 11I
30 Years
Work Experience
DBA Developer
- January 2011 - February 2023 - 12 Year
- India
Projects
Support Project For Multiple Customers
- December 2019 - February 2023 - 39 Months
-
Provided 24*7 DBA Support for Database Administration, Backup/ Recovery,
Performance Tuning support for all the production databases achieving 100% SLA (Service Level Agreement).
Applying QFSDP patching every quarter on Exadata Env.
Applying PSU patching on cloud databases.
Upgrading GI and Databases from 12.1.0.2 to 19c on Exadata and Cloud Env.
Database Backup configuration on Cloud Env.
Creating New Standby databases and configuring with DGMGRL.
Performing switch over activities.
Working on Regular IM’s and CM tickets.
Working on DB refresh and Performance tuning tickets.
Support Project
- July 2016 - December 2019 - 42 Months
-
Provided 24*7 DBA Support for Database Administration, Backup/ Recovery, Performance Tuning support for
all the production databases achieving 100% SLA (Service Level Agreement).
Using SNOW ticketing tool to handle requests/queries of developers/users and resolving them remotely and providing them solutions with in SLA.
Performing daily health checks of RAC instances and databases.
Monitoring the database instances using SRVCTL.
Applying PSU patches to maintain servers up to date.
Upgraded database from 11.2.0.2 to 12c
Maintaining the load balance on both server side and client side.
Project Life Cycle (PLC)
- July 2014 - July 2016 - 25 Months
-
Delivering Database as a Service (DBaaS) using Oracle Enterprise Manager 12c. Dbaas provides a shared consolidated platform to provision database services. A dbaas really represents a management domain for databases where database installed in different network zones are managed from a single point.
Responsible for working on the production boxes which comprises of different types and versions of Operating Systems and administrating Oracle 10g,11g databases.
Upgrading databases from 10.2.0.4 to 11.2.0.4 and 11.2.0.3 to 11.2.0.4
Planning and scheduling database migrations as per Client requirement.
Migrating databases from legacy to Exadata environment using RMAN and expdp/impdp.
Configuring backups for migrated databases.
Configured goldengate setup with bidirectional replication.
NOKIA BOLT
- September 2012 - July 2014 - 23 Months
-
Provided 24*7 DBA Support for Database Administration, Backup/ Recovery, Performance Tuning support for all the production databases achieving 100% SLA (Service Level Agreement).
Using SNOW ticketing tool to handle requests/queries of developers/users and resolving them remotely and providing them solutions with in SLA.
Performing daily health checks of RAC instances and databases.
Monitoring the database instances using SRVCTL.
Applying PSU patches to maintain servers up to date.
Maintaining the load balance on both server side and client side.
Upgraded database from 11.1.0.7 to 11.2.0.3.
Cloning the databases using RMAN hot/cold backups for testing in test environments as per the application team requirements.
Refreshing database schema using Export/Import, Data Pump utility as per the application team requirements
Performing Performance Tuning using Explain Plan, ADDM, AWR reports.
Creating Public and Private database links to communicate between the server and clients.
Export and import of tables, schemas and Full db as per development team req.
As per application team request creating users and providing access permission to users
Working with the application development team to resolve any performance related issues
Creation of Tablespaces and Space Management Security Policies like Managing Users and Profiles. Creation of Roles and controlling User Privileges. Database storage like managing the size and files of database and adding ASM disks to diskgroup.
Rebuilding of Indexes and analyzing of tables to ensure good performance of prod/Qa/test databases
PIMS (Publication Information Management System)
- April 2020 - September 2021 - 18 Months
-
Installation of oracle software on different platforms.
Monitoring various database activities like number of users memory usage, Alert log file, Trace files, Archive log files.
Creating database for Testing/Development.
Creation of additional tablespaces and adding data files to tablespaces whenever required.
Creating db-links, Materialized views as per the requirement.
Monitoring Table spaces and data files utilization.
Creation of oracle Users, Roles, Granting Privileges and Profiles.
Creating the Clone/refresh of database.
Planning for Backup and Recovery of database information and maintaining Hot Backups (Daily), Cold Backups (Weekly), Logical Backup (Daily) using Exports.
Managing Import and Export depending up on Requirement.
Managing Rollback Segments, Undo Tablespace, Redo logs, Control files, and Tablespaces.
Monitoring various database activities like number of users memory usage, Alert log file, Trace files, Archive log files.
Soft Skills
Industry Expertise
Education
in BSC,
Karnataka University- June 2006 - June 2009
