Oracle Database Administrator Resume Warsaw, IN - Hire IT People

SUMMARY

Oracle Database Administrator with over 7 years of experience designing, installing, upgrading, and maintaining databases in large - scale UNIX/LINUX environments.
I have extensive knowledge and proficiency in database design, monitoring & tuning, Migration, Upgrades, Backup & Recovery, Cloning, Replication and security Implementations.
I have worked on different version of Oracle including 10g, 11g, 12c, and 18c operating across different platforms such as Linux, UNIX, Solaris, and Windows.
I have a great interpersonal skills and the ability to work as a team player as well as individually. Seeking an Oracle Database Administration position in an organization where I can expand on my knowledge and contribute to the company’s growth.

AREA OF EXPERTISE

Installation, configuration, capacity planning
Database Security and Migration
Performance Monitoring & Tuning
Backup & Recovery
Database Security and Patching
Oracle ASM & Grid Control
Oracle Data Guard
Oracle Exadata
Oracle Golden Gate
Oracle ASM(clusters) and RAC configuration and administration
Backup & Recovery using RMAN
SQL, PL/SQL, UNIX Shell Scripting
Database migration using Exp/Imp/Datapumps, and SQL Loader
Database Security
Oracle Golden Gate (Data Replication)
Oracle Data Guard installation/administration for High availability and Disaster Recovery

PROFESSIONAL EXPERIENCE

Confidential, Warsaw, IN

Oracle Database Administrator

Responsibilities:

Install and configured Oracle 10g, 11g, and 12c software on LINUX operating system.
Support daily administration, monitoring, tuning, and troubleshooting databases on single instance.
Fix various database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and Active Session History (ASH).
Perform database migration from 10g to 11g and database upgrade from 11g to 12c using RMAN Duplicate and DBUA respectively.
Used SQL Developer to connect to databases, navigate tables inside databases, create tables and other database objects with GUI, insert data into tables, and create reports.
Deploy Database security policy and installation using passwords privileges in user profiles. Used Oracle Transparent Data Encryption(TDE) to encrypt tables and Tablespaces
Install and administer Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution ( DATA GUARD)
Configure and manage ASM instance on Oracle 11g and 12c.
Plan and perform backup and recovery using RMAN based on SLAs, test backup for corruption.
Perform data and metadata migration to newly installed servers using Data Pump Expdp/Impdp

Confidential, Louisville, KY

Oracle Database Administrator

Responsibilities:

Performed daily maintenance including monitoring backup, managing disk space, and maintaining database objects
Participated in on-call rotation and worked occasionally after hours or on weekends
Cloned and refreshed databases 05
Monitored and responded to alert from clients databases
Created databases from Entity Relational Diagrams ( ERD)
Configured Oracle tools like SQL*Net to access the database across network
Applied Oracle’s quarterly Critical Patch Update(CPU/PSU application) using Opatch utility to install, test, and deploy patches to all database instances
Interacted with users and troubleshoot problems related to privileges and resources
Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecture.

Confidential, Indianapolis, IN

Oracle Production Support Database Administrator

Responsibilities:

Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
Implemented recovery strategies and successfully recovered databases using RMAN.
Worked on Installation and maintenance of Oracle 11g, 12C RAC databases.
Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Provided 24X7 supports for all the production and development databases.
Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
Successfully performed migrations from Oracle 10g to 11gR2 RAC (Real Application Cluster) Database.
Successfully upgraded databases from 11g to non CDB 12c.