RAMESH BHEEMANATHI

+91 8317652843 rameshbheemanathi1991@[Link] Hyderabad

PROFILE • ABOUT ME

Working as an Oracle Database Administrator (Oracle DBA) with Star Health Life Insurance Client under the payroll
company called Spyder Innovative Data Systems Pvt Ltd from April 2018 to till date .

SKILLS

Oracle DBA Experience:

Over 4 years of experience in as an Oracle DBA (19c/18c/12c/11g) in Production, Testing and
Development environment.
Worked in 24x7 production environment and provided on-call and day-to-day support. Migra
Conversation of Non-ASM Single Instance to ASM
Manage RAC environment for Day to Day Database administrator, Performance Tuning.
Strong trouble shooting, problem solving, analytical and design skills.
Expertise in Oracle 19c/12c/11g Data Guard and standby databases, Snapshot maintenance and
creation. Expertise in Oracle Enterprise Manager (OEM).
Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies
using RMAN.
Expertise in installation and configuration of Oracle and large databases on Linux and Solaris Operating
System.
Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the
database using operating system and Oracle security features.

WORK EXPERIENCE

Maintenance of Oracle Production, Development, Testing and QA databases. Installation and configuration of Oracle
19c,12c and 11g databases. End-user requests in terms of assisting them in effectively create tables, views, packages,
sequences, schema refreshes.
Worked with Client Audit Team to get the Quarterly audit done.
Preparing SOP for Multiple Activities (Refreshes/Patching/Disk Resize). Alert monitoring and
Ticketing.
Disk group Resize at Grid Disk Level and ASM level.
Creation of users and Granting them privileges and roles.
Performed upgrades from Oracle 11g to 12c.
Data Guard Setup & Administration for Active Data Guard, Snapshot standby, Physical Standby.
Restore Databases using RMAN in single instance database and Data Guard environments.
Supporting customer to perform HA Testing, DR tests.
Environment Provisioning which includes Oracle Home Binaries installation, Database creation, Patching, listener set
up, huge pages implementation.
Implementation of Huge Pages on Linux server to improve DB performance and Cluster ware.
Managing and implementing SCAN listener configuration, deployment, and connectivity
 Creating database users and by setting the default & temporary tablespaces, assigning quotas,
roles, privileges, and profiles to users.
 Configured Data guard and maintaining Zero data loss by enabling active data guard.
 Performed the DRILL (SWITCHOVER and SWITCHBACK) activities for critical production and
 Standby databases in Standalone.
 Performing rman restoration from Non ASM to ASM and vice versa.
 Providing DBA support to multiple databases in Production, Development and TEST Servers
 Good experience in Oracle Binaries Installation & Data base Creation.
 Resizing of data file according to the requirement.
 Creating and assigning appropriate roles and privileges to users depending on the user
 activity.
 We are performing schema and table stats gather activity to improve performance.
 Performed Daily checks, disk space management
 RESPONSIBILITIES

• Daily health checks on all servers, resolving the issues and updating the status with client.
• Experienced in providing 24X7 support to maintain all Databases up and running in production environment
• Creation of users, profiles and limiting user sessions in database.
• Database security- Creating roles, grant/revoke Privileges and roles to user.
• Managing schema objects like tables, indexes, views.
• Monitoring and performing RMAN backups.
• Finding long running queries running on database
• Re-organizing the tables and schema level refresh based on customer request.
• Deploying schema refresh with Export/Import & Data pump utility.
• Performed hot and cold backups, logical backups and user managed recoveries and RMAN recoveries.
• Cloning the database using RMAN and Hot backup.
• Performance-tuning services for clients with ADDM, AWR, ASH and troubleshooting databases using oracle utilities.
• Configure LISTENER & TNSNAMES files & troubleshooting.
• Review alert logs files to check for any problems related to databases.
• Working with Space Management Alerts (Data file, max extents and database file system alerts. Example: Archive log file
system alerts.).
• Performed RMAN Point in time Database recovery on oracle 11gR2.
• Working with traditional and data pump utility for the selective data export and import on production/test/dev on
client/online team request basis.
• Using STATSPACK/AWR to generate the report to check the performance and ADDM report recommendations.
• User Management and Security Management Activities to meet Company Standards.
• Creation of Clone Databases for non-production environments using RMAN and User managed backups according to the
client requirements.
• Database links were created to access the data from remote databases.
• Monitoring the Top sessions and Top sql queries in the Database.
• Performing database refresh with Prod copy as per the requirement using rman duplicate.
• Handling the schema refreshes or selective objects export and imports from one database to another servers, based on
client requests.
• Implementation support to Installation of Oracle rdbms software, client software in Production Servers and Development
Servers in Linux platforms.
• Production Database Support Monitoring sessions and DC to DR Log sync.
• Applying CPU and PSU patches in oracle database.
• Resolving archive log gaps using rman incremental backup.
• Weekly once analyzing the index structure and rebuild it due to performance.
• Monitoring database activity for specific client performance issues.
• Installation of 11g, 12c Database on UNIX Platform.
• Daily monitoring, Daily Hot backup, Weekly cold back of Databases.
• Database Maintenance Activities of Gather Stats and Index Rebuilding.
• Cloning from Hot backup of database and Patching.
• Creating Schema objects like Tables, Views, Indexes, Synonyms etc.
• Assigning Roles to the Users, Assigning Responsibilities to users.
• Applying user’s scripts on production and UAT Environments.
• Performing of Housekeeping of databases on weekly basis and monthly basis.
• Performing database RMAN backup via scripts using crontab and database scheduler jobs.
• Checking alert log files for both production and standby databases, checking free space of database table spaces, mount
points and server memory on daily basis to run the databases smoothly without any issue.
• Performing database online and offline database re-organization for database enhancement.
• Creating Users, Creating Profiles and Assigned Privileges to Users.
• Taking Backups and Restoring Backups Using RMAN.
• Upgrading oracle database from [Link] to [Link]
• Involved in Installation and Configuration of Oracle 12c and 18c Database.
• Enrolling new users and maintaining system security (Profiles), Roles, System and object Privileges and managing user
quotas.
• Performed exports and imports according to the client requests
• Refreshing the Materialized views.
• Customize the daily tasks using shell scripts as well as enhancement existing scripts.
• Working on Service request and Incidents.
• Scheduling the CRON jobs i.e. daily export Backups, housekeeping jobs and taking necessary actions in case of any job
failures.
• Performed Installation, Upgradation of RDBMS software and CPU patching.
• Setup and maintenance of RMAN.
• Creating and Managing tablespaces, other database objects and resolving related space management issues.
• Creation Users and Creation Roles and Grants, Revoke.
• Schema Refresh and Table Refresh. Using expdp and impdp.
• Cloned oracle database from production instance to test instance.
• Upgraded ASM from [Link] to [Link] in all the Production and Dev servers.
• Performed Point in time recovery and Restored Oracle database using RMAN utility.

COMPUTER PROFICIENCY

Windows
EDUCATION

BACHELOR OF TECHNOLOGY

SPHOORTHY Engineering College in the year of 2014.

LANGUAGES

English
Telugu
PERSONAL INFORMATION

Father’s Name: [Link] Bheemanathi

Birthday: 02/Jan/1991 Marital Status: Unmarried
Gender: Male Nationality: India