Oracle Database Administrator Resume Suitland, MD - Hire IT People

SUMMARY:

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups using Datapump.
Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
Knowledge in UNIX platforms includes HP, SOLARIS, AIX, Centos and LINUX.
Able to configure recovery catalog for RMAN
Very verse with Oracle Quarterly Security Patches using OPatch Utility.
UNIX based operating systems especially Redhat Linux, comfortable with command line operations, scripts for hot backups, SQL*Loader, export and import of database.
Proficient with Database Cloning, Upgrading, Migration and Patching of Oracle Databases.
Installed Oracle Software ( 10g, 11g & 12c)
Experience in implementing Datapump, conventional Export/Import (Oracle 11g) for migration and logical backup of database.
Skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One - off Patch) and perl based utility “opatch”.
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.
Experience in maintaining Database Security using auditing, least privilege principles.
Experience in doing upgrades including maintenance & monitoring implementation.
Knowledge in configuring ASM (Automatic Storage Management)
Worked on Data transfer with export/import utilities and Data pump.
Knowledge in performance monitoring/tuning/troubleshooting using (OEM, SQL developer).
Familiar with Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
Knowledge about high availability products such as Real Application Cluster (RAC) in Oracle 11gR2 Grid on ASM file systems.
Involved in RAC Installation (Oracle Database Creation and documentation)
Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g servers for the purpose of disaster recovery procedures.
Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

TECHNICAL PROFICIENCIES:

Operating Systems: Redhat linux 5.9, Sun Solaris 11.3. AIX 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x., 6.x Linux Enterprise Server 9, 10. Windows 95/98/2000/7/8.

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, Basic understanding of UNIX Shell Scripting,

Tools: SQL DEVELOPER,TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, Toad, Putty, Winscp, Remote Desktop Connection, VNC, Team Viewer, and Cisco VPN Client

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import, Sql Developer

PROFESSIONAL EXPERIENCE:

Confidential, Salt Lake City, UT

Oracle Database Administrator

Responsibilities:

Supporting multiple databases for production, stage, test, unit test, engineer and development environments on Redhat Linux and Solaris Platforms.
Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
Refreshing Dev and Test instances with data from Production on a regular basis.
Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
Involved in installation, setup and creation of two node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.9.
Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3.
Database Security Implementation in accordance with company policies. Collaborates with Security Team and System Administrators to achieve this goal.
Daily Database Maintenance using WINSCP, TOAD, SQL DEVELOPER SQLPLUS & OEM (Oracle Enterprise Manager).
Refresh Databases and Database objects as necessary.
Installation and configuration of Oracle on various clients.
Backup and Recovery using Rman
Upgrade Oracle 11.2.0.1 to Oracle 11.2.0.4 using dbua as well as scripts (utl112i.sql, catupgrd.sql)
Apply Oracle quarterly patches ( PSU/CPU) using Opatch Utility
Adheres to Oracle Security Implementation by managing user accounts, monitoring tablespace growth and reporting suspicious database activities
Enable auditing at database level (audit sys operation activities).

Environment: Oracle 10g, 11g &12C, Solaris 11.3, Redhat 6, Windows 7, WINSCP,CYGWIN, TOAD, RMAN, SQL DEVELOPER, SQLPLUS, OEM.

Confidential, Suitland, MD

Oracle Database AdministratorResponsibilities:

Extensive experience in 24*7 production database support.
Successfully upgrade Test and Production Database from11.2.0.3 to 11.2.0.4.
Providing operational and technical guidance as required.
Interacting with developers on Oracle support teams.
Providing database performance monitoring.
Providing database space management.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Suse Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Suitland, MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship