Oracle DBA Resume

SUMMARY:

I have 3.3 YEAR of experience in Oracle DBA, specifically supporting Database environment, including Installation, Administration, Maintenance, Upgrades and Remote support in Linux/Unix/Aix/Windows Environment.
Installation & Up gradation and configuration of Oracle Database 10g/11g/12c
Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Database.
Check Mail & Alert Log File Errors and Make Necessary Actions to Rectify Them.
Creating & dropping users, Locking/Unlocking/Password Reset of users, granting & revoking privileges, controlling resource usage with profiles, roles etc.
Good knowledge on Managing Oracle Instance and Physical files ( relocating and resizing online redo log files, control files and data files)
Knowledge on Monitoring Database growth through Database dictionary base tables and dynamic views.
Take hot backups and logical exports of the databases
Backup, Restore & Trouble shooting in 24/7 Production, Test, Dev environment’s.
Hands on experience in Cloning of production database to the test environment using Recovery Manager (RMAN)
Experience in Table space Reorganization, Instance Management.
Sync Standby database which is lagging behind from Primary database.
Co - ordinating with the support teams and user to get the Issue/Request resolved
Respond to queries and Report to your Team Leader on all activities undertaken at the Client site
Following the support guidelines as per documented procedures and ensure the Escalation Procedures are followed
Proactively monitoring the database’s health and taking preventive or corrective action as required
Creation of new tablespaces, Add / resizing the data files and taking care of tablespace-related issues
ASM DISK management (creating disk groups, adding/removing disks to/from disk-groups) When Required
Generating various reports by querying from database as per need.
Database inventory handling
Patching the databases using Quarterly and also if necessary for bug fixing
Good knowledge on ITSM Work functionality
Design and implementation of Tablespace, database, file system monitoring scripts
AWR,ASH, ADDM Report Generation and analysis
Export/Import of Tables, schemas, Tablespace, Database using traditional and datapump tools.
Working on Oracle Vulnerability as per security team mails. - We will proactively work and secure the database with future attacks
If needed Raising SR with Oracle support - keep track on preparing RCA
Ensure that the database is supported during all the non and operational 24/7 hours
Troubleshooting/Database Connectivity Issues.
Databases monitoring using OEM 12c
Knowledge and Configuration of DataGuard.
Having woking Knowledge on RAC & Data guard & ASM.

TECHNICAL SKILLS:

Databases: Oracle 10g/11g/12c DBA

Database Administration: Database architecture, Backup and Recovery, Cloning, Installation, Creation, Configuration.

Tools: & Utilities: Export/Import, Expdp/Impdp (data pump), OEM, RMAN, BMC Remedy Tool, Citrix, ADRCI,ASMCMD,netca,netmgr, Service Now

Platform: Linux, Unix, Aix, SunOS, Windows Server s

Languages: SQL

Others: Putty, WinSCP, Vmware, VNCserver

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential

Responsibilities:

Datafile recovery using RMAN
Applying CPU, PSU and other patches using Opatch utility
Handling the Database refresh, Schema refresh, Table refresh activities of databases
Oracle Db Up-gradation 10gR1 to 10gR2 & 11gR1 (11.1) to 11gR2 & 12c
RMAN disk level backup restoration/recovery database
Performance Issue
Working on user requests
User management
Tablespace management
Resolving Tickets
Failed Backup checking analyzing the issue and re-running it.
Deploying scripts into production databases as per Change Confidential
As part of maintenance window (Linux/Windows team) restart of the databases.
Monitoring weekly offline backups and ensure complete backup completed successfully.
Housekeeping activity performing on required servers.
RMAN Restoration/Recovery (cloning) from production to Dev/QA databases using TAPE and Disk level backups.
DB Refresh, Schema refresh & Table refresh from Prod to Pre-Prod Server’s.
Capacity Planning
Database Inventory preparation
As per patching & Up gradation cycle, schedule change and applying patches and upgrading on respective time frame
Working on application related issues if user facing any connectivity, login issues and etc..,

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship